NEW QUESTION 1

You issued the following RMAN command to back up the database:
RMAN> RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE
TAG quarterly KEEP FOREVER
RESTORE POINT FY06Q4;
}
Which two statements are true regarding the backup performed? (Choose two.)

• A. Archived redo log files are backed up along with data files.
• B. Only data files are backed up and a restore point named FY06Q4 is created.
• C. Archived log files are backed up along with data files, and the archived log files are deleted.
• D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

Answer: AD

Explanation:
Section: Monitoring and Tuning RMAN Explanation
Refer to here. keepOption
Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.
You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.
Note: You cannot use KEEP with BACKUP BACKUPSET.
With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.
Note: You can use CHANGE to alter the status of a backup generated with KEEP. See Also: keepOption for more information about backups made with the KEEP option Creating a Consistent Database Backup for Archival Purposes
This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.
BACKUP DATABASE
FORMAT '/disk1/archival_backups/db_%U.bck' TAG quarterly
KEEP UNTIL TIME 'SYSDATE + 365' RESTORE POINT Q1FY06;

NEW QUESTION 2

View the Exhibit and examine the RMAN commands.

Which statement describes the effect of a backup retention policy on the backup of a backup set?

• A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
• B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
• C. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.
• D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup set exceeds the redundancy-based backup retention policy.

Answer: A

NEW QUESTION 3

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

• A. It is used to change failure priority only for HIGH or LOW priorities.
• B. It is used to execute the advised repair script.
• C. It is used to change failure priority only for the CRITICAL priority.
• D. It is used to explicitly close the open failures.
• E. It is used to inform the database about the repair after the repair script executes.

Answer: AD

NEW QUESTION 4

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;" What is the outcome of the above commands?

• A. They execute and create a virtual catalog for pre-Oracle 11g clients.
• B. They produce an error because PROD1 and PROD2 databases belong to the older version.
• C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
• D. They produce an error because you need to connect to the target database to execute this packaged procedure.

Answer: A

NEW QUESTION 5

A user performs an update on a table. Shortly after committing the transaction, they realize
that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?

• A. Flashback Drop
• B. Flashback Query
• C. Flashback Versions Query
• D. Flashback Transaction Query
• E. Flashback Table

Answer: E

Explanation:
FLASHBACK TABLE
Purpose
Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

NEW QUESTION 6

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

• A. MMON
• B. LGWR
• C. ARCH
• D. ARWR
• E. COPY

Answer: C

NEW QUESTION 7

Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
7. shutdown immediate from RMAN
8. Log into RMAN
9. startup mount from RMAN 10.backup database
11. alter database open
12. backup database plus archivelog delete input

• A. 2,3,1,4,5
• B. 2,1,3,6,5
• C. 1,3,5,4
• D. 2,1,3,5,6
• E. 2,1,3,4,5

Answer: E

Explanation:
Backing Up a Database in NOARCHIVELOG Mode
If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.
To make a consistent database backup:
1. Start RMAN and connect to a target database.
2. Shut down the database consistently and then mount it.
For example, enter the following commands to guarantee that the database is in a consistent state for a backup:
RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP FORCE DBA; RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT;
3. Run the BACKUP DATABASE command.
For example, enter the following command at the RMAN prompt to back up the database to the default backup device:
RMAN> BACKUP DATABASE;
The following variation of the command creates image copy backups of all data files in the database:
RMAN> BACKUP AS COPY DATABASE;
4. Open the database and resume normal operations. The following command opens the database:
RMAN> ALTER DATABASE OPEN;

NEW QUESTION 8

You are managing an Oracle Database 11g database. You want to take the backup of
MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.
Which method would accomplish the task quickly and efficiently?

• A. parallel image copy backup
• B. backup with MAXPIECESIZE configured for the channel
• C. parallel backup with MAXPIECESIZE configured for the channel
• D. intrafile parallel backup

Answer: D

Explanation:
The MAXPIECESIZE option is to limit the size of backup piece. not to split the big file into pieces.
Configuring the Maximum Size of Backup Pieces
Backup piece size is an issue when it exceeds the maximum file size permitted by the file system or media management software. You can use the MAXPIECESIZE parameter of the CONFIGURE CHANNEL or ALLOCATE CHANNEL command to limit the size of backup pieces.
For example, to limit the backup piece size to 2 gigabytes or less, you can configure the automatic DISK channel as follows and then run BACKUP DATABASE:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G; BACKUP DATABASE;
We should use the SECTION SIZE option to split the big file into sections to the multiple backup devices. SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.
By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy.
File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.
If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.
Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.
Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.

NEW QUESTION 9

On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.
Which option must you use to check whether a flashback operation can recover the database to the specified time?

• A. Check the alert log file
• B. Query the V$FLASHBACK_DATABASE_LOG view
• C. Query the V$RECOVERY_FILE_DEST_SIZE view
• D. Query the V$FLASHBACK_DATABASE_STAT view
• E. Check the value assigned for the UNDO_RETENTION parameter

Answer: B

Explanation:
To query the V$FLASHBACK_DATABASE_LOG to get the lowest SCN or the nearest TIMESTAMP to decide the recovery possibility.

NEW QUESTION 10

You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the
retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

• A. The command produces an error because the retention time cannot be reduced.
• B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
• C. All historical data is purged and the new flashback data archives are maintained for three years.
• D. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D

NEW QUESTION 11

Which command is used to open the database after an incomplete recovery?

• A. alter database open
• B. alter database open repairlog
• C. alter database open resetlogs
• D. alter database open resetlog
• E. alter database resetlogs open

Answer: C

NEW QUESTION 12

Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)

• A. BACKGROUND_DUMP_DEST
• B. FOREGROUND_DUMP_DEST
• C. CORE_DUMP_DEST
• D. USER_DUMP_DEST
• E. DIAGNOSTIC_DEST
• F. All of the above

Answer: ACD

NEW QUESTION 13

The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?

• A. Implement a profile for the users.
• B. Implement external roles for the users.
• C. Set the threshold for the undo tablespace.
• D. Implement a Database Resource Manager plan.

Answer: B

NEW QUESTION 14

Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)

• A. The Recycle Bin is a physical storage area for dropped objects.
• B. The Recycle Bin is a logical container for dropped objects.
• C. The Recycle Bin stores the results of a Flashback Drop operation.
• D. The objects in the Recycle Bin are stored in the tablespace in which they were created.

Answer: BD

NEW QUESTION 15

On the development database rac0, there are six raw devices: /dev/raw/raw1 through
/dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each.
An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and
/dev/raw/raw2.
Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: A

NEW QUESTION 16

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

• A. True
• B. False

Answer: B

NEW QUESTION 17

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups.
Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

• A. Reregistering the target database in recovery catalog
• B. Transporting the new tablespaces to the recovery catalog database
• C. Syncronizing the recovery catalog with the target database control file
• D. Performing a fresh backup of the target database to include the new data files in the catalog database

Answer: CD

NEW QUESTION 18

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios is which you must have a recovery catalog. (Choose two.)

• A. To store the backup information of multiple database
• B. To restrict the amount of space that is used by the backups
• C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

Answer: AD

NEW QUESTION 19

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

• A. Backing up the control file to trace
• B. Copying the existing control file of the database to the backup location during a hot backup
• C. Copying the existing control file of the database to the backup location during a cold backup
• D. Creating a backup control file
• E. Using the create controlfile command

Answer: B

NEW QUESTION 20

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.

• A. b, a, f
• B. e, b, a, f
• C. e, b, a, g
• D. b, a, g
• E. c, e, b, d, f

Answer: E

Explanation:
If the online redo log is in ACTIVE or CURRENT status, you cannot issue CLEAR LOGFILE GROUP n command, it occurs ORA-01624 error.
The option (a) is invalid, there is NO such recover database redo log command, so that the answer must be (c, e, b, d, f).
It applies an incomplete recovery, then open database with RESETLOGS option.

NEW QUESTION 21

A schedule defined entirely within the confines of a Scheduler job object is known as a (n) .

• A. Fixed schedule
• B. Inline schedule
• C. Stored schedule
• D. Hard-coded schedule
• E. None of the above

Answer: B

Explanation:
“A schedule defined within a job object is know as an inline schedule, where as an independent schedule object is referred to as a stored schedule. Inline schedules cannot be reference by any other objects. ” http://www.datadisk.co.uk/html_docs/oracle/scheduler.htm

NEW QUESTION 22

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

• A. SQL Repair Advisor
• B. SQL Optimizer
• C. SQL Access Advisor
• D. SQL Tuning Advisor

Answer: D

NEW QUESTION 23

Examine the parameter setting in your database:

Which statement is correct about the database?

• A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
• B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
• C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
• D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

Answer: D

NEW QUESTION 24

View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command? Exhibit:

• A. The command performs the recovery and closes the failures.
• B. The command only displays the advice and the RMAN script required for repair.
• C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
• D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

NEW QUESTION 25
......