Which two statements about the Process Monitor (PMON) process are true? A. PMON performs process recovery when a client process fails. B. During instance startup, PMON takes care of instance recovery. C. PMON performs listener registration. D. PMON restarts background…

Which statement is true about loading data by using the conventional path of SQL*Loader? A. Redo is not generated while performing conventional path loads. B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked, C. No exclusive locks…

Identify three key properties of a transaction in Oracle Database 12c. A. durability B. consistency C. concurrency D. isolation E. scalability F. manageability

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database? A. Automatic Storage Management (ASM) B. OS file system C. logical volume (LVM) D. clustered file system…

Exhibit below: Which three statements are true about terminating a session? A. Without any error, you can terminate the active session by executing:SQL> ALTER SYSTEM KILL SESSION ‘7, 15’; B. You can terminate the active session by executing:SQL> ALTER SYSTEM…

Which two statements are true about shared server sessions? A. No Program Global Area (PGA) is allocated for shared server processes. B. User Global Area is stored in System Global Area (SGA). C. Shared SQL Area is allocated from Program…

Which targets can be managed by using Enterprise Manager Cloud Control? A. Hosts and databases B. Hosts, databases, and application servers C. Application servers and web applications D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR) E. Databases,…

Which two statements are true regarding SQL*Plus? A. It has commands for performing database administration operations. B. It can be used in interactive but not batch mode for SQL commands. C. It has to be installed separately after the Oracle…

Which statement about CDB architecture is true? A. Oracle-supplied metadata resides only in the root container. B. A seed PDB can sometimes be opened for particular operations. C. Multiple PDBs with the same name can reside in the same CDB.…

As part of your Oracle Database 12c post-installation tasks, you run these commands: Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb What does this do? A. It enables the Oracle Data Mining option…