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

NEW QUESTION 1

In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

• A. Setting a nonzero value for SGA_TARGET
• B. Configuring Automatic Shared Memory Management
• C. Configuring Automatic Memory Management
• D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
• E. None of the above

Answer: C

NEW QUESTION 2

Which mode of database shutdown requires an instance recovery at the time of the next database startup?

• A. ABORT
• B. NORMAL
• C. IMMEDIATE
• D. TRANSACTIONAL

Answer: A

NEW QUESTION 3

Which of the following are NOT fundamental tasks of the Support Workbench? (Choose all that apply.)

• A. View long-running SQL workloads
• B. View problem details
• C. Gather additional diagnostic information
• D. Create a Service Request
• E. Clean up incident data after upload to Oracle Support

Answer: AE

Explanation:
The Enterprise Manager Support Workbench (Support Workbench) is a facility that enables you to investigate, report, and in some cases, repair problems (critical errors), all with an easy-to-use graphical interface. The Support Workbench provides a self-service means for you to gather first-failure diagnostic data, obtain a support request number, and upload
diagnostic data to Oracle Support with a minimum of effort and in a very short time, thereby reducing time-to-resolution for problems. The Support Workbench also recommends and provides easy access to Oracle advisors that help you repair SQL-related problems, data corruption problems, and more.

NEW QUESTION 4

Which of the following statements is true regarding implementing a Flashback Table recovery?

• A. An SCN is never used to perform a Flashback Table recovery.
• B. If a significant number of changes have been made to the table, row movement must be enabled.
• C. The tablespace must be offline before performing a Flashback Table recovery.
• D. Flashback Table recovery is completely dependent on the availability of undo data in theundo tablespace.

Answer: D

NEW QUESTION 5

A schedule defined entirely within the confines of a Scheduler job object is known as a (n) .

• A. Fixed schedule
• B. Inline schedule
• C. Stored schedule
• D. Hard-coded schedule
• E. None of the above

Answer: B

Explanation:
“A schedule defined within a job object is know as an inline schedule, where as an independent schedule object is referred to as a stored schedule. Inline schedules cannot be reference by any other objects. ” http://www.datadisk.co.uk/html_docs/oracle/scheduler.htm

NEW QUESTION 6

You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN
{
SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;
}
Which statement is true about the result?

• A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
• B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
• C. RMAN restores all datafiles and control files from the most recent backup
• D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

NEW QUESTION 7

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 8

Examine the following command that is used to duplicate a database on the same host:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY;
}
Which two statements describe the effect after the database is duplicated successfully? (Choose two)

• A. The data files of the read-only tablespaces in the target database are not duplicated
• B. The read-only tablespaces in the target database are still defined in new the database
• C. The read-only tablespaces in the target database are changed to online after duplication
• D. The data files of the read-only tablespaces in the target database get duplicated
• E. The read-only tablespaces in the target database are not defined in the new database

Answer: AB

NEW QUESTION 9

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 10

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

• 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: AB

NEW QUESTION 11

Archived redo logs can be copied to more than one destination by Oracle.

• A. True
• B. False

Answer: A

NEW QUESTION 12

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 13

Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.
What do you do?

• A. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
• B. Tell them that their request cannot be met with the current backup strategy.
• C. Restore the 19ths backup, apply the online redo logs, and open the database.
• D. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
• E. Use the recover database command to roll back the database from today to the 19th of the month.

Answer: B

NEW QUESTION 14

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

• A. Create and populate a SQL Tuning Set from the AWR on every Monday.
• B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C. Create a repeating baseline template.
• D. Insert a finding directive for future ADDM tasks.

Answer: C

NEW QUESTION 15

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

• A. The tablespace must be locally managed.
• B. The tablespace must have only one temp file.
• C. The tablespace must be made nondefault and offline.
• D. The tablespace can remain as the default but must have no active sort operations.

Answer: A

NEW QUESTION 16

When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

• A. log_file_name_convert
• B. convert_log_file_name
• C. file_name_convert_log
• D. redo_log_file_name_convert
• E. logfile_convert_directory

Answer: A

NEW QUESTION 17

How many individual archive-log destination directories are supported by Oracle Database11g?

• A. 7
• B. 1
• C. 10
• D. 11
• E. 21

Answer: C

NEW QUESTION 18

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?

• A. synch catalog
• B. resync catalog
• C. replicate catalog
• D. update catalog
• E. restore catalog

Answer: B

Explanation:
Manually Resynchronizing the Recovery Catalog
Use RESYNC CATALOG to force a full resynchronization of the recovery catalog with a target database control file. You can specify a database unique name with RESYNC FROM DB_UNIQUE_NAME or ALL, depending on whether you want to resynchronize a specific database or all databases in the Data Guard environment.
Typically, you would perform this operation after you have run the CONFIGURE command for a standby database, but have not yet connected to this standby database.
1. Start RMAN and connect to a target database and recovery catalog.
2. Mount or open the target database: RMAN> STARTUP MOUNT;
3. Resynchronize the recovery catalog. RMAN> RESYNC CATALOG;

NEW QUESTION 19

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 20

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

• A. backup database
• B. backup database and archivelogs
• C. backup database plus archivelogs
• D. backup database plus archivelog delete input
• E. backup database and archivelog delete input

Answer: D

NEW QUESTION 21

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A. Only a single partitioning key column can be specified.
• B. All DML statements must use partition-extended syntax.
• C. The same physical attributes must be specified for each partition.
• D. Unique local indexes cannot be created on a system-partitioned table.
• E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: DE

NEW QUESTION 22

Why should you back up a duplicated tablespace after a TSPITR is complete?

• A. The tablespace cannot be duplicated or restored to any point in time after the duplication.
• B. The tablespace cannot be duplicated or restored to the point in time before the duplication.
• C. The entire database cannot be restored after a TSPITR, so a backup is required.
• D. You cannot bring the tablespace online until its been backed up.
• E. There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.

Answer: B

NEW QUESTION 23

Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?

• A. The shrink operation touches every block in the BOOKING table
• B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
• C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
• D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

Answer: C

NEW QUESTION 24

In what view are you likely to see the following output?

• A. V$SESSION_EVENT
• B. V$SESSION
• C. V$WAITS
• D. V$WAITSTAT
• E. V$SYSSTAT

Answer: B

NEW QUESTION 25

Case-insensitive sorts are always accent insensitive by default.

• A. True
• B. False

Answer: B

NEW QUESTION 26

How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?

• A. Issue the grant command from the SYS user (or equivalent) of the target database.
• B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
• C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E. Issue the grant command from RMAN when connected to the target database.

Answer: D

NEW QUESTION 27

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 28

You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

• A. It will display a list of files that need incremental backup
• B. It will display a list of files that need backup after five days
• C. It will display a list of files that were backed up in the last five days
• D. It will display a list of files that have not been backed up in the last five days
• E. It will apply the current retention policy to determine the files that need to be backed up

Answer: D

NEW QUESTION 29
......