OCP Oracle Database 11g Administrator Certified Professional Set 2

How many individual archive-log destination directories are supported by Oracle Database 11g?


Options are :

  • 10
  • 21
  • 1
  • 11
  • 7

Answer : 10

Which view provides information on the backup status of the datafiles in the database?


Options are :

  • V$BACKUP
  • V$TABLESPCE_BACKUP
  • V$DATAFILE_BACKUP
  • V$BACKUP_STATUS
  • V$BACKUP_DATAFILE

Answer : V$BACKUP

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

How can you reverse the effects of an ALTER DISKGROUP DROP DISK command if it has already completed?


Options are :

  • Issue the ALTER DISKGROUP DROP DISK CANCEL command.
  • Retrieve the disk from the Recycle Bin after the operation completes.
  • Issue the ALTER DISKGROUP ADD DISK command.
  • Issue the ALTER DISKGROUP UNDROP DISKS command.

Answer : Issue the ALTER DISKGROUP ADD DISK command.

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED


Options are :

  • The DGROUP1 disk group was unmounted by another DBA.
  • One of the redundant disks (DGROUP1) has been lost in a disk group.
  • A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state.
  • This query has no meaning in an ASM instance.

Answer : The DGROUP1 disk group was unmounted by another DBA.

Which of the following parameters defines the location where Oracle should create archived redo logs?


Options are :

  • LOG_DESTINATION_1
  • LOG_ARCHIVED_DESTINATION_1
  • LOG_ARCHIVE_DEST_1
  • LOG_ARCHIVE_1
  • LOG_ARCHIVE_SOURCE_1

Answer : LOG_ARCHIVE_DEST_1

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 3

Which is the correct command to put the database in ARCHIVELOG mode?


Options are :

  • alter database archivelog enable
  • alter system enable archivelog mode
  • alter database archivelog
  • alter database enable archive
  • None of the above

Answer : alter database archivelog

When performing an online backup, what is the proper order of the following steps?
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.


Options are :

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

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

Your archive-log destination directory runs out of space. What is the impact of this on the database?


Options are :

  • A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
  • The database will shut down, and will not restart until you correct the out-of-space situation.
  • The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
  • Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
  • None. The database will switch over to the stand-by archive-log destination directory.

Answer : Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.

1Z0-516 Oracle EBS R12.1 General Ledger Essentials Exam Set 1

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 :

  • Mark each datafile 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.
  • You will have to wait until you can shut down the database to perform the 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 datafiles without shutting down the database.
  • Only back up the datafiles 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 datafiles the user changed during the course of the remaining backup.

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

Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?


Options are :

  • alter tablespace DAVE_TBS backup mode;
  • alter tablespace DAVE_TBS start backup;
  • alter tablespace DAVE_TBS begin backup;
  • alter tablespace DAVE_TBS backup begin;
  • alter tablespace DAVE_TBS backup;

Answer : alter tablespace DAVE_TBS begin backup;

If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?


Options are :

  • The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
  • The alter database archivelog command will ask if you want to make the database consistent first.
  • There is no alter database archivelog command. The correct command is alter database alterlogging.
  • The alter database archivelog command will succeed.
  • The alter database archivelog command will fail.

Answer : The alter database archivelog command will fail.

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

Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?


Options are :

  • ADD DIRECTORY
  • ADD FAILGROUP
  • DROP DISK
  • RESIZE DISK
  • REBALANCE

Answer : ADD DIRECTORY

If you use ALTER DISKGROUP ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?


Options are :

  • The command fails unless you specify the REUSE option.
  • The other disks, already part of the disk group, are ignored.
  • The command fails unless you specify the FORCE option.
  • The command must be reissued with a more specific discovery string.

Answer : The other disks, already part of the disk group, are ignored.

Which is not a valid way of backing up a control file?


Options are :

  • Creating a backup control file
  • Copying the existing control file of the database to the backup location during a hot backup
  • Backing up the control file to trace
  • Copying the existing control file of the database to the backup location during a cold backup
  • Using the create controlfile command

Answer : Copying the existing control file of the database to the backup location during a hot backup

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

True or false? Archived redo logs can be copied to more than one destination by Oracle.


Options are :

  • True
  • False

Answer : True

You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch. What do you do?


Options are :

  • Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
  • You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
  • If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
  • Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced, reset the parameter to its original value.
  • Take the whole disk group offline and wait for the controller card to be installed. Once it's installed, bring the disk group online again.

