NEW QUESTION 1
You are trying to recover your database. During the recovery process, you receive the following error:
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1 ORA-00289: suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 / o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file '/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 / o1_mf_1_10_4bj6wnqm_.arc' no longer needed for this recovery Specify log:
{<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/oracle01/flash_recovery_area/ORCL/ archivelog/2008_08_17 /o1_mf_1_11_%u_.arc'
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
How do you respond to this error? (Choose two.)

• A. Restore the archived redo log that is missing and attempt recovery again.
• B. Recovery is complete and you can open the database.
• C. Recovery needs redo that is not available in any archived redo lo
• D. Attempt to apply an online redo log if available.
• E. Recover the entire database and apply all archived redo logs again.
• F. Recovery is not possible because an archived redo log has been lost.

Answer: AC

NEW QUESTION 2
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?

• A. Database Datafiles
• B. Database Control Files
• C. Online redo logs
• D. Archived redo logs
• E. The database SPFILE
• F. None of the above, all these files are backed up.

Answer: C

NEW QUESTION 3
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 4
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.
The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly. What can you do to achieve this?

• A. Set DYNAMIC_SAMPLING to level 4.
• B. Set the STATISTICS_LEVEL parameter to BASIC.
• C. Set the INCREMENTAL value to TRUE for the partition table.
• D. Increase the value of STALE_PERCENT for the partition table.

Answer: C

Explanation: Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:
✑ INCREMENTAL value for the partitioned table is set to TRUE
✑ PUBLISH value for the partitioned table is set to TRUE;
✑ User specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table
If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full table scan is used to maintain the global statistics which is a much more resource intensive and time-consuming operation for large tables.

NEW QUESTION 5
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 6
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?

• A. It will create the tablespace TEMP1 in group G1.
• B. It will create the tablespace TEMP1 in group G3.
• C. It will not add the tablespace TEMP1 to any group.
• D. It will create the tablespace TEMP1 in the default group.

Answer: C

NEW QUESTION 7
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

• A. the SQL text
• B. the execution plan
• C. the execution context
• D. the execution frequency
• E. the system change number (SCN)

Answer: ACD

Explanation: http://www.oracle.com/technetwork/cn/articles/o69ocp-099954.html

NEW QUESTION 8
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

• A. The backup fails because one of the archived redo log files is missing.
• B. The backup succeeds but it would be without the missing archived log.
• C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
• D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

Answer: D

NEW QUESTION 9
Your company wants to upgrade the production database to a Real Application Clusters (RAC) environment.
You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.
The following steps may be used to replay the database workload:
1) Preprocess the captured workload
2) Restart the database in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Which is the correct sequence of the required steps?

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

Answer: B

Explanation: 11.1 Steps for Replaying a Database Workload
Proper planning of the workload replay and preparation of the replay system ensures that the replay will be accurate. Before replaying a database workload, review and complete the
following steps as appropriate:
✑ Setting Up the Replay Directory
✑ Restoring the Database
✑ Resolving References to External Systems
✑ Remapping Connections
✑ User Remapping
✑ Specifying Replay Options
✑ Using Filters with Workload Replay
✑ Setting Up Replay Clients

NEW QUESTION 10
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

• A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
• B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
• C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
• D. ASM compatibility controls which features for the ASM will be enabled.

Answer: ABD

NEW QUESTION 11
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

• A. You should perform a log switch
• B. You should make a backup of the database
• C. You should switch the database to the NOARCHIVELOG mode
• D. You should shut down the database instance and perform a complete database recovery

Answer: B

NEW QUESTION 12
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.
What steps should you take to recover from this tempfile loss in an efficient manner?

• A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
• B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
• C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
• D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

Answer: D

NEW QUESTION 13
How many database instances are used during a database-duplication process?

• A. One
• B. Two
• C. Three
• D. Four
• E. Five

Answer: B

NEW QUESTION 14
If a backup is expired, which of the following is true?

• A. It can never be used for a restore/recover operation.
• B. Oracle will remove the backup set pieces from the flash recovery area.
• C. The backup has been used at least once to restore and recover the database.
• D. The backup is no longer valid because of a resetlogs operation.
• E. The physical backup set pieces are missing from the media.

Answer: E

NEW QUESTION 15
Which of the following advisors is run in every maintenance window by the auto-task system?

• A. The Memory Advisor
• B. The SQL Tuning Advisor
• C. The Undo Advisor
• D. The SQL Access Advisor

Answer: B

Explanation: About Automated Maintenance Tasks (link)
Oracle Database has three predefined automated maintenance tasks:
✑ Automatic Optimizer Statistics Collection
✑ Automatic Segment Advisor
✑ Automatic SQL Tuning Advisor
By default, all three automated maintenance tasks are configured to run in all maintenance windows.

NEW QUESTION 16
You are managing an ASM instance. You previously issued the following statements:
ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5;
You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?

• A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
• B. ALTER DISKGROUP dg1 UNDROP;
• C. ALTER DISKGROUP dg1 UNDROP DISKS;
• D. You cannot cancel the pending disk drops.

Answer: C

Explanation:
C:UsersalboDesktop1-1.jpg
Use this clause to cancel the drop of disks from the disk group. You can cancel the pending drop of all the disks in one or more disk groups (by specifying diskgroup_name) or of all the disks in all disk groups (by specifying ALL).
This clause is not relevant for disks that have already been completely dropped from the disk group or for disk groups that have been completely dropped. This clause results in a long-running operation. You can see the status of the operation by querying the V$ASM_OPERATION dynamic performance view.

NEW QUESTION 17
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups.
Identify two prerequisites to perform the backups. (Choose two.)

• A. The database must be opened in restricted mode.
• B. The database must be configured to run in ARCHIVELOG mode.
• C. The tablespaces are required to be in backup mode before taking the backup.
• D. The tablespaces are required to be in read-only mode before taking the backup

Answer: BC

NEW QUESTION 18
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

• A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
• B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
• C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
• D. Either B or C.

Answer: A

Explanation:
C:UsersalboDesktop1-1.jpg

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

• A. Languages for server messages
• B. Day and month names and abbreviations
• C. Symbols to represent a.m., p.m., AD, and BC
• D. Affirmative and negative response strings (YES, NO)
• E. None of the above
• F. All of the above

Answer: F

Explanation: Parameter type String
Syntax NLS_LANGUAGE = language
Default value Operating system-dependent, derived from the NLS_LANG environment variable
Modifiable ALTER SESSION
Range of values Any valid language name Basic Yes
NLS_LANGUAGE specifies the default language of the database. This language is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. This parameter also determines the default values of the parameters NLS_DATE_LANGUAGE and NLS_SORT.

NEW QUESTION 20
You execute the following Recovery Manager (RMAN) commands in the following order: BACKUP VALIDATE DATABASE;
RECOVER CORRUPTION LIST;
Which (two tasks are performed by these commands? (Choose two.)

• A. Repair the corrupted block
• B. If an
• C. In the backup created.
• D. Populate V$COPY_CORRUPTION with names of files that have corrupted blocks.
• E. Back up the database after checking whether array of the files have corrupted blocks.
• F. Discover any corrupt blocks that are viewable with the V$DATABASE_BLOCK_CORRUPTION view.
• G. Repair all corrupted blocks that have been logged in the V$DATABASE_BLOCK_CORRUPTION

Answer: DE

Explanation: V$DATABASE_BLOCK_CORRUPTION displays information about database blocks that were corrupted after the last backup.
------------------------------------------------------------------------------- BACKUP...VALIDATE
Scans the specified files and verifies their contents, testing whether this file can be backed up and whether the data blocks are corrupt. RMAN creates no output files.
This option is equivalent to using the VALIDATE command on the database files specified in the backup. If you do not specify CHECK LOGICAL, then BACKUP..VALIDATE checks for physical corruption only. If you specify CHECK LOGICAL, then BACKUP VALIDATE checks for both physical and logical corruption.
RMAN populates the V$DATABASE_BLOCK_CORRUPTION view with any corruptions that it finds.
You can use the SET MAXCORRUPT command to set a limit for the number of corrupt
blocks tolerated during the backup validation. The default is zero.
If you execute BACKUP INCREMENTAL with VALIDATE, then the behavior depends on whether block change tracking is enabled. If change tracking is enabled, then RMAN validates only changed blocks; otherwise, RMAN validates all blocks in the files included in the backup.
Note: You cannot validate backups of backup sets.
-------------------------------------------------------------------------------
The following prerequisites apply to RECOVER BLOCK: (link)
✑ The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
✑ RMAN can only recover blocks marked media corrupt. The V$DATABASE_BLOCK_CORRUPTION view indicates which blocks in a file were marked corrupt since the most recent BACKUP or BACKUP ... VALIDATE command was run against the file.
✑ The backups of the data files containing the corrupt blocks must be full backups and not proxy backups. If only proxy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies. You can then use the data file copies for block media recovery.
✑ RMAN can use only archived redo log files for recovery. Block media recovery cannot survive a missing or inaccessible log, although it can sometimes survive missing or inaccessible records (see Oracle Database Backup and Recovery User's Guide).
✑ For RMAN to be able to search the flashback logs for good copies of corrupt blocks, Flashback Database must be enabled on the target database.
✑ For RMAN to be able to search a standby database for good copies of corrupt blocks, the target database must be associated with a physical standby database in a Data Guard environment. In addition, the physical standby database must be open read-only in managed recovery.