OCP Oracle 12C Advanced Administration(1Z0-063) Set 2

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 script will fail because you cannot use the PLUS ARCHIVELOG command when backing up database data files.
  • The script will fail since you instructed RMAN to back up only one data file rather than two.
  • The script will fail since it uses a substitution variable, which is not supported.
  • The script will successfully back up datafile 3 without error.
  • The EXECUTE SCRIPT command will prompt for the value of &2 since itís not included in the command.

Answer : The EXECUTE SCRIPT command will prompt for the value of &2 since itís not included in the command.

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_OWN/[email protected]
  • RMAN TARGET=/ CATALOG=/@RCAT
  • RMAN TARGET=/ CATALOG=RCAT_OWN/RCAT_OWN
  • You cannot connect to the target database and the recovery catalog at the same time.

Answer : RMAN TARGET=/ CATALOG=RCAT_OWN/[email protected]

1Z0-497 Oracle Database 12c Essentials Certification Exam Set 4

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.
  • Connect to RMAN using the command-line CATALOG parameter for backup or recovery purposes.
  • See all databases in the recovery catalog schema
  • Register databases if granted the register database privilege.

Answer : Register databases if granted the register database privilege.

Which of the following best describes a full backup?


Options are :

  • All the used blocks in a data file
  • All data files of a database
  • All data files and control files
  • All data files, archive logs, and control files

Answer : All data files of a database

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 :

  • e, a, b, d, c
  • c, a, b, d, f
  • b, a, c, d, e
  • c, a, b, d, e
  • a, c, b, d, f

Answer : c, a, b, d, f

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 7

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


Options are :

  • RESOURCE
  • SELECT ANY DICTIONARY
  • DBA
  • RECOVERY_CATALOG_OWNER
  • CONNECT

Answer : RECOVERY_CATALOG_OWNER

Which command will restore all data files to the date 9/30/2013 at 18:00 hours?


Options are :

  • RESTORE DATABASE FILES UNTIL TIME '09/28/2013:18:00:00';
  • RECOVER DATABASE UNTIL TIMESTAMP '09/28/2013:18:00:00';
  • RESTORE DATAFILES UNTIL TIME '09/28/2013:21:03:11';
  • RECOVER DATABASE UNTIL TIME '09/28/2013:18:00:00';
  • RESTORE DATABASE UNTIL TIME '09/28/2013:18:00:00';

Answer : RESTORE DATABASE UNTIL TIME '09/28/2013:18:00:00';

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, c, d, a, e
  • b, a, d, c, e
  • a, b, c, d, e
  • b, c, d, e, a
  • b, d, c, a, e

Answer : b, c, d, a, e

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 5

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


Options are :

  • ENABLE CONTROLFILE AUTOBACKUP
  • ALTER SYSTEM CONTROLFILE AUTOBACKUP ON
  • CONFIGURE CONTROLFILE AUTOBACKUP ON
  • ALTER DATASE CONTROLFILE AUTOBACKUP ON

Answer : CONFIGURE CONTROLFILE AUTOBACKUP ON

You need to restore your database to 9/30/2013 at 18:00. In what order would you run the following commands to compete this task?
a. RESTORE CONTROLFILE UNTIL TIME'09/30/2013:18:00:00';
b. RESTORE DATABASE UNTIL TIME'09/30/2013:18:00:00';
c. RESTORE SPFILE UNTIL TIME'09/30/2013:18:00:00';;
d. RECOVER DATABASE UNTIL TIME'09/30/2013:18:00:00';
e. ALTER DATABASE OPEN RESETLOGS;
f. ALTER DATABASE OPEN;


Options are :

  • b, d, e
  • c, a, b, d, e
  • a, b, d, e
  • c, a, b, d, f
  • b, d, f

Answer : b, d, e

Which commands are used for RMAN database recovery?


Options are :

  • REPLACE
  • COPY
  • REPAIR
  • RESTORE

Answer : RESTORE

1Z1-574 Oracle IT Architecture Essentials Practice Exam Set 2

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


Options are :

  • CATALOG CREATE
  • BUILD CATALOG
  • CREATE CATALOG
  • MOUNT CATALOG
  • CREATE RECOVERY CATALOG

Answer : CREATE CATALOG

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


Options are :

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

Answer : Run { execute script backup_database; }

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 PLUS ARCHIVELOGS
  • BACKUP DATABASE AND ARCHIVELOG DELETE INPUT
  • BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT
  • BACKUP DATABASE
  • BACKUP DATABASE AND ARCHIVELOGS

