1Z0-067 Exam Questions

When is the UNDO_RETENTION parameter value ignored by a transaction?

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

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?

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

You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> BACK...

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. W...

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?

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

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

For which three pieces of information can you use the RMAN list command?

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

Which three statements are true about a job chain?

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. Examine the steps to recover this table from an RM...

Examine the command: SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; In which two scenarios is this command required?

Which two are prerequisites for setting up Flashback Data Archive?

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. You want to check the diagnostic files created as pa...

You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of p...

You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. Ho...

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only...

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): SQL> CREATE USER c##a_admin IDENTIFIE...

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter resuma...

Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to seven days in RMAN. - The most recent backup to disk fo...

You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two...

Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr ---------------...

Which three statements are true about persistent lightweight jobs?

You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

Which two statements are true about unified auditing?

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and a...

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which...

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manag...

Which three types of failures are detected by the Data Recovery Advisor (DRA)?

You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps: 1. Iss...

Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' You execute the following command to create the CDB1. container datab...

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1.Create media families for data files and archived redo log files. 2.Configure database backup storage...

Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the back...

The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL...

You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/...

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

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

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true?

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

You issue the command: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command?

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the com...

Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL>...

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: 1. Create a policy to capture the privileges used by a us...

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connec...