Which three statements are true about tablespaces in a multitenant container database (CDB)? (Choose three.)
You execute the following commands to audit database activities:
Which statement is true about the audit record that is generated when auditing starts after the instance restarts?
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table? (Choose two.)
Examine this command:
SQL> exec DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
Which three statements are true about the effect of this command? (Choose three.)
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?
Examine the portion of this Active Session History (ASH) report that is marked with a red rectangle:
Which two inferences can be drawn from the report?
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
What are three purposes of the RMAN “FROM SERVICE” clause? (Choose three.)
Which three statements are true about adaptive SQL plan management? (Choose three.)
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 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. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this. (Choose three.)
The current system change number (SCN) for a live database is 663571.
You decide to use the flashback table statement to flash back the customers table to SCN 662116.
After flashing back the customers table, you query It and decide to undo the effects of the flashback table command.
Which is the fastest way to do this?
Which four actions are possible during an Online Data file Move operation? (Choose four.)
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=TRUE;
Which statement is true?
What are three purposes of the RMAN “FROM” clause? (Choose three.)
You create a new pluggable database, HR_PDB, from the seed database.
Which three tablespaces are created by default in HR_PDB? (Choose three.)
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
The characteristics of the CDB are as follows:
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
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?
Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)
Which two statements are true when row-archival management is enabled? (Choose two.)
Which two statements are true about variable extent size support for large ASM files? (Choose two.)
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)
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?