Answer : Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?


Options are :

  • Create a brand-new backup after all the changes have been applied.
  • Perform an online backup of the tablespace(s) that contained changed data.
  • There is no way to make the changes recoverable based on the 8 a.m. backup.
  • Create a manual incremental online database backup.
  • Back up all the archived redo logs generated since the 8 a.m. backup.

Answer : Back up all the archived redo logs generated since the 8 a.m. backup.

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

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?


Options are :

  • Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
  • None
  • Yes, if the database is in NOARCHIVELOG mode.
  • Yes, if the database is in ARCHIVELOG mode.
  • No, the backup is not usable in any way.

Answer : No, the backup is not usable in any way.

Which command will result in a trace file being created with the create controlfile command contained in it?


Options are :

  • alter database backup controlfile;
  • alter database begin controlfile backup;
  • alter database controlfile backup;
  • Talter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl';
  • alter database backup controlfile to trace;

Answer : alter database backup controlfile to trace;

You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?


Options are :

  • alter MY_DATA begin backup;
  • alter tablespace MY_DATA backup begin;
  • alter tablespace MY_DATA start backup;
  • alter tablespace MY_DATA begin backup;
  • You cannot back up individual tablespaces.

Answer : alter tablespace MY_DATA begin backup;

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

You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.
SQL> startup
ORACLE instance started.
Total System Global Area 167395328 bytes
Fixed Size 1298612 bytes
Variable Size 142610252 bytes
Database Buffers 20971520 bytes
Redo Buffers 2514944 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log'
ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'
What steps must you take to resolve the error?
a. Issue the recover database redo logs command.
b. Issue the Startup Mount command to mount the database.
c. Restore the last full database backup.
d. Perform a point-in-time recovery, applying all archived redo logs that are available.
e. Restore all archived redo logs generated during and after the last full database backup.
f. Open the database using the alter database open resetlogs command.
g. Issue the alter database open command.


Options are :

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

Answer : c, e, b, d, f

1Z0-521 Oracle E-Business Suite R12.1Oracle Order Managment Set 1

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


Options are :

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

Answer : Differential incremental backup

Which command creates an image copy?


Options are :

  • backup as copy
  • copy as backup
  • backup copy
  • copy back

Answer : backup as copy

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?


Options are :

  • Restore and recover the database.
  • Restore and recover the parameter file.
  • Restore and recover the control file.
  • Restore and recover the datafile.
  • Restore and recover the tablespace.

Answer : Restore and recover the datafile.

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

Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:

a. Restore the three database datafiles that were lost.
b. Issue the Startup Mount command to mount the database.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using the recover database command.
f. Recover the datafiles with the recover datafile command.
g. Take the datafiles offline.

Which is the correct order of these steps in this case?


Options are :

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

Answer : a, b, c, d

A user sends you an email with the following error message:

create table idtable(id number)
*
ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/oracle01/oradata/orcl/users01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
You can choose from the following steps:
a. Restore the missing database datafiles.
b. Take the missing datafile offline.
c. Shut down the database.
d. Issue the recover tablespace USERS command.
e. Issue the Startup Mount command to mount the database.
f. Bring the USERS tablespace online.
g. Issue the alter database open command.
Which is the correct order of these steps in this case?


Options are :

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

Answer : b, a, d, f

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


Options are :

  • NAME
  • FORMAT U%
  • TAG
  • FORMAT

Answer : TAG

1Z0-207 Oracle Comm Billing & Revenue Mgmt Pricing Exam Set 4

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?


Options are :

  • The next time you back up the database when you are also connected to the recovery catalog and the target database
  • The next time you connect RMAN to just the recovery catalog
  • Connecting to the recovery catalog and issuing the resync all databases command
  • The next time you connect to the recovery catalog and the target database with RMAN

Answer : The next time you back up the database when you are also connected to the recovery catalog and the target database

What is the purpose of the RMAN recovery catalog? 


Options are :

  • It provides a convenient, optional, repository of backup- and recovery-related metadata.
  • It provides a means of storing all RMAN backup sets physically in an Oracle database server.
  • It must be used because all RMAN-related backup and recovery metadata information is contained in it.

Answer : It provides a convenient, optional, repository of backup- and recovery-related metadata.

Compressed backups work with which of the following commands?


Options are :

  • copy as backup
  • backup
  • copy
  • backup as copy

Answer : backup

1Z0-516 Oracle EBS R12.1 General Ledger Essentials Exam Set 6

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions