1Z0-067 Exam Questions

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You...

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX- based Oracle 12c database: CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCO...

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: SQL>STARTUP Whic...

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_wait...

Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FO...

Examine the command: $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statem...

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it h...

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYS...

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and you need to avoid any ou...

Which two statements are true regarding the Oracle Data Pump export and import operations?

You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno...

Which two statements are true when row-archival management is enabled?

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure,...

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows: SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBE...

Which two statements are true regarding SecureFile lobs?

Which three statements are true about compression of backup sets?

Which three statements are true about the database instance startup after an instance failure?

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: SQL> CREATE U...

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors: SQL> startup ORA-00824:cannot set SGAJTARGET or MEMORY_TARGET dueto existing internalsetti...

Which three requirements must be met before a tablespace can be transported across different platforms?

Examine the output: SQL > ARCHIVE LOGLIST Database log modeArchive Mode Automatic archival Enabled Archive DestinationUSE_DB_RECOVERY_FILE_DEST Oldest online log sequence376 Next l...

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

In a database supporting an OLTP workload, tables are frequently updated on both key and non- keycolumns. Reports are also generated by joining multiple tables. Which table organiz...

Which two statements are true about dropping a pluggable database (PDB)?

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: S>sqlldrhr/hr@pdb table=employees Which two statem...

Which three RMAN persistent settings can be set for a database?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recove...

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

Which two statements are true regarding Oracle Data Pump?

Which two are prerequisites for creating a backup-based duplicate database?

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 RCII...

Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance. LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHI...

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

Which two statements describe the relationship between a window, a resource plan, and a job class?

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation...

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

Which two statements are true about roles in multitenant container databases (CDBs)?

You issue the RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which statement is true about the execution of the command? Choose the best answer.

Which two statements are true about making RMAN image copies of a database? Choose two.

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command: SQL> GRANT create tablespace to C##A_ADMIN; Which stat...

You execute the commands to configure settings in RMAN: RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE DATAFILE BACKUP C...

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user...

You use RMAN to take regular backups for your database. Examine the RMAN commands: RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP; Which statement is true?

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT. Examine the command: RMAN> LIST FAILU...

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). Examine the steps required to perform the migration: 1. Use Da...

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? Choose the best answer.

Which two statements are true about encrypted backups performed by using RMAN? Choose two.