1Z0-063 Exam Questions

Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PRE...

You execute the RMAN commands: RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST; Which task is performed by these commands?

In which three scenarios is media recovery required?

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

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

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

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

You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Identify two prerequisites...

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

Your database supports a Decision Support System (DSS)workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to an...

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

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

Which three statements are true about Oracle Restart?

Which three statements are true about persistent lightweight jobs?

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

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

Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6), po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTIT...

You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task: 1) Place all user-defined tables...

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

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

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

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space...

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten sin...

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

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Which three statements are true about automated maintenance tasks?

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 Secure Backup (OSB)?

Which three statements are true about compression of backup sets?

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): Which statement is true about granting the selec...

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES: Which two statements are true?

You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE clause specified. PLUGGABLE DATABASE Which statement is true about the database that is...

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to...

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format: 1. Make the tablespace read...

In which three situations must you use a recovery catalog?

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests?

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

You execute the commands to configure settings in RMAN: Then, you issue the following command to take a backup: Which statement is true about the execution of these commands?

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

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)?

You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH `/disk1/backups'; Which statement is true?

A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl/. Examine the...

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS tabl...

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

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

RMAN is connected to a target database instance and an auxiliary instance. You execute the command: What is the outcome?

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is cor...

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB...