1Z0-067 Exam Questions

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

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

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

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

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

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

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

In which three scenarios is media recovery required?

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

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

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

Examine the following set of RMAN commands: RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN { ALLOCATECHANNELchlDEVICETYPEDISK; EXECUTESCRIPTfull_backup;...

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

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

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

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

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

Which two statements are true about a multitenant architecture?

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

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

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

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

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

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

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

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

In which situation can you use Flashback Database?

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

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

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

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true?

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure: CR...

You must unload data from the orders, order_items, and products database tables to four files using the External Tables. CREATE TABLE orders_ext (order_id, order_date, product_id,...

Users report this error message when inserting rows into the orders table: ERROR atline1: ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES You determine...

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

Which four actions are possible during an Online Datafile Move operation?

Examine the command used to perform an incremental level-0 backup: RMAN>BACKUPINCREMENTALLEVEL0DATABASE; To enable block change tracking, after the incremental level 0 backup, you...

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

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

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

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

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

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

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

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

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

View the Exhibit showing steps to create a database resource manager plan. SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed. 3QL>execdbm...

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

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

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?