Answer : BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 4

Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?


Options are :

  • Cumulative backup
  • Cumulative incremental backup
  • Differential incremental backup
  • Different incremental backup

Answer : Differential incremental backup

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


Options are :

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

Answer : Incomplete database recovery.

Which backup option defines a user-defined name for a backup?


Options are :

  • NAME
  • FORMAT
  • TAG
  • FORMAT U%

Answer : TAG

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 2

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 :

  • a, b, c, d, e, f
  • c, a, e, b, d, f
  • c, a, b, d
  • c, b, a, d, f
  • c, b, a, d, e, f

Answer : c, a, b, d

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


Options are :

  • Level 2
  • Level 3
  • Level 1
  • Level 0

Answer : Level 0

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
  • Database data files
  • None of the above; all these files are backed up
  • The database spfile
  • Online redo logs
  • Database control files

Answer : Online redo logs

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 5

How is block-change tracking enabled?


Options are :

  • With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
  • With an init.ora parameter change
  • With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
  • With an spfile parameter change

Answer : With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

1Z0-517 Oracle EBS R12.1 Payables Essentials Practice Exam Set 10

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?
1. Shut down the database.
2. Restore a control-file copy from backup media.
3. Use the CREATE CONTROLFILE command to create a new control file.
4. Copy the backup control file into place.
5. Create a new copy of the control file from one of the surviving control files.
6. Recover the database using the RECOVER DATABASE USING BACKUP CONTROLFILE command.
7. Start up the database.


Options are :

  • 1,5,7
  • 3,6,7
  • 1,4,6,7
  • 1,2,6,7
  • 1,6,7

Answer : 1,5,7

What are the different archiving modes available in the Oracle Database? 


Options are :

  • LOGGING mode
  • ARCHIVING mode
  • None of the above
  • NOLOGGING mode
  • NOLOGFILE mode
  • ARCHIVELOG mode

Answer : ARCHIVELOG mode

Upon starting your ARCHIVELOG mode database, you receive the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size       1298640 bytes
Variable Size       146804528 bytes
Database Buffers       20971520 bytes
Redo Buffers       2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log'
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'
You can choose from the following steps:
1. Restore the database data files.
2. Issue the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP command.
3. Issue the ALTER DATABASE OPEN command.
4. Issue the ALTER DATABASE OPEN RESETLOGS command.
5. Recover the database using point-in-time recovery.
6. Issue the STARTUP MOUNT command to mount the database.
7. Back up the database.
Which is the correct order of these steps in this case?


Options are :

  • The database cannot be recovered.
  • 1,6,5,4,7
  • 1,6,3
  • 6,2,3,7
  • 6,5,4

Answer : 6,2,3,7

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 13

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
  • 3
  • 5
  • 2
  • 4

Answer : 4

Your NOARCHIVELOG database has experienced a loss of data file users_01.dbf, which is associated with a tablespace called USERS. The database is still running. Which of the following is the most correct answer?


Options are :

  • You can take the data file offline, restore the data file from a backup, and then recover the data file using the archived redo logs. You would then bring the data file back online.
  • You will have to shut down the database and restore the database, online redo logs, and control files that were contained in the last backup. You can then restart the database. There will be data loss.
  • You will have to shut down the database and restore the database, online redo logs, and control files that were contained in the last backup. You can then restart the database. There will be no data loss.
  • None of the above is correct.
  • This failure is not recoverable. You will need to force open the database and then force a recovery.

Answer : You will have to shut down the database and restore the database, online redo logs, and control files that were contained in the last backup. You can then restart the database. There will be data loss.

As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?


Options are :

  • Shut down the database.
  • Back up the database.
  • Clear the online redo log.
  • Checkpoint the database.

Answer : Checkpoint the database.

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 5

What methods of point-in-time recovery are available in NOARCHIVELOG mode?


Options are :

  • Cancel-based
  • Time-based
  • Sequence number-based
  • None of the above
  • Change-based

Answer : None of the above

Compressed backups work with which of the following commands?


Options are :

  • COPY AS BACKUP
  • BACKUP
  • BACKUP AS COPY
  • COPY

Answer : BACKUP

Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they donít want you to shut down the database to perform the backup. What options are available to you?


Options are :

  • Back up only the data files that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the data files the user changed during the course of the remaining backup.
  • Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.
  • Just back up the database data files without shutting down the database.
  • You will have to wait until you can shut down the database to perform the backup.
  • Mark each data file as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.

Answer : You will have to wait until you can shut down the database to perform the backup.

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions