as11

QUESTION 101
Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
FLASHBACK_ARCHIEVE_NAME STATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?

QUESTION 77
When you create a backup control file, where is the resulting file written to?

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

QUESTION 123
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)

QUESTION 109
Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)

QUESTION 93
What is the purpose of the recover command? (Choose all that apply.)

QUESTION 94
What is an obsolete backup set?

QUESTION 100
Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)

QUESTION 106
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

QUESTION 95
What is the purpose of the list expired backup command?

QUESTION 103
Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.)

QUESTION 88
You can back up the RMAN recovery catalog with RMAN.

QUESTION 112
Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)

QUESTION 81
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the
only
backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have
archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to
database loss. To which point can you restore your database?

QUESTION 117
Which of the following are true concerning block media recovery? (Choose all that apply.)

QUESTION 107
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users
tablespace
is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

QUESTION 90
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the
following
error message:
SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not
open parameter file ,,C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN,
how would you respond to this error?

QUESTION 119
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate?

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

QUESTION 96
What is the purpose of the catalog command?

QUESTION 108
You want to set the following Initialization parameters for your database Instance
LOG_ARCHIVE_DEBT_1 = ,,LOCATION=/disk1/arch
LOG_ARCHIVE_DBST_2 = ,,LOCATION=/disk2/arch
LOC_ARCHIVB DBST_3 = ,,LOCATION=/disk3/arch
LOG_ARCHIVE DBST_ = ,,LOCATION=/disk3/arch
Identify the statement that correctly describes this setting.

QUESTION 86
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

QUESTION 83
Which of the following RMAN structures can data from a datafile span?

QUESTION 84
Which RMAN backup command is used to create the block-change tracking file?

QUESTION 121
You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?

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

QUESTION 122
The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?

QUESTION 79
You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you
perform
the following steps to recover your database?
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.

QUESTION 104
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional.
You could consider performing the following steps to accomplish this task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file.
3) Start the target database Instance.4) Mount the database.
5) Restore the data files.
6) Open the database with the RESETLOGS option.
7) Recover the data files.
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?

QUESTION 115
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

QUESTION 110
You executed the following command in Recovery Manager (RMAN):
RMAN> REPORT NEED BACKUP days 3;
What is the output of this command?

QUESTION 85
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams
using
Java. Knowing that your database is in danger, which command would you use to back up your
NOARCHIVELOG
mode database using RMAN with compression?

QUESTION 102
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one
member.
A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and
the
LWGR terminates causing the instance to crash.
The steps to recover from the loss of a current redo log group member in the random order are as follow.
1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.7) Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.

QUESTION 114
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?

QUESTION 87
RMAN provides more granular catalog security through which feature?

QUESTION 120
Which of the following are not disabled by default?

QUESTION 76
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

QUESTION 105
You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command
is used.
What must you set using the RMAN CONFIGURE command to achieve this?

QUESTION 91
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008.
Which ofthe following would be the correct commands to use to restore the database to a point in time before the corruption?

QUESTION 92
What is the purpose of the until change option of the restore command?

QUESTION 118
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?

QUESTION 78
If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?

QUESTION 98
What are the two different types of database duplication? (Choose two.)

QUESTION 125
What components are present in an ASM instance? (Choose three.)

QUESTION 113
What RMAN command is used to execute a tablespace point-in-time recovery?

QUESTION 89
What RMAN command must you use before you can back up a database using the recovery catalog?

QUESTION 111
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'
LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_Iparameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?

QUESTION 97
Which of the following commands will fail?

QUESTION 124
What are three benefits of using ASM? (Choose three.)

QUESTION 82
Which of the following files cannot be backed up by RMAN? (Choose all that apply.)