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

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. 

B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered. 

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

View Answer

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

A. SYS sessions, regardless of the roles that are set in the session

B. SYSTEM sessions, regardless of the roles that are set in the session

C. SCOTT sessions, only if the MGR role is set in the session

D. SCOTT sessions, only if the MGR role is granted to SCOTT

E. SCOTT sessions, because he is the owner of the table

F. SYSTEM session, only if the MGR role is set in the session

View Answer

Q3. You run a script that completes successfully using SQL*Plus that performs these actions:

1.Creates a multitenant container database (CDB)

2.Plugs in three pluggable databases (PDBs)

3.Shuts down the CDB instance

4.Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?

A. The seed will be in mount state.

B. The seed will be opened read-only.

C. The seed will be opened read/write.

D. The other PDBs will be in mount state.

E. The other PDBs will be opened read-only.

F. The PDBs will be opened read/write.

View Answer

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

Q5. Identify three valid methods of opening, pluggable databases (PDBs).

A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

D. ALTER DATABASE PDB OPEN issued from the root

E. ALTER DATABASE OPEN issued from that PDB

F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

View Answer

Q6. Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE SPLIT PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE TRUNCATE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE MOVE PARTITION

View Answer

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

SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘

+data/prod/myfile.dbf’

What is the result?

A. The file ‘+data. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

B. The file ‘+data. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

C. The file ‘+data. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is created. 

D. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data. 231.54769’ in the data dictionary removed. 

View Answer

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

View Answer

Q9. You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.

One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapseD. 

When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.

Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

A. Increase the value of the ASM_POWER_LIMIT parameter.

B. Set the DISK_REPAIR_TIME disk attribute to a lower value.

C. Specify the statement that adds the disk back to the disk group.

D. Increase the number of ASMB processes.

E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

View Answer

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

SQL > startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

Identify the reason the instance failed to start.

A. The PGA_AGGREGATE_TARGET parameter is set to zero.

B. The STATISTICS_LEVEL parameter is set to BASIC. 

C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

View Answer