Q1. Which two statements are true about a common user? 

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs. 

B. A common user with the create user privilege can createother common users, as well as local users. 

C. A common user can be granted only a common role. 

D. A common user can have a local schema in a PDB. 

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace. 

View Answer

Q2. Yourdatabase is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. 

Examine the steps to restore the SPFILE and the control file to mount the database: 

1. Set D3ID of the target database in RMAN. 

2.Start the database instance by using the startup force nomount command in RMAN. 

3.Restore the control files from the backup. 

4.Mount the database. 

5.Restore theSPFILE from the autobackup. 

6.Create a PFILE from the recovered SPFILE. 

7.Restart the instance in nomount state. 

Identify the required steps in the correct order. 

A. 1, 2, 5, 3, 6, 4 

B. 1, 2, 3, 5, 6, 4 

C. 2, 1, 5, 7, 3, 4 

D. 2, 1, 5, 6, 7, 4, 3 

View Answer

Q3. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c? 

A. By default, EM express is available for a database after database creation. 

B. You can use EM express to manage multiple databases running on the same server. 

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface. 

D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express. 

E. You can create and configure pluggable databases by using EM express. 

View Answer

Q4. For which two requirements would you use the Database Resource Manager? 

A. limiting the CPU used per database call 

B. specifying the maximum number of concurrent sessions allowed for a user 

C. specifying the amount of private space a session can allocate in the shared pool of the SGA 

D. limiting the degree of parallelism of operations performed by a user or group of users 

E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions 

View Answer

Q5. You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week. 

One of the data files is corrupted and the current online redo log file is lost because of a media failure. 

You want to recover the data file. 

Examine the steps involved in the recovery process: 

1.Shut down the database instance. 

2.Start up the database instance in nomount state. 

3.Mount the database. 

4.Take the data file offline. 

5.Put the data file online. 

6.Restore the control file. 

7.Restore the database. 

8.Restore the data file. 

9.Open the database with the resetlog option. 

10.Recover the database withthe noredo option. 

11.Recover the data file with the noredo option. 

Identify the required steps in the correct order. 

A. 4, 8, 11, 5 

B. 1, 3, 8, 11, 9 

C. 1, 2, 6, 3, 7, 10, 9 

D. 1, 3, 7, 10, 9 

E. 1, 2, 6, 3, 8, 11, 9 

View Answer

Q6. Examine these Data Pump commands to export and import objects from and to the same database. 

The dba has not yet created users hr1 and oe1. 

$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table 

$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1 

What will happen when running these commands? 

A. expdp will fail because no path has been defined for the dumpfile. 

B. expdp will succeed but impdp will fail because the users do not exist. 

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas. 

D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively. 

View Answer

Q7. Which three RMAN persistent settings can be set for a database? 

A. backup retention policy 

B. default backup device type 

C. default section size for backups 

D. default destinations for backups 

E. multiple backup device types for a single backup 

View Answer

Q8. You are required to migrate your 11.2.0.3 database to an Oracle 12c database. 

Examine the list of steps that might be used to accomplish this task: 

1.Place all user-defined tablespaces in read-only mode on the source database. 

2.Use the RMAN convert command to convert data files to the target platform's endian 

format, if required. 

3.Perform a full transportable export on the source database with the parameters 

VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y. 

4. 

Transport the data files forall the user-defined tablespaces. 

5. 

Transport the export dump file to the target database. 

6.Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters. 

7.Perform an import on the target database by using the full and transportable_datafiles parameters. 

Identify the required steps in the correct order. 

A. 1, 3, 5, 4, 2, and 6 

B. 1, 2, 4, 6, 5, 3, and 7 

C. 1, 2,4, and 7 

D. 2, 4, 5, 6, and 7 

View Answer

Q9. Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? 

A. A job is specified as part of a program definition. 

B. A program can be used in the definition of multiple jobs. 

C. A program and job can be specified as part of a schedule definition. 

D. A program and schedule can be specified as part of a job definition. 

E. A program and window can be specified as part of a job definition. 

View Answer

Q10. Users report this error message when inserting rows into the orders table: 

ERROR atline1: 

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES 

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database. 

Which two must you do to fix this problem without affecting currently executing queries? 

A. drop and re-create the index 

B. coalesce the orders.ind index 

C. coalesce the indexes tablespace 

D. perform an on line table rebuild using dbns_redefir.ition. 

E. rebuild the index online moving it to anothertablespace that has enough free space for the index 

View Answer