Q1. You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A. The database must be running in archivelog mode.
B. Flashback Database must be enabled.
C. Fast Recovery Area must be enabled.
D. The recyclebin must be enabled for the database.
E. Undo retention guarantee must be enabled.
F. A database backup must be taken.
Answer: A,C
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
Q2. Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
C. It succeeds andall data files belonging to PD32_i are backed up along with the archive log files.
D. It fails because the pluggable clause is missing.
Answer: C
Q3. A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
A. Set the backup_tape_io_slaves parameter to true.
B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C. Configure large pool if not already done.
D. Remove the rate parameter, if specified, in the allocate channel command.
E. Always use RMAN compression for tape backups ratherthan the compression provided by media manager.
F. Always use synchronous I/O for the database.
Answer: B,C,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
Q4. Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?
A. All redo log files are opened.
B. The root, the seed, and all the PDBs are opened in read-write mode.
C. All the PDBs are opened in read-write mode.
D. All the PDBs are in closed state.
E. Only the root databaseis opened in read-write mode.
Answer: A,E
Q5. 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
Answer: B
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm(pre requisites, thirdpara)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
Q6. In which three scenarios is media recovery required?
A. when a tablespace is accidentally dropped from a database
B. when archived redo log files are lost
C. when data files are lost
D. when one of the online redo log members is corrupted
E. when all control files are lost
Answer: A,C,E
Reference:http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm
Q7. 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.
Answer: A
Explanation: EM Express is built inside the database.
Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Q8. Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')),
PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items
(po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL,
unit_prlceNUMBER(8,2),
quantity NUMBER(8),
CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )
PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?
A. Partitions of purchase_order_items are assigned unique names based on a sequence.
B. The purchase_orders and purchase_order_items tables are created with four partitioneach.
C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.
Answer: C,E
Q9. Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1.Restore the corrupted redo log group.
2.Restore the database from the most recent database backup.
3.Perform an incomplete recovery.
4.Relocatethe member of the damaged online redo log group to a new location.
5.Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.
A. 1, 3, 4, 5
B. 6, 3, 4, 5
C. 2, 3, 4, 5
D. 6, 4,3, 5
Answer: C
Q10. Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX= '/disk2/oracle/pdb2'
Which two statements are true?
A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
C. The tablespace specifications of pdb2 are the same as pdb1.
D. All database objects belonging to common users in PD3I are cloned in PD32.
E. pdb2 is created with its own private undo and temp tablespaces.
Answer: A,C
Reference:http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/(see the table, 4throw)