Oracle Database Administration I : 1Z1-082

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

• A. analysis of all privileges used by all users but excluding administrative users in the database
• B. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• C. analysis of all privileges used by all users including administrative users in the database
• D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
• E. analysis of privileges that a user has on their own schema objects that they did not use
• F. analysis of privileges that a user has on their own schema objects that they did use

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A. Rolling back to a SAVEPOINT can undo a DELETE statement
• B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• C. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• D. A SAVEPOINT does not issue a COMMIT
• E. Only one SAVEPOINT may be issued in a transaction

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

• A. 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
• B. A table can have only one primary key but multiple foreign keys
• C. A table can have only one primary key and one foreign key
• D. Only the primary key can be defined at the column and table level
• E. Primary key and foreign key constraints can be defined at both the column and table level
• F. 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
• G. The foreign key columns and parent table primary key columns must have the same names

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B. T1, an index segment for the primary key, and a LOB segment only
• C. T1 only
• D. T1 and an index segment created for the primary key only
• E. no segments are created

Examine this command and some partial output:

Why does the DB01.abc.comservice show unknown status?

• A. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
• B. The service DB01.abc.com is statically registered
• C. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• D. The listener is not listening on the default port 1521
• E. The service DB01.abc.com is dynamically registered