Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

• A. segments in tablespaces that have exceeded a critical or warning space threshold
• B. segments that have unusable indexes
• C. segments that have the highest growth rate in a database
• D. segments for tables created using ADVANCED ROW COMPRESSION
• E. segments that are sparsely populated and have more than 10% of free space below the high water mark.

Examine these statements:
DESC emp

INSERT INTO emp VALUES ( 101, 'John', 12000);
1 row created.
SAVEPOINT after_insert;
Savepoint created.
UPDATE emp SET salary=16000 WHERE empno=101;
1 row updated.
SAVEPOINT after_update;
Savepoint created.
DELETE FROM emp WHERE empno=101;
1 row deleted.
SAVEPOINT after_delete;
Savepoint created.
ROLLBACK TO SAVEPOINT after_update;
Rollback complete.
INSERT INTO emp VALUES ( 102, 'Emma', 12000);
ROLLBACK TO SAVEPOINT after_delete;
Which is the result and effect of this ROLLBACK?

• A. The ROLLBACK backs out all DMLS before after_delete.
• B. The ROLLBACK executes successfully but does not back out any DMLS.
• C. The ROLLBACK throws an error.
• D. The ROLLBACK backs out all DMLS until after_delete.

Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

• A. Transactions write their undo in the SYSTEM undo segment.
• B. Transactions fail.
• C. Transactions wait until space becomes available in UNDOTBS1.
• D. Transactions write their undo in a temporary tablespace.

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?

• A. Run catuppst.sql to perform revalidation actions
• B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
• C. Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.
• D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

• A. They are not terminated but may only issue queries.
• B. They are not affected.
• C. They are terminated after completing the transaction.
• D. They are terminated immediately.