1Z0-053 Exam - Oracle Database 11g: Administration II

NEW QUESTION 1

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 2

Which of the following is a benefit of ASM fast disk resync?

• A. Failed disks are taken offline immediately but are not dropped.
• B. Disk data is never lost.
• C. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
• D. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
• E. Hot spare disks are automatically configured and added to the disk group.

Answer: A

Explanation:
ASM Fast Mirror Resync

NEW QUESTION 3

You executed the following command to drop a user: DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)

• A. All the objects of scott are moved to the Recycle Bin.
• B. Any objects in the Recycle Bin belonging to scott are purged.
• C. All the objects owned by scott are permanently dropped from the database.
• D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
• E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Answer: BC

NEW QUESTION 4

Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

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

Answer: A

Explanation:
The BEFORE DROP clause uses Recycle Bin;
The FLASHBACK DATABASE uses flashback logs at FRA area.

NEW QUESTION 5

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_I parameter 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?

• A. The online redo log file is not allowed to be overwritten.
• B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
• C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 6

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A. The time when the last flashback operation in your database was performed
• B. The time when the first flashback operation in your database was performed
• C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
• D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

Answer: C

Explanation:
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 7

Which statement is true regarding the VALIDATE DATABASE command?

• A. It checks the database for intrablock corruptions only.
• B. It checks for block corruption in the valid backups of the database.
• C. It checks the database for both intrablock and interblock corruptions.
• D. It checks for only those corrupted blocks that are associated with data files.

Answer: A

Explanation:
interblock corruption
A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption.
intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption.

NEW QUESTION 8

Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

• A. Implement RMAN multiplexing
• B. Set the DEBUG ON in the RMAN script
• C. Specify the command ID in the RMAN script
• D. Use a tag with the RMAN BACKUP command

Answer: C

NEW QUESTION 9

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 10

Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

• A. A single ADR can support multiple ADR homes for different database instances.
• B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
• C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to$ORACLE_BASE.
• D. The BACKGROUND_DUMP_DEST initialization parameter overrides theDIAGNOSTIC_DEST initialization parameter for the location of the alert log file.

Answer: AC

Explanation:
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
✑ If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
✑ If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to
ORACLE_HOME/log
Within ADR base, there can be multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on—for a particular instance of a particular Oracle product or component. For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home.

NEW QUESTION 11

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

• A. Any gap in archive logs ends the recovery.
• B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.
• C. Uncorrupted blocks from the flashback logs may be used to speed recovery.
• D. The database can be in NOARCHIVELOG mode.
• E. None of the above.

Answer: BC

Explanation:
Overview of Block Media Recovery (link) Basic Concepts of Block Media Recovery
Whenever block corruption has been automatically detected, you can perform block media recovery manually with the RECOVER ... BLOCK command. By default, RMAN first searches for good blocks in the real-time query physical standby database, then flashback logs and then blocks in full or level 0 incremental backups.
Prerequisites for Block Media Recovery (link)
The following prerequisites apply to the RECOVER ... BLOCK command:
✑ The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
✑ If the target database is a standby database, then it must be in a consistent state,
recovery cannot be in session, and the backup must be older than the corrupted file.
✑ The backups of the data files containing the corrupt blocks must be full or level 0
backups and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies and searches them for blocks during block media recovery.
✑ RMAN can use only archived redo logs for the recovery.
RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a missing or inaccessible archived redo log, although it can sometimes survive missing redo records.
✑ Flashback Database must be enabled on the target database for RMAN to search
the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
✑ The target database must be associated with a real-time query physical standby
database for RMAN to search the database for good copies of corrupt blocks.
Restore Failover (link)
RMAN automatically uses restore failover to skip corrupted or inaccessible backups and look for usable backups. When a backup is not found, or contains corrupt data, RMAN automatically looks for another backup from which to restore the desired files.

NEW QUESTION 12

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
✑ Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
✑ Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?

• A. to minimize plan regression due to the use of a new optimizer version
• B. to completely avoid the use of new plans generated by a new optimizer version
• C. to prevent plan capturing when the SQL statement is executed after the database upgrade
• D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

Answer: A

Explanation:
15.1.1 Purpose of SQL Plan Baselines (Link)
Common scenarios where SQL plan management can improve or preserve SQL performance include:
✑ A database upgrade that installs a new optimizer version usually results in plan changes for a small percentage of SQL statements. Most of these plan changes result in either no performance change or improvement. However, some plan changes may cause performance regressions. SQL plan baselines significantly minimize potential regressions resulting from an upgrade.
✑ Ongoing system and data changes can impact plans for some SQL statements,
potentially causing performance regressions. SQL plan baselines help minimize performance regressions and stabilize SQL performance.
✑ Deployment of new application modules means introducing new SQL statements
into the database. The application software may use appropriate SQL execution plans developed in a standard test configuration for the new statements. If the system configuration is significantly different from the test configuration, then the database can evolve SQL plan baselines over time to produce better performance.

