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.Relocate the 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.
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Questions and Answers PDF 100 /170 Which statement is true about the result of this command?
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup?
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. Questions and Answers PDF 101 /170 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 with the noredo option. 11.Recover the data file with the noredo option. Identify the required steps in the correct order.
Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; --(First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); Table created. You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table) Table dropped. SQL> FLASHBACK TABLE emp TO BEFORE DROP; Which statement is true about the FLASHBACK command?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
