Q1. Which statement is true aboutthe loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)? 

A. The PDB is closed and the temp file is re-created automatically when the PDB is opened. 

B. The PDB is closed and requires media recovery at the PDBlevel. 

C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened. 

D. The PDB does not close and starts by using the default temporary tablespace defined 

for the CD 

View Answer

Q2. Examine the command and its output: 

SQL> DROP TABLE EMPLOYEE; 

SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; 

RECYCLE_NAMEORIGINAL_NAMETYPE 

binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE 

You then successfully execute the command: 

SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; 

Which two statements are true? 

A. It flashes back the employee tableand all the constraints associated with the table. 

B. It automatically flashes back all the indexes on the employes table. 

C. It automatically flashes back any triggers defined on the table. 

D. It flashes back only the structure of the table and not the data. 

E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost. 

View Answer

Q3. You execute the RMAN commands: 

RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST; Which task is performed by these commands? 

A. Corrupted blocks, if any, are repaired in the backup created. 

B. Only those data files that have corrupted blocks are backed up. 

C. Corrupted blocks in the data files are checked and repaired before performing the database backup. 

D. The database is checked for physicallycorrupt blocks and any corrupted blocks are repaired. 

View Answer

Q4. user_data is a nonencryptedtablespace containing tables with data. 

You must encrypt ail data in this tablespace. 

Which three methods can do this? 

A. Use Data Pump. 

B. Use ALTERTABLE. . .MOVE 

C. Use CREATE TABLE AS SELECT 

D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its 

E. Use altertablespace to encrypt thetablespace. 

View Answer

Q5. Which parameter must be set to which value toimplement automatic PGA memory management? 

A. Set memory_target to zero. 

B. Set STATISTICS_LEVEL to BASIC. 

C. Set pga_aggregate_target to a nonzero value. 

D. Set pga_aggregate_target and sga_target to the same value. 

E. Set sgajtarget to zero. 

View Answer

Q6. While performing database backupto tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. 

Which two actions would you take for tape streaming to happen during the backup? 

A. Configure backup optimization. 

B. Configure the channel to increase maxopenfiles. 

C. Configure a backup policy by using incremental backups. 

D. Configure the channel to increase capacity with the rate parameter. 

E. Configure the channel to adjust the tape buffer size byusing the 3LKSIZE option. 

F. Configure large_pool, if not done already. Alternatively, you can increase the size of 

G. LARGE_POOL. 

View Answer

Q7. You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; 

For which database users is the audit policy now active? 

A. all users exceptsys 

B. all users except scott 

C. all users except sys and scott 

D. all users except sys, system, and scott 

View Answer

Q8. Which three statements are true about Oracle Secure Backup (OSB)? 

A. It can encrypt client data written to tape. 

B. It can be used to take image copy backups to tape. 

C. It can be used to manage tape backup and restore operations for multiple databases. 

D. It can be used along with an RMAN recovery catalog for maintaining records of backups 

in a tape library. 

E. It can be used to perform file system backups at the file, directory, file system, or raw partition level. 

View Answer

Q9. Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? 

A. A DBA can check specific tables with the DMU 

B. The database to be migrated must be opened read-only. 

C. The release of the database to be converted can be any release since 9.2.0.8. 

D. The DMU can report columns that are too long in the converted characterset 

E. The DMU can report columns that are not represented in the converted characterset 

View Answer

Q10. You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. 

How can you detect the cause of the degraded performance? 

A. Enable Memory Access Mode, which reads performance data from SGA. 

B. Use emergency monitoring to fetch data directly from SGA for analysis. 

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots. 

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring, 

E. Run ADDM in diagnostic mode. 

View Answer