What Top Quality 1Z0-053 Exam Price Is

NEW QUESTION 1

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command.
Which statement is true for the above ADVISE FAILURE command in this scenario?

• A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
• B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
• C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
• D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

Answer: A

NEW QUESTION 2

What information does the report schema command not provide? (Choose all that apply.)

• A. Size of the datafiles
• B. Size of the tempfiles
• C. Date of last backup for datafiles and tempfiles
• D. Filenames for each datafile
• E. Checkpoint SCN associated with the last RMAN backup

Answer: CE

NEW QUESTION 3

When you are performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)

• A. The SYSTEM tablespace.
• B. The UNDO tablespace.
• C. All tablespaces with tables.
• D. All tablespaces with indexes.
• E. No tablespaces are automatically restored.

Answer: AB

NEW QUESTION 4

You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.
Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

• A. The au_size disk group attribute determines the size of allocation units in the disk group.
• B. The allocation unit size may vary but the extent size is fixed.
• C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
• D. Extent management is completely automated.

Answer: AD

NEW QUESTION 5

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.
Which option must you consider for this task?

• A. using only the RMAN SWITCH command to set the new location for the data file
• B. placing the database in the MOUNT state for the restore and recovery operations.
• C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
• D. configuring two channels: one for the restore operation and the other for the recovery operation

Answer: C

NEW QUESTION 6

Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';
Identify the files that must be restored to recover the missing tables successfully.

• A. Restore the backup of all the data files.
• B. Restore the backup of all the data files and the control file.
• C. Restore the backup of only the data files that contain the dropped tables.
• D. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.

Answer: A

Explanation:
The tricky of answer is the command "RECOVER DATABASE", so that you must use "RESTORE DATABASE" to restore all the data files.
If the recover command is "RECOVER DATAFILE", then the Answer D will be correct.

NEW QUESTION 7

Examine the following RMAN script:
RMAN> run { debug on;
allocate channel c1 type disk; backup datafile 5;
}
Which statement describes the purpose of the script?

• A. The data file is checked for physical corruption and backed up if found clean.
• B. The backup of data file 5 is performed and the interactive messages during the backupare suppressed.
• C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
• D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

Answer: D

NEW QUESTION 8

Which three actions are required to configure the Flashback Database? (Choose three.)

• A. set Flash Recovery Area
• B. enable Flashback logging
• C. create FLASHBACK tablespace
• D. start the database in the ARCHIVELOG mode
• E. start the database in the NOARCHIVELOG mode

Answer: ABD

NEW QUESTION 9

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

• A. Automatic PGA Memory Management
• B. Automatic SGA Memory Management
• C. Automatic Shared Memory Management
• D. Automatic Memory Management
• E. Manual SGA Memory Management
• F. None of the above

Answer: D

NEW QUESTION 10

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?

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

Answer: C

NEW QUESTION 11

Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb;
}
Which statement is true about the duplicate database in this scenario?

• A. It contains data till the last backup
• B. It contains all data from target database until the current time
• C. It contains all data from only the committed transactions in the target database
• D. It contains all data except that which is used by the transactions in the current online redo file of target database

Answer: D

NEW QUESTION 12

When performing a full database disaster recovery with RMAN, in what order would you execute these steps?

• A. Restore the control file from autobackups.
• B. Run the RMAN restore and recover command.
• C. Restore the database spfile from autobackups.
• D. Make the RMAN backup set pieces available.
• E. Open the database with the alter database open resetlogs command.
• F. Open the database with the alter database open command.
• G. a, b, c, d, e, f
• H. c, d, a, b, f
• I. d, c, a, b, f
• J. d, b, d, c, e
• K. d, c, a, b, e

Answer: E

NEW QUESTION 13

In a Database Replay workload capture, what client request information is gathered?
(Choose all that apply.)

• A. SQL text
• B. Shared server requests (Oracle MTS)
• C. Bind variable values
• D. Information about transactions
• E. Remote DESCRIBE and COMMIT operations

Answer: ACD

NEW QUESTION 14

Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

• A. 1, 2, 3
• B. 3, 2, 1
• C. 2, 3, 1
• D. 1, 3, 2

Answer: C

NEW QUESTION 15

You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.

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

Answer: B

NEW QUESTION 16

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

• A. V$BACKUP
• B. V$BACKUP_STATUS
• C. V$BACKUP_DATAFILE
• D. V$DATAFILE_BACKUP
• E. V$TABLESPCE_BACKUP

Answer: A

NEW QUESTION 17

What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

• A. Channel failover
• B. Restartable backups
• C. Rescheduable backups
• D. Automatic backup recovery
• E. Channel recovery

Answer: A

NEW QUESTION 18

What methods of point-in-time recovery are available? (Choose all that apply.)

• A. Change-based
• B. Cancel-based
• C. Time-based
• D. Sequence number-based
• E. Transaction number-based

Answer: ABCD

NEW QUESTION 19

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database.
Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

• A. Every SQL statement in the STS is considered only once for execution.
• B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
• C. The execution plan and execution statistics are computed for each SQL statement in the STS.
• D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

Answer: AC

NEW QUESTION 20

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? (Choose all that apply.)

• A. The command restores only the missing control file.
• B. The command restores all the control files.
• C. The command fails because the database is running.
• D. This is the correct way to address this problem.
• E. This is not the correct way to address this problem.

Answer: CE

Explanation:
During the database running, the control files are locked by the database instance, you must shutdown the database and startup at NOMOUNT status to restore a missing control file.
And you have to open database with RESETLOGS option, due to control file change.

NEW QUESTION 21

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.
Which of these methods would you use to achieve this? (Choose all that apply.)

• A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
• B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
• C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
• D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

Answer: BCD

Explanation:
Purpose
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description
md_restore backup_file [--silent]
[--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]'] [-S sql_script_file] [-G 'diskgroup [,diskgroup...]']
backup_file
Reads the metadata information from backup_file.
--silent
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.
--full
Specifies to create a disk group and restore metadata.
--nodg
Specifies to restore metadata only.
--newdg -o old_diskgroup:new_diskgroup]
Specifies to create a disk group with a different name when restoring metadata. The -o option is required with
--newdg.
-S sql_script_file
Write SQL commands to the specified SQL script file instead of executing the commands.
-G diskgroup
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.

NEW QUESTION 22
......