Cert12c_067_1a30_passLeader

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

QUESTION 2 A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command: RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE; Which statement is true about the execution of the command?

QUESTION 3 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 Information Lifecycle Management (ILM) to automate data movement?

QUESTION 4 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 used?

QUESTION 5 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 for the successful execution of this command.

QUESTION 6 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_due+amt_due*l. 1WHEREcust_name='JAMES'; 1row updated. SQL> ALTER TABLE customers DROP COLUMN old_status; Table Altered SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES'; 1 row updated. SQL> COMMIT; SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES';. XIDSTART_SCNEND_SCNOPERATIONAMT_DUE --------------- ------------------ ------------ --------- ------------- 07002f00cl03000017063371706337 U3300 Why is it that only one update is listed by the Flashback Version Query?

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

QUESTION 8 In which three scenarios is media recovery required?

QUESTION 9 In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename the undotbs undo tablespace: ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

QUESTION 10 Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

QUESTION 11 Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?

QUESTION 12 Examine the following set of RMAN commands: RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN { ALLOCATECHANNELchlDEVICETYPEDISK; EXECUTESCRIPTfull_backup; } Which statement is true when the RMAN run block is executed?

QUESTION 13 Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error: ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error?

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

QUESTION 15 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 you recommend to improve the performance of the backup?

QUESTION 16 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 interval. Which three are prerequisites to fulfill this requirement?

QUESTION 17 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 directory = EXP_DIR dumpfile = export.dat include = table $ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1 What will happen when running these commands?

QUESTION 18 Which two statements are true about a multitenant architecture?

QUESTION 19 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_PREFIX = '/disk2/oracle/pdb2'; Which two statements are true?

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

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

QUESTION 22 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 the RMAN client by using the OSB user. 3.RMAN creates the backup pieces. 4.Run the RMAN backup command with the sbt channels. 5.OSB creates a backup job and assigns a unique identifier. 6.OSB creates a backup job request through the OSB sbt library. 7.OSB stores metadata about RMAN backup pieces in the OSB catalog. 8.OSB starts the backup operation. 9. OSB updates the RMAN catalog. Identify the required steps/operations performed in correct order.

QUESTION 23 You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

QUESTION 24 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; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which two statements are true about the statistics level parameter?

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

QUESTION 27 In which situation can you use Flashback Database?

QUESTION 28 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> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE; Which statement is true about the execution of the command?

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

QUESTION 30 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 analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?