NEW QUESTION 1
You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE
tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B. It generates an error when creating the table because the wallet is close
• C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Answer: B

NEW QUESTION 2
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12C. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

• A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

Answer: D

NEW QUESTION 3
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

• A. You can conned as a common user by using the connect statement.
• B. You can connect as a local user by using the connect statement.
• C. You can connect by using easy connect.
• D. You can connect by using OS authentication.
• E. You can connect by using a Net Service name.
• F. You can connect as a local user by using the SET CONTAINER statement.

Answer: ACE

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

• A. The database must have multiplexed redo logs for the flashback to succee
• B. The database must be MOUNTED for the flashback to succee
• C. The database must use block change tracking for the flashback to succee
• D. The database must be opened in restricted mode for the flashback to succee
• E. The database must be opened with the RESETLOGS option after the flashback is complete.
• F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Answer: BE

NEW QUESTION 5
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?

• A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B. The change tracking file must always be backed up when you perform a full database backup.
• C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D. More than one database block may be read by an incremental backup for a change made to a single block.
• E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Answer: ADE

NEW QUESTION 6
Which three statements are true about SQL plan directives?

• A. They are tied to a specific statement or SQL I
• B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C. They are used to gather only missing statistics.
• D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• E. They instruct the optimizer to create only column group statistics.
• F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Answer: BDF

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

• A. 2, 1, 3, 4, 5, 6
• B. 1, 3, 4, 5, 6, 7
• C. 1, 4, 3, 5, 6, 7
• D. 2, 1, 3, 4, 5, 6, 7
• E. 1, 5, 6, 4, 3, 2

Answer: C

NEW QUESTION 8
You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

• A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
• B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
• C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
• D. A TOP-N query is created to limit the rows to 20 percent of the total rows

Answer: C

NEW QUESTION 9
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1.Create a policy to capture the privilege used by a user for privilege analysis.
2.Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5.Compare the used and unused privileges’ lists.
6.Stop analyzing the data.
Identify the correct sequence of steps.

• A. 1, 3, 5, 6, 2, 4
• B. 1, 3, 6, 2, 5, 4
• C. 1, 3, 2, 5, 6, 4
• D. 1, 3, 2, 5, 6, 4
• E. 1, 3, 5, 2, 6, 4

Answer: B

NEW QUESTION 10
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
What is the result?

• A. It executes successfully and creates an UNDO tablespace in HR_PD
• B. It falls and reports an error because there can be only one undo tablespace in a CD
• C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the comman
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the comman
• E. It executes successfully but neither tablespace nor the data file is create

Answer: E

NEW QUESTION 11
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
✑ Version: Oracle Database 12c Releases 1 64-bit
✑ Character set: WE8ISO8859P15
✑ National character set: AL16UTF16
✑ O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
✑ Version: Oracle Database 12c Release 1 64-bit
✑ Character set: AL32UTF8
✑ O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A. Transportable database
• B. Transportable tablespace
• C. Data Pump full export / import
• D. The DBMS_PDB package
• E. RMAN

Answer: D

NEW QUESTION 12
Which three statements are true about Automatic Workload Repository (AWR)?

• A. All AWR tables belong to the SYSTEM schem
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: CDE

NEW QUESTION 13
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?

• A. The ORACLE_BASE base parameter is not set.
• B. The installation is being performed by the root user.
• C. The operating system group that is specified should have the root user as its member.
• D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D

NEW QUESTION 14
Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?

• A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B. The optimizer can re optimize a query only once using cardinality feedback.
• C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enable
• E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Answer: ACD

NEW QUESTION 15
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true?

• A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C. The command will, create a common user whose description is contained in the root and each PD
• D. The schema for the common user C # # A_ADMIN can be different in each container.
• E. The command will create a user in the root container only because the container clause is not use

Answer: CD

NEW QUESTION 16
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?

• A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B. It fails because no SQL *Loader data file location is specifie
• C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D. It fails because no SQL *Loader control file location is specifie

Answer: AC

NEW QUESTION 17
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Multiple CDBs share certain PDB resources.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Patches are always applied at the CDB level.
• F. A PDB can have a private undo tablespace.

Answer: BE

NEW QUESTION 18
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA. EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA. EXAM_RESULTS table to the OCP schema?

• A. Execute FLASHBACK TABLE OC
• B. EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
• C. Recover the table using traditional Tablespace Point In Time Recovery.
• D. Recover the table using Automated Tablespace Point In Time Recovery.
• E. Recovery the table using Database Point In Time Recovery.
• F. Execute FLASHBACK TABLE OC
• G. EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

Answer: C