Oracle Database 12c Essentials

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

Examine the command: SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ; Which two statements are true about the execution of the command?

Which three options correctly match environment variables with their specific functionality?

Identify the correct order of consolidation density.

Examine the commands: SQL> CONNECT sys@CDBl AS SYSDBA $QL>STARTUP MOUNT SQL> ALTER DATABASE cdbl MOUNT; Which four options represent what happens when these commands are executed?

Which two statements about switchover and failover are true?

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?