Identify three benefits of Unified Auditing. (Choose three.)
Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c? (Choose five.)
Oracle Data Redaction is active on the SCOTT.EMP table.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
Which is guaranteed to be true concerning the redaction policy?
Your multitenant container database (CDB) is running in archivelog mode. Fxamlne this command and its output:
You issue this command in RMAN:
RMAN>BACKUP PLUGGABLE DATABASE "CDBSROOT", pdb2_l;
What is the outcome?
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disruption to availability is required.
Which three statements are true about this requirement? (Choose three.)
The tnsnames.ora file has an entry for the service alias ORCL as follows:
The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)
You plan to use the Flashback Drop feature to recover the sales_emp table that was dropped in error. No other table with the same name exists in the sh schema, which owns the table. You query the recyclebin and find multiple entries for the salesemp table:
SQL FLASHBACK TABLE sale_emp To BEFORE DROP:
What would be the result?
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)
On your Oracle 12c database, you issue the following commands to create indexes:
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which statement is correct?
You performed an incremental level 0 backup of a database:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
What is the result?
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)
What is the result of executing a TRUNCATE TABLE command on a table, in a non-CDB database, that has Flashback Archiving enabled?
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output? (Choose three.)
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? (Choose two.)
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?
You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the MD_BACKUP command to back up the ASM metadata regularly.
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
Which three functions are performed by the SQL Tuning Advisor? (Choose three.)
On your Oracle 12c database, you invoked SQL*Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)
Which two are prerequisites for performing a flashback transaction? (Choose two.)
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
Identify the reason the instance failed to start.
Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users c# #A admin and B_ADMIN have only connect privileges.
You create a common role c##_role1 with common privileges create table and select any table.
You then execute these commands to grant the role to users In the root container:
SQL> GRANT c##_role1 TO c##_a_admin CONTAINER=ALL;
Then,
SQL> CONN sys/oracl««HR_PDB as sysdba
SQL> GRANT C# #_role1 TO b_admin CONTAINER=CURRENT;
Which two statements are true?
You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)
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 three storage options support the use of HCC? (Choose three.)