Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 91:

  Which two statements are true about RMAN duplexed backups? (Choose two.)

  A. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

  B. It is only supported for backups to tape via media management interface.

  C. It is not supported for image copies.

  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

  E. Duplex backups can contain only data files and control files.

  Correct Answer: CD

  Reference: https://docs.oracle.com/cd/E15586_01/backup.1111/e10642/rcmbckad.htm

• Question 92:

  Which two statements are true regarding Oracle Data Pump?

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.

  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

  Correct Answer: AB

  References: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 93:

  The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.

  The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.

  A database with dbid=1423241 is registered in the catdb11

  catalog. Both the recovery catalog databases are open.

  In the CATDB12c database, you execute the commands:

  $rman

  RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c

  RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;

  What is the outcome of the import?

  A. It fails because the target database and recovery catalog database are of different versions.

  B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

  C. It succeeds but the database is not automatically registered in the RC12C catalog.

  D. It fails because RMAN is not connected to the target database with DBID=1423241

  Correct Answer: B

• Question 94:

  The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user. A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.

  In the CATDB12c database, you execute the commands: Srman RMAN> CONNECT CATALOG rc12c/pass12c@catdbI2c RMAN> IMPOST CATALOG rc1l/pwdcatl11@catdbl1 DBID=I423241;

  What is the outcome of the import?

  A. It fails because the target database and recovery catalog database are of different versions.

  B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

  C. It succeeds but the database is not automatically registered in the Rc12c catalog.

  D. It fails because RMAN is not connected to the target database with DBID=1423241.

  Correct Answer: A

  The version of the source recovery catalog schema must be equal to the current version of the destination

  recovery catalog schema. If they are not equal, then upgrade the schemas to the same version.

  References:

  https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

• Question 95:

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

  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 96:

  Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

  A. to store backup information of multiple databases in one place

  B. to restrict the amount of space that is used by backups

  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

  D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog

  E. to automatically delete obsolete backups after a specified period of time

  Correct Answer: ACD

• Question 97:

  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?

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

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

  C. A backup of pdb1 and pd5 must exist before executing the command.

  D. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

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

  Correct Answer: BE

  Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network. Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production workload. If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option. You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host. Otherwise, this is not a requirement.

• Question 98:

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

  A. Database Resident Connection Pooling

  B. Oracle Suggested Backup Strategy

  C. Database Vault in ORACLE_HOME

  D. Nondefaultblocksizetablespaces

  E. Configure Label Security

  Correct Answer: CE

• Question 99:

  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?

  A. DATE

  B. TIMESTAMP

  C. INTERVAL YEAR TO MONTH

  D. INTERVAL DAY TO SECOND

  E. TIMESTAMP WITH LOCAL TIME ZONE

  Correct Answer: BE

  Reference: http://docs.oracle.com/database/121/NLSPG/ch3globenv.htm#i1007084

• Question 100:

  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: A

  EM Express is built inside the database.

  Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.