1Z0-063 Exam Questions

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

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

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:

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be u...

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

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

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

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.

You are administering a multitenant container database (CDB). Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

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

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

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 restore and recover your database to anew host by using an existing RMAN open database backup. Which step must you perform next?

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

Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

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

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

In which situation can you use Flashback Database?

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 to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE 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...

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 have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the db_smart_flash_...

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be automated when using Infor...

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

Which two statements are true about Flashback Version Query?

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?

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

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

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

Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output: SQL>UPDATEcustomersSETamt_due=amt_...

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 theCDB1. container databa...

When is the UNDO_RETENTION parameter value ignored by a transaction?

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

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 steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB): 1) Start the RMAN client by using the RMAN target / command. 2) Start t...

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

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

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

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

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

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

Which three statements are true about Consolidated Database Replay?

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

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

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

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

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

Which two statements are true about a common user?