1Z0-063 Exam Questions

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

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call. Which table organization allows for generating the bills w...

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

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

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

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace. You execute the command: RMAN> BACKU...

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

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

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command. What is the outcome?

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

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

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

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

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch use...

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

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

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

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

Examine the parameters for your database instance: NAMETYPEVALUE optimizer_adaptive_reporting_onlybooleanFALSE optimizer_capture_sql_plan_baselinesbooleanFALSE optimizer_dynamic_sa...

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

Which two statements are true regarding Oracle Data Pump?

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

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

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 To ensure faste...

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

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

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?

Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1. $expdp system/manager schemas = hr.oe di...

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

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

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; S...

View the Exhibit showing steps to create a database resource manager plan. SQL>execute dbms_resource_manager. create_pendingarea(); PL/SQL procedure successfully completed. SQL>exe...

You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. While opening pdb_1,...

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interva...

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

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

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

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

Which two statements are true regarding SecureFile lobs?

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

Identify two scenarios in which the RMAN crosscheck command can be used.

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire data...

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

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

A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow. What type of backup do y...

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

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target databa...

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?