OCP Oracle Database 11g Administrator Certified Professional Set 4

Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?


Options are :

  • Sql 'alter database datafile 4 offline'; restore datafile 4; Sql 'alter database datafile 4 online';
  • shutdown restore datafile 4; recover datafile 4; alter database open;
  • Sql 'alter database datafile 4 offline'; restore datafile 4; recover datafile 4; alter database open;
  • Sql 'alter database datafile 4 offline'; restore datafile 4; recover datafile 4; Sql 'alter database datafile 4 online'; (Correct)
  • Sql 'alter database datafile 4 offline'; restore database datafile 4; recover database datafile 4; Sql 'alter database datafile 4 online';

Answer : Sql 'alter database datafile 4 offline'; restore datafile 4; recover datafile 4; Sql 'alter database datafile 4 online';

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

If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?


Options are :

  • Incomplete database recovery. (Correct)
  • Complete database recovery.
  • The database could not be recovered with RMAN.
  • Approximate database recovery.
  • Archived database recovery.

Answer : Incomplete database recovery.

Given the script
create script db_backup_datafile_script
{backup datafile &1, &2 plus archivelog delete input;}
what is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}


Options are :

  • The execute script command will prompt for the value of &2 since it's not included in the command. (Correct)
  • The script will successfully back up datafile 3 without error.
  • The script will fail since you instructed RMAN to back up only one datafile rather than two.
  • The script will fail since it uses a substitution variable which is not supported.
  • The script will fail because you cannot use the plus archivelog command when backing up database datafiles.

Answer : The execute script command will prompt for the value of &2 since it's not included in the command.

True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.


Options are :

  • False (Correct)
  • True

Answer : False

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

What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?

a. sql 'alter database datafile 4 online';
b. restore datafile 4;
c. recover datafile 4;
d. sql 'alter database datafile 4 offline';
e. startup
f. shutdown


Options are :

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

Answer : d, b, c, a

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?


Options are :

  • Archived redo logs
  • None of the above, all these files are backed up.
  • Database Datafiles
  • The database SPFILE
  • Database Control Files
  • Online redo logs (Correct)

Answer : Online redo logs

Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

a. restore controlfile
b. restore database
c. restore spfile
d. recover database
e. alter database open
f. alter database open resetlogs


Options are :

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

Answer : c, a, b, d, f

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

The RVPC user can do which of the following?


Options are :

  • Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
  • Register databases if granted the register database privilege (Correct)
  • See all databases in the recovery-catalog schema
  • Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer : Register databases if granted the register database privilege

You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to "roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? 


Options are :

  • UNDO
  • SYSTEM
  • USERS
  • TEMP
  • All the above (Correct)
  • SYSAUX

Answer : All the above

If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_ CORRUPT, what RMAN command would you run to correct the problem?


Options are :

  • recover corruption list; (Correct)
  • recover lost blocks;
  • recover corrupt blocks from list;
  • recover corrupt blocks;
  • recover media corrupt blocks from list;

Answer : recover corruption list;

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions