OCP Oracle Database 11g Administrator Certified Professional Set 3

What does the SCN represent?


Options are :

  • The system change number, which is a point in time relative to transactions within a given database. (Correct)
  • A conversion factor that converts internal database time to external clock time.
  • UTC time in the database, providing a standardized way of tracking time in Oracle.
  • The security change number, which represents the security code that is needed to access any database structure.
  • A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.

Answer : The system change number, which is a point in time relative to transactions within a given database.

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?


Options are :

  • The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
  • run { run script backup_database; }
  • run { open script backup_database; run script backup_database }
  • Run { execute script backup_database; } (Correct)
  • run { engage script backup_database; }

Answer : Run { execute script backup_database; }

What methods are available to recover lost control files? 


Options are :

  • The restore controlfile SQL*Plus command.
  • No backup is required. The database will re-create the control file when it is discovered to be lost.
  • Emergency control file.
  • Backup control file. (Correct)

Answer : Backup control file.

OCP Oracle Database 11g Administrator Certified Professional Set 4

Which command do you use to create a recovery-catalog schema?


Options are :

  • create recovery catalog
  • catalog create
  • create catalog (Correct)
  • build catalog
  • mount catalog

Answer : create catalog

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)


Options are :

  • V$LOG_RECOVER
  • V$RECOVER_DATABASE
  • V$LOGFILE (Correct)
  • V$RECOVER_LOG

Answer : V$LOGFILE

How is block-change tracking enabled?


Options are :

  • With an init.ora parameter change
  • With alter database enable block change tracking (Correct)
  • With alter system enable block change tracking
  • With an spfile parameter change

Answer : With alter database enable block change tracking

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 1

Consider the following command:

Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:

  • Control-file auto backups were enabled.
  • The size of backup sets was not restricted.
  • One channel was allocated.


Options are :

  • 1
  • 2
  • 4 (Correct)
  • 5
  • 3

Answer : 4

You are trying to recover your database. During the recovery process, you receive the following error:

ORA-00279: change 5033391 generated at 08/17/2008 06:37:40
needed for thread 1
ORA-00289: suggestion :
/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file
'/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_10_4bj6wnqm_.arc' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_11_%u_.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
How do you respond to this error?


Options are :

  • Restore the archived redo log that is missing and attempt recovery again. (Correct)
  • Recovery is not possible because an archived redo log has been lost.
  • Recover the entire database and apply all archived redo logs again.
  • Recovery is complete and you can open the database.

Answer : Restore the archived redo log that is missing and attempt recovery again.

Which of the following best describes a full backup?


Options are :

  • All datafiles of a database
  • All datafiles, archive logs, and control files
  • All the used blocks in a datafile (Correct)
  • All datafiles and control files

Answer : All the used blocks in a datafile

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 2

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?


Options are :

  • backup database and archivelogs
  • backup database plus archivelog delete input (Correct)
  • backup database
  • backup database and archivelog delete input
  • backup database plus archivelogs

Answer : backup database plus archivelog delete input

What type of backup is stored in a proprietary RMAN format?


Options are :

  • Backup group
  • Backup section
  • Image copy
  • Backup set (Correct)

Answer : Backup set

What privileges must be granted to allow an account to create the recovery catalog? 


Options are :

  • SELECT ANY DICTIONARY
  • RECOVERY_CATALOG_OWNER (Correct)
  • CONNECT
  • DBA

Answer : RECOVERY_CATALOG_OWNER

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 3

You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?


Options are :

  • You will use the noresetlogs version of the create controlfile command (Correct)
  • You will need to open the database with the resetlogs command.
  • You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command.
  • All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
  • You will use the resetlogs version of the create controlfile command.

Answer : You will use the noresetlogs version of the create controlfile command

Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?


Options are :

  • Tell them that their request cannot be met with the current backup strategy. (Correct)
  • Restore the 19th's backup, restore all archived redo logs, recover the database to the 20th, and open the database.
  • Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
  • Use the recover database command to roll back the database from today to the 19th of the month.
  • Restore the 19th's backup, apply the online redo logs, and open the database.

Answer : Tell them that their request cannot be met with the current backup strategy.

Which type of backup must be performed first with an incremental backup?


Options are :

  • Level 3
  • Level 0 (Correct)
  • Level 1
  • Level 2

Answer : Level 0

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 4

Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. 


Options are :

  • rman target=/ catalog=/@rcat
  • rman target=sys/[email protected] catalog=rcat_own/[email protected] (Correct)
  • You cannot connect to the target database and the recovery catalog at the same time.
  • rman target=/ catalog=rcat_own/rcat_own

Answer : rman target=sys/[email protected] catalog=rcat_own/[email protected]

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 5

Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?


Options are :

  • restore database until time '09/28/2008:18:00:00'; (Correct)
  • recover database until time '09/28/2008:18:00:00';
  • restore database files until time '09/28/2008:18:00:00';
  • recover database until timestamp '09/28/2008:18:00:00';
  • restore datafiles until time '09/28/2008:21:03:11';