NEW QUESTION 13

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

• A. V$LOGFILE
• B. V$RECOVER_LOG
• C. V$RECOVER_DATABASE
• D. V$LOG_RECOVER
• E. V$LOG

Answer: AE

NEW QUESTION 14

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.
Which statement about the result is true?

• A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
• B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.
• C. The database instance starts, but Automatic Memory Management is disabled.
• D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.

Answer: B

NEW QUESTION 15

Which of the following are included in a transportable tablespace set? (Choose all that apply.)

• A. The datafiles that make up a self-contained group of tablespaces required for copy
• B. The system tablespace
• C. An export of the tablespace metadata
• D. The spfile
• E. All of the above

Answer: AC

NEW QUESTION 16

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?

• A. You cannot perform the TSPITR with the constraints enabled.
• B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
• C. You can perform TSPITR only on the USERS tablespace.
• D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
• E. The TSPITR will only be successful if the constraint is enabled.

Answer: B

NEW QUESTION 17

What is the name of the file that identifies the set of available locale definitions?

• A. locale.def
• B. lxdef.ora
• C. lx1boot.nlb
• D. lx1boot.ora
• E. lang.def

Answer: C

NEW QUESTION 18

Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

• A. SQL Access Advisor recommendations are automatically implemented.
• B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
• C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
• D. SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
• E. None of the above.

Answer: B

Explanation:
Implementing the SQL Access Advisor Recommendations (link)
A SQL Access Advisor recommendation can range from a simple suggestion to a complex solution that requires partitioning a set of existing base tables and implementing a set of database objects such as indexes, materialized views, and materialized view logs. You can select the recommendations for implementation and schedule when the job should be executed.

NEW QUESTION 19

Which background process coordinates the rebalance activity for disk groups?

• A. ORBn
• B. OSMB
• C. RBAL
• D. ASMn

Answer: C

Explanation:
RBAL
ASM Rebalance Master Process Coordinates rebalance activity
In an ASM instance, it coordinates rebalance activity for disk groups. In a database instances, it manages ASM disk groups.

NEW QUESTION 20

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

• A. A must contain all of the characters defined in B.
• B. A must be Unicode.
• C. The encoded values in A must match the encoded values in B for all characters defined in B.
• D. A must be a multi-byte character set.
• E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

Answer: AC

NEW QUESTION 21

RMAN provides more granular catalog security through which feature?

• A. Virtual private database
• B. Virtual private catalog
• C. RMAN virtual database
• D. RMAN secure catalog
• E. Oracle Database Vault

Answer: B

Explanation:
About Virtual Private Catalogs
By default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether inadvertently or maliciously, destroy catalog data for the other's database. In many enterprises, this situation is tolerated because the same people manage many different databases and also manage the recovery catalog. But in other enterprises where clear separation of duty exists between administrators of various databases, and between the DBA and the administrator of the recovery catalog, you may desire to restrict each database administrator to modify only backup metadata belonging to those databases that they are responsible for, while still keeping the benefits of a single, centrallymanaged, RMAN recovery catalog. This goal can be achieved by implementing virtual private catalogs.

NEW QUESTION 22

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario? (Choose two.)

• A. The optimizer adds the new plan to the plan history.
• B. The optimizer selects the new plan for the execution of the SQL statement.
• C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
• E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

Answer: AE

Explanation:
15.2.2 Selecting SQL Plan Baselines
During the SQL plan baseline selection phase, Oracle Database detects plan changes based on the stored plan history, and selects plans to avoid potential performance regressions for a set of SQL statements.
Each time the database compiles a SQL statement, the optimizer does the following:
1. Uses a cost-based search method to build a best-cost plan
2. Tries to find a matching plan in the SQL plan baseline
3. Does either of the following depending on whether a match is found:
✑ If found, then the optimizer proceeds using the matched plan
✑ If not found, then the optimizer evaluates the cost of each accepted plan in the SQL plan baseline and selects the plan with the lowest cost
The best-cost plan found by the optimizer that does not match any plans in the plan history for the SQL statement represents a new plan. The database adds this plan as a nonaccepted plan to the plan history. The database does not use the new plan until it is verified to not cause a performance regression. However, if a change in the system (such as a dropped index) causes all accepted plans to become non-reproducible, then the optimizer selects the best-cost plan. Thus, the presence of a SQL plan baseline causes the optimizer to use conservative plan selection strategy for the SQL statement.
To enable the use of SQL plan baselines, set the OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter to TRUE (default). A SQL plan baseline contains one or more accepted plans.
The plan history is the set of plans, both accepted and not accepted, that the optimizer generates for a SQL statement over time, the plans in the baseline form a subset of the plan history. For example, after the optimizer generates the first acceptable plan for a SQL plan baseline, subsequent plans are part of the plan history but not part of the plan baseline.

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 23
......