Q1. You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.

Which two are possible if table updates are performed which affect the invisible index columns?

A. The index remains invisible.

B. The index is not updated by the DML statements on the indexed table.

C. The index automatically becomes visible in order to have it updated by DML on the table.

D. The index becomes unusable but the table is updated by the DML.

E. The index is updated by the DML on the table.

View Answer

Q2. You database is running an ARCHIVELOG mode.

The following parameter are set in your database instance: 

LOG_ARCHIVE_FORMAT = arch+%t_%r.arc 

LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ 

DB_RECOVERY_FILE_DEST_SIZE = 50G

DB_RECOVERY_FILE = ‘/u01/oradata’

Which statement is true about the archived redo log files?

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created only in the Fast Recovery AreA. 

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

View Answer

Q3. Which Oracle Database component is audited by default if the unified Auditing option is enabled?

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Real Application Security

View Answer

Q4. You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

A. It succeeds because the PDB_ADMIN user has the required privileges.

B. It fails because common users are unable to use the SET CONTAINER statement.

C. It fails because local users are unable to use the SET CONTAINER statement.

D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

View Answer

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

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B. Run the Automatic Workload Repository Monitor (ADDM).

C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

View Answer

Q6. After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.

What must you do to activate the new default value for numeric full redaction?

A. Re-enable redaction policies that use FULL data redaction.

B. Re-create redaction policies that use FULL data redaction.

C. Re-connect the sessions that access objects with redaction policies defined on them.

D. Flush the shared pool.

E. Restart the database instance.

View Answer

Q7. An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.

How would you guarantee that the blocks for the table never age out?

A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

B. Increase the database buffer cache size.

C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

D. Configure Automata Shared Memory Management.

E. Configure Automatic Memory Management-

View Answer

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

View Answer

Q9. Which three statements are true concerning the multitenant architecture?

A. Each pluggable database (PDB) has its own set of background processes.

B. A PDB can have a private temp tablespace.

C. PDBs can share the sysaux tablespace.

D. Log switches occur only at the multitenant container database (CDB) level.

E. Different PDBs can have different default block sizes.

F. PDBs share a common system tablespace.

G. Instance recovery is always performed at the CDB level.

View Answer

Q10. Which two statements are true about variable extent size support for large ASM files?

A. The metadata used to track extents in SGA is reduced. 

B. Rebalance operations are completed faster than with a fixed extent size

C. An ASM Instance automatically allocates an appropriate extent size.

D. Resync operations are completed faster when a disk comes online after being taken offline.

E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

View Answer