Answer : restore database until time '09/28/2008:18:00:00';

Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.

a. restore database;
b. recover database;
c. shutdown immediate
d. startup
e. restore archivelog all;
f. alter database open


Options are :

  • c, a, b, d (Correct)
  • c, b, a, d, f
  • c, a, e, b, d, f
  • c, b, a, d, e, f
  • a, b, c, d, e, f

Answer : c, a, b, d

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

a. restore controlfile until time
'09/30/2008:18:00:00';
b. restore database until time
'09/30/2008:18:00:00';
c. restore spfile until time
'09/30/2008:18:00:00';;
d. recover database until time
'09/30/2008:18:00:00';
e. alter database open resetlogs;
f. alter database open;


Options are :

  • c, a, b, d, e
  • a, b, d, e
  • c, a, b, d, f
  • b, d, f
  • b, d, e (Correct)

Answer : b, d, e

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 1

Which commands are used for RMAN database recovery?


Options are :

  • replace
  • repair
  • copy
  • restore (Correct)

Answer : restore

Which of the following does the recover command not do?


Options are :

  • Restore datafile images. (Correct)
  • Restore incremental backups.
  • Apply incremental backups.
  • Restore archived redo logs.
  • Apply archived redo logs.

Answer : Restore datafile images.

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:

RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? 


Options are :

  • The command fails because the database is running. (Correct)
  • The command restores all the control files.
  • This is the correct way to address this problem.
  • The command restores only the missing control file.

Answer : The command fails because the database is running.

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 2

In what order would you execute the following steps to create a recovery catalog?

a. Issue the create catalog command.
b. Create the recovery-catalog database.
c. Create the recovery-catalog user.
d. Grant the recovery_catalog_owner privilege to the recovery-catalog user.
e. Issue the register database command from the target database.


Options are :

  • b, a, d, c, e
  • b, c, d, a, e (Correct)
  • b, d, c, a, e
  • a, b, c, d, e
  • b, c, d, e, a

Answer : b, c, d, a, e

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?


Options are :

  • Issue the grant command from RMAN when connected to the target database.
  • Issue the grant command from RMAN when connected to the recovery catalog–owning schema. (Correct)
  • Issue the grant command from the recovery catalog–owning schema user account in the recovery catalog.
  • Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
  • Issue the grant command from the SYS user (or equivalent) of the target database.

Answer : Issue the grant command from RMAN when connected to the recovery catalog–owning schema.

David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?

a. Restored the control file with the RMAN restore controlfile command.
b. Mounted the DSL instance with the alter database mount command.
c. Restored the datafiles for the DSL database with the RMAN restore command.
d. Opened the DSL database with the alter database open resetlogs command.
e. Recovered the datafiles for the DSL database with the RMAN recover command.
f. Started the DSL instance.
g. Connected to the recovery catalog with RMAN.


Options are :

  • c, a, d, b, f, e, g
  • b, c, d, g, f, e, a
  • a, b, c, d, e, f, g
  • g, f, a, b, e, c, d
  • g, f, a, b, c, e, d (Correct)

Answer : g, f, a, b, c, e, d

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 3

You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?


Options are :

  • Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database. (Correct)
  • Manually copy the datafile image copy to the correct location and then manually restore the database from SQL*Plus.
  • Restore the SYSTEM tablespace from the last backup set and then recover the database.
  • Restore the SYSTEM tablespace image copy using the restore command and then restore the database.
  • The database is not recoverable in this situation with image copies.

Answer : Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.

What will be the end result of this set of RMAN commands?

shutdown abort
startup mount
restore datafile 4 until time '09/30/2008:15:00:00';
recover datafile 4 until time '09/29/2008:15:00:00';
alter database open resetlogs;


Options are :

  • All these commands will fail because they must be in the confines of a run block.
  • The restore command will fail.
  • The alter database open resetlogs command will fail. (Correct)
  • Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
  • The recover command will fail.

Answer : The alter database open resetlogs command will fail.

Which of the following are valid until command options when attempting point-in-time recovery in RMAN? 


Options are :

  • until commit
  • until change
  • until time (Correct)

Answer : until time

What command would you issue to enable automated backups of control files?


Options are :

  • configure controlfile autobackup on (Correct)
  • alter database controlfile autobackup on
  • alter system controlfile autobackup on
  • enable controlfile autobackup

Answer : configure controlfile autobackup on

What is the end result of these commands if they are successful?

RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag='gold_copy' plus archivelog
tag='gold_copy' delete input;
Backup database tag='silver_copy' plus archivelog
tag='silver_copy' delete input;


Options are :

  • You will not be able to restore either gold_copy or silver_copy.
  • Attempting to restore gold_copy will fail.
  • Attempting to restore gold_copy may or may not succeed. (Correct)
  • Attempting to restore silver_copy will fail.
  • Both backups will be available for restore without question.

Answer : Attempting to restore gold_copy may or may not succeed.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions