Oracle Database 12c Essentials - 1z0-497 Exam Practice Test

A. 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;

B. 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;

C. 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';

D. 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;

A. changing configuration parameters, upgrading, or patching Oracle software

B. adding table partitioning

C. addition or removal of nodes, memory, or disks

D. dropped database object

E. table definition changes

F. operating system or storage device / driver failure

G. migrating to cluster architecture

H. database or application deadlocks

I. runaway processes that consume system resources

J. file deletion

A. Oracle-supplied metadata resides only in the root container.

B. A CDB can have an infinite number of PDBs.

C. A seed PDB can sometimes be opened for particular operations.

D. Multiple PDBs with the same name can reside in the same CDB.

E. You can create common users in PDBs.

A. It allows central management and administration of single databases.

B. It fully operates with RAC.

C. It ensures full backward compatibility with non-CDBs.

D. It is integrated with Enterprise Manager, but not with the Resource Manager.

A. Traditional Export / Import

B. SQL*Plus

C. Cold Backup

D. RMAN

E. Data Pump

A. performs database failovers

B. coordinates site failovers

C. replaces the functionality of Oracle Clusterware and Oracle RAC

D. performs data replication

E. works seamlessly with Oracle Site Guard

A. Automatic SGA Memory Management

B. all server-generated alerts

C. Oracle Database Trace files

D. object-level statistics

E. Oracle Database alert.log file

A. all sessions for which database users have access privileges to the PERSONS table

B. all sessions of the HR user

C. the session of the HR user that executed the commands

D. all sessions of the HR user and the SYS user

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

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

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

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

A. You can clone only one PDB (either PDB1 or PDB2) into the same CD

B. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

C. Cloning a PDB can use the source files copy method to the target PDB files.

D. You cannot do this, because you can only clone PDBs into another CDB.