Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. Primary key and foreign key constraints can be defined at both the column and table level
• B. The foreign key columns and parent table primary key columns must have the same names
• C. A table can have only one primary key and one foreign key
• D. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• E. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• F. A table can have only one primary key but multiple foreign keys
• G. Only the primary key can be defined at the column and table level

Which three statements are true about Oracle synonyms? (Choose three.)

• A. A synonym created by one user can refer to an object belonging to another user
• B. A synonym can be available to all users
• C. Any user can drop a PUBLIC synonym
• D. A synonym cannot be created for a PL/SQL package
• E. A SEQUENCE can have a synonym

Which is true about roles?

• A. All roles belong to the SYSTEM schema.
• B. A role can be password-protected only if it has been granted system privileges.
• C. Roles containing object privileges can be created only by the object owner.
• D. A role can be granted to other roles.
• E. Roles can be created only by SYS or SYSTEM.

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:
Which three statements are true?

• A. The first rollback command leaves the inserted row locked.
• B. The first rollback command leaves the table's 100 original rows locked.
• C. The second rollback command rolls back the rollback to savepoint a command.
• D. The second rollback command restores the row that was inserted.
• E. The first rollback command restores the 100 rows that were in the table originally.
• F. The second rollback command restores the 100 rows that were in the table originally.
• G. The first RollBack command restores the row that was inserted.

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• B. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• F. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.