최신 1z0-497 무료덤프 - Oracle Database 12c Essentials

A. PMON restarts background and dispatcher processes when they fail.

B. PMON resolves failures of distributed transactions.

C. PMON performs listener registration.

D. During instance startup, PMON takes care of instance recovery.

E. PMON performs process recovery when a client process fails.

A. You alter the salesprd source database to open in read-only mode, and start cloning the source
database:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

B. Connected as the salesprd local DBA, you create an XML using:
SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;
Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into
the development CDB using:
SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';

C. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and
execute this on the development CDB;
SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by
password;

D. You alter the salesprd source database to open in read-only mode:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
In the development CDB, you create a databaselink "PRD" that connects to the root of the source
CDB, and start cloning the source PDB:
SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

A. SCOTT has to re-execute the last command in the transaction after he commits the transaction.

B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C. The session is rolled back after receiving the error and JIM can continue with his transaction.

D. The session is terminated after receiving the error and JIM can continue with his transaction.

A. Traditional Export / Import

B. Data Pump

C. RMAN

D. Cold Backup

E. SQL*Plus

A. The bitmap index is rebuilt automatically after a DML operation.

B. The smallest amount of a bitmap that can be locked is a bitmap segment.

C. The DML operations re-create the bitmap index blocks.

D. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

A. It runs every 1 hour automatically.

B. The analyzed result is lost when the database instance is restarted.

C. It analyzes high CPU trend and identifies problems before they can threaten application performance.

D. It is shipped only with Oracle Enterprise Manager 12c.

A. Data Guard SQL Apply

B. Asynchronous redo transport with Data Guard

C. Active Data Guard Far Sync

D. Synchronous redo transport with Data Guard

A. It requires the database to be open.

B. It recommends solutions and quantifies expected benefits.

C. It implements all recommendations automatically.

D. It analyzes the performance of specified objects.

E. It retains snapshots in the SYSAUX tablespace until the database is restarted.

F. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

A. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

B. Real-Time ADDM uses AWR snapshots of the last 10 minutes.

C. Real-Time ADDM uses ASH recent activity from SGA data.

D. Regular ADDM uses AWR snapshots that are not yet purged.

A. The ORCL instance is registered statically in the listener.ora file.

B. The number of current client connections handled by the service handler is two.

C. The total number of client connections handled so far by the service handler is two.

D. The ORCL instance is registered dynamically with the listener.