1Z0-067 Exam Questions

Which three statements are true about the SQL*Loader utility?

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the...

You are administering a multitenant container database (CDB) cdb1. Examine the command and its output: SQL>show parameterfile NAMETYPEVALUE ----------------------------------------...

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task:...

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs). You have already created a test system to support the cons...

Identify three benefits of unified auditing.

Examine the backup requirement for your company: 1) Every Sunday, a backup of all used data file blocks is performed. 2) Every Wednesday and Friday, a backup of all the changed blo...

What two are the prerequisites for enabling Flashback Database?

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the...

Which three statements are true about Oracle Secure Backup (OSB)?

LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID). SSL has been configure for the dat...

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the...

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privil...

Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup?

You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Increm...

Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; --(First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT em...

Which three statements are true about the keystore storage framework for transparent data encryption?

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i.Long-running...

You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle database software ins...

For which two requirements would you use the Database Resource Manager?

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin IDENTIFIED BY p...

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace. Which three methods can do this?

Which two statements are true about a common user?

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incr...

Which three statements are true about Oracle Restart?

Examine the parameters for your database instance: NAMETYPEVALUE ----------------------------------------------------------------------- optimizer_adaptive_reporting_onlybooleanFAL...

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO du...

A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037...

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. Th...

Which two statements are true about service creation for pluggable databases (PDBs)?

You want to move your existing recovery catalog to another database. Examine the steps: 1) Export the catalog data by using the Data Pump Export utility in the source database. 2)...

Examine the command and its output: SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE ----------...

Which parameter must be set to which value to implement automatic PGA memory management?

Examine the following set of RMAN commands: RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RKAN> RUN { ALLOCATE CHANNEL chl DEVICE TYPE DISK; EXECUTE SCRIP...

You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

Which three statements are true about Consolidated Database Replay?

Which two statements are true about Flashback Version Query?

Which three statements are true about unplugging a pluggable database (PDB)?

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the comma...

Examine the RMAN command: RMAN> BACKUP VALIDATE DATABASE; Which statement is true about the execution of the command?

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incom...

Examine the RMAN commands executed in your database: RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk; RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE...

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01...

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

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