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

NEW QUESTION 1

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:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 2

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 3

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

• A. It allows you to select the SCN that you want to restore to.
• B. It allows you to select the log sequence number you want to restore to.
• C. It allows you to select the timestamp you want to restore to.
• D. It allows you to manually stop the restore at any time as online redo logs are applied.
• E. None of the above.

Answer: A

Explanation:
The keyword of CHANGE means to point to the system change number (SCN).

NEW QUESTION 4

Which three statements are true regarding persistent lightweight jobs? (Choose three.)

• A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
• B. The user cannot set privileges on persistent lightweight jobs.
• C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
• D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
• E. The use of a template is mandatory to create persistent lightweight jobs.

Answer: BCE

NEW QUESTION 5

You executed the following PL/SQL block successfully:

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis .

• A. with the CPU Usage finding if it is less than 90
• B. without the CPU Usage finding if it is less than 90
• C. with the CPU Usage finding for snapshots below 90
• D. with the CPU Usage finding for snapshots not between 150 and 162

Answer: B

NEW QUESTION 6

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

• A. You can use RMAN stored scripts.
• B. Recovery is faster if data is stored in catalog in addition to the control file.
• C. You can store backup Information of all registered databases in one place.
• D. Database backups are automatically deleted when they are older than the specified time period.

Answer: AC

NEW QUESTION 7

What is the purpose of the catalog command?

• A. To review RMAN control file and recovery catalog metadata and ensure that its correct
• B. To delete RMAN backup-related metadata from the recovery catalog
• C. To create metadata in the control file and the recovery catalog related to backup set pieces
• D. To create a report that lists database backups
• E. To rebuild the recovery catalog

Answer: C

Explanation:
Use the CATALOG command to do the following:
✑ Add backup pieces and image copies on disk to the RMAN repository
✑ Record a data file copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy

NEW QUESTION 8

View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
Exhibit:

• A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
• B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
• C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
• D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

Answer: A

NEW QUESTION 9

What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?

• A. crosscheck
• B. list backup
• C. confirm
• D. resync
• E. backup validate

Answer: A

Explanation:
Crosscheck
A check to determine whether files on disk or in the media management catalog correspond to the data in the RMAN repository. Because the media manager can mark tapes as expired or unusable, and because files can be deleted from disk or otherwise become corrupted, the RMAN repository can contain outdated information about backups. Run the CROSSCHECK command to perform a crosscheck.
The "control file" in the QUESTION NO: is acting as the RMAN repository if the RMAN use control file store metadata.

NEW QUESTION 10

The SQL Tuning Advisor configuration has default settings in your database instance.
Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?

• A. statistics recommendations
• B. SQL Profile recommendations
• C. Index-related recommendations
• D. restructuring of SQL recommendations

Answer: B

NEW QUESTION 11

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

• A. statistics recommendations
• B. SQL profile recommendations
• C. index-related recommendations
• D. restructuring of SQL recommendations

Answer: B

NEW QUESTION 12

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

• A. create catalog
• B. install database
• C. catalog database
• D. merge Catalog with database
• E. register database

Answer: E

NEW QUESTION 13

When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?

• A. DB_CACHE_SIZE
• B. SHARED_POOL_SIZE
• C. LARGE_POOL_SIZE
• D. JAVA_POOL_SIZE
• E. SGA_MAX_SIZE
• F. SORT_AREA_SIZE

Answer: E

NEW QUESTION 14

When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

• A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.
• B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.
• C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.
• D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.

Answer: A

NEW QUESTION 15

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?

• A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E. Issue the restore spfile from autobackup command from the RMAN prompt.

Answer: C

NEW QUESTION 16

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)

• A. They deregister all databases registered in the RCAT10 catalog.
• B. They import metadata for all registered databases in the RCAT10 database.
• C. They register all the RCAT10-catalog registered databases in the RCO11 catalog.
• D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

Answer: ABC

NEW QUESTION 17

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

• A. Only one I/O calibration process can run at a time.
• B. It automates the resource allocation for the Automated Maintenance Tasks.
• C. It improves the performance of the performance-critical sessions while running.
• D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
• E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

Answer: ADE

NEW QUESTION 18

The following command is executed to shut down an Automatic Storage Management (ASM) instance:
SQL>SHUTDOWN ABORT;
Which two statements describe the consequences of the above command? (Choose two.)

• A. The disk groups are orderly dismounted.
• B. The ASM instance requires recovery when it is started.
• C. The database instance that are currently clients of the ASM instance are aborted.
• D. The CSS daemon stops and has to be restarted before the ASM instance is restarted.

Answer: BC

NEW QUESTION 19

Automatic data conversion will occur if which of the following happens?

• A. The client and server have different NLS_LANGUAGE settings.
• B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
• C. The client and server are in different time zones.
• D. The client requests automatic data conversion.
• E. The AUTO_CONVERT initialization parameter is set to TRUE.

Answer: B

NEW QUESTION 20

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.
Which statement is true when you accept the suggested SQL profile?

• A. The tuned plan is not added to the SQL plan baseline.
• B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
• C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
• D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

Answer: C

Explanation:
15.4 Using Fixed SQL Plan Baselines (Refer to here)
When you tune a SQL statement with a fixed SQL plan baseline using SQL Tuning Advisor, a SQL profile recommendation has special meaning. When the SQL profile is accepted, the database adds the tuned plan to the fixed SQL plan baseline as a non-fixed plan. However, as described above, the optimizer does not use the tuned plan when a reproducible fixed plan is present. Therefore, the benefit of SQL tuning may not be realized. To enable the use of the tuned plan, manually alter the tuned plan to a fixed plan by setting its FIXED attribute to YES.

NEW QUESTION 21

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 22

The INV_HISTORY table is created using the command:

The following data has been inserted into the INV_HISTORY table:

You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006'))
INTO PARTITION sys_py;
What would be the outcome of this command?

• A. It executes successfully, and the transition point is set to '1-apr-2006'.
• B. It executes successfully, and the transition point is set to '15-apr-2006'.
• C. It produces an error because the partitions specified for merging are not adjacent.
• D. It produces an error because the date values specified in the merge do not match the date values stored in the table.

Answer: C

NEW QUESTION 23
......