Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 81:

  Examine the command to duplicate a database:

  RMAN> DUPLICATE TARGET DATABASE TO cdb

  PLUGGABLE DATABASE pdb1, pdb5;

  Which two statements are true about the DUPLICATE command? (Choose two.)

  A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).

  B. A backup of pdb1 and pdb5 must exist before executing the command.

  C. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.

  D. The root and the seed database in the container database (CDB) are also duplicated.

  E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

  Correct Answer: BE

• Question 82:

  Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

  A. A DBA can check specific tables with the DMU

  B. The database to be migrated must be opened read-only.

  C. The release of the database to be converted can be any release since 9.2.0.8.

  D. The DMU can report columns that are too long in the converted characterset

  E. The DMU can report columns that are not represented in the converted characterset

  Correct Answer: ADE

  A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.

  D: Exceed column limit

  The cell data will not fit into a column after conversion.

  E: Need conversion

  The cell data needs to be converted, because its binary representation in the target character set is

  different than the representation in the current character set, but neither length limit issues nor invalid

  representation issues have been found.

• Question 83:

  Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)

  A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

  B. A job defined in a PDB runs only if that PDB is open.

  C. Scheduler attribute setting is performed only at the CDB level.

  D. Scheduler objects created by users can be exported or imported using Data Pump.

  E. Scheduler jobs for a PDB can be created only by common users.

  Correct Answer: BD

• Question 84:

  Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

  A. Oracle Data Pump

  B. Oracle Recovery Manager (RMAN)

  C. Oracle Label Security

  D. Oracle Database Vault

  E. Oracle Real Application Security

  Correct Answer: B

• Question 85:

  Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

  A. Default permanent tablespaces can be shared across pluggable databases (PDBs).

  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

  C. Each PDB can have its own default temporary tablespace.

  D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

  E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

  Correct Answer: BC

• Question 86:

  When is the UNDO_RETENTION parameter value ignored by a transaction?

  A. when the data file of the undo tablespace is autoextensible

  B. when there are multiple undotablespaces available in a database

  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  D. when Flashback Database is enabled

  Correct Answer: C

  Reference:

  http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention, see the bullets)

• Question 87:

  Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

  A. Database Resident Connection Pooling

  B. Oracle Suggested Backup Strategy

  C. Database Vault in ORACLE_HOME

  D. Non default block size tablespaces

  E. Configure Label Security

  Correct Answer: CE

• Question 88:

  You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

  A. DATE

  B. TIMESTAMP

  C. INTERVAL YEAR TO MONTH

  D. INTERVAL DAY TO SECOND

  E. TIMESTAMP WITH LOCAL TIME ZONE

  Correct Answer: BE

• Question 89:

  Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  A. By default, EM express is available for a database after database creation.

  B. You can use EM express to manage multiple databases running on the same server.

  C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

  D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

  E. You can create and configure pluggable databases by using EM express.

  Correct Answer: D

• Question 90:

  You issue the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

  A. switching the online redo log

  B. backing up all data files as image copies and archive logs, and deleting those archive logs

  C. backing up only the used blocks in the data files

  D. backing up all used and unused blocks in the data files

  E. backing up all archived logs and marking them as obsolete

  Correct Answer: ABD