Q1. Which two statements are true regarding the Oracle Data Pump export and import operations? 

A. You cannot export data from a remote database. 

B. You can rename tables during import. 

C. You can overwrite existing dump files during export. 

D. You can compress data but not metadata during export. 

View Answer

Q2. Examine the command: 

$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull 

Which statement is true about the execution of the command? 

A. It fails because the log file parameter is not specified. 

B. It fails because no absolutepath is specified for the log file and dump file. 

C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations. 

D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three. 

View Answer

Q3. Which two statements are true about scheduling operations in a pluggable database (PDB)? 

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level. 

B. A job defined in a PDB runs only if that PDB is open. 

C. Scheduler attribute setting is performed only at the CDB level. 

D. Scheduler objects created by users can be exported or imported using Data Pump. 

E. Scheduler jobs for a PDB can becreated only by common users. 

View Answer

Q4. The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. 

The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user. 

A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open. 

In the CATD3i2c database, you execute the commands: 

: r-ar. 

RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c 

RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; 

What is the outcome of the import? 

A. It fails because the target database and recovery catalog database are of different versions. 

B. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed. 

C. It succeeds but the database is not automatically registered in the rc:2c catalog. 

D. It fails because RMAN is not connected to the target database with r3:T=:42324:. 

View Answer

Q5. You issue the command: 

SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE; 

Which statement is true about the command? 

A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter. 

B. It creates a file that contains theSQL statement, which is required to re-create the control file. 

C. It updates the alert log file with the location and contents of the control file. 

D. It creates a binary backup of the control file. 

View Answer

Q6. In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. 

You rename the undotbs undo tablespace: 

ALTER TABLESPACE undotbs RENAME TO undotbs_old; 

Which statement is true? 

A. The tablespace will be renamed but the data file headers will not be updated. 

B. The statement will fail because you cannot rename an undo tablespace. 

C. The tablespace will be renamed and all the changes will be logged in the alert log. 

D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter. 

E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs. 

View Answer

Q7. You restore and recover your database to anew host by using an existing RMAN open database backup. 

Which step must you perform next? 

A. Execute catproc.sqi to recompile invalid PL/SQL modules. 

B. Open the database with the resetlogs option. 

C. Set a new database identifier (DBID) for the newly restored database. 

D. Use the RMAN set newname and switch commands to switch to new files. 

View Answer

Q8. A user issues a query on thesales table and receives the following error: 

ERROR at line 1: 

ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' 

ORA-27037: unable to obtain file status 

Which two actions would you take to recover the temporary tablespace? 

A. Drop the tenpOi.dbf file, and then re-create the temp file. 

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file. 

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database. 

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online. 

E. Create a new temporary tablespace and assign it as the default to the user. 

View Answer

Q9. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? 

A. Reduced logical I/O 

B. Reduced virtual memory utilization 

C. Improved Serial Execution performance 

D. Reduced physical I/O 

E. Reduced CPU utilization 

View Answer

Q10. In which situation can you use Flashback Database? 

A. whenundoing a shrink data file operation 

B. when retrieving a dropped tablespace 

C. when returning to a point in time before the restoration or re-creation of a control file 

D. when returning to a point in time before the most recent open resetlogs operation 

View Answer