1z0-053.actuatest.9-16-2012

Explanation/Reference:

Explanation:

QUESTION 458

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

A.flashback query

B.distributed transactions Oracle 1z0-053 Exam

C.logging in and logging out of sessions

D.all DDL statements having bind variables

E.direct path load of data from external files

Answer: CD

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 459

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

A.The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

B.The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

C.The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

D.The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

Answer: BD

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 460

Which setting enables the baselines by default in Oracle Database 11g?

A.setting the STATISTICS_LEVEL parameter to TYPICAL

B.adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C.enabling Automated Maintenance Task using Oracle Enterprise Manager

D.setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

Answer: A

Section: (none)

Explanation/Reference:

Explanation:

For More Info Visit www.logicsmeet.com

QUESTION 461

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.) Oracle 1z0-053 Exam

A.Diagnose and repair a data file corruption offline.

B.Diagnose and repair a data file corruption online.

C.Diagnose and repair failures on a standby database.

D.Recover from failures in the Real Application Cluster (RAC) environment.

Answer: CD

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 462

In which cases is reference partitioning effective in enhancing performance?

A.It is effective only in partition pruning.

B.It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C.It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

D.It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

Answer: D

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 463

In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)

A.partitioning recommendations

B.statistics collection recommendations

C.index creation recommendations

D.materialized view recommendations

E.materialized view log recommendations

Answer: ACDE

Section: (none)

Explanation/Reference:

Explanation:

In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation recommendations, materialized view recommendations, and materialized view log recommendations. The SQL Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views, indexes (Btree, bitmap, and function-based), and materialized view logs, as well as advice on table and index

For More Info Visit www.logicsmeet.com

partitioning. The SQL Access Advisor provides recommendations by analyzing a known workload and other specified information. SQL Access Oracle 1z0-053 Exam

Advisor does not generate statistics collection recommendations. This task is performed by the SQL Tuning Advisor.

QUESTION 464

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

A.The database must be running in ARCHIVELOG mode.

B.No special setup is required, and the feature is enabled by default.

C.The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

D.The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

E.Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 465

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

A.stored scripts in the recovery catalog

B.backups that can be deleted from disk

C.backup sets and image copies are obsolete

D.backups that do not have the AVAILABLE status in the RMAN repository

Answer: AD

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 466

View the Exhibit for the object interdependency diagram.

Oracle 1z0-053 Exam

The PRODUCTS table is used to create the PRODCAT_VW view.

PRODCAT_VW is used in the GET_DATA procedure.

GET_DATA is called in the CHECK_DATA function.

A new column PROD_QTY is added to the PRODUCTS table.

How does this impact the status of the dependent objects?

For More Info Visit www.logicsmeet.com

A.All dependent objects remain valid.

B.Only the procedure and function become invalid and must be recompiled.

C.Only the view becomes invalid and gets automatically revalidated the next time it is used.

D.Only the procedure and function become invalid and get automatically revalidated the next time they are called.

Answer: A

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 467

View the Exhibit to examine the parameters set for your database instance.

You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, -

max_latency=>50, -

max_iops=>:max_iops, -

max_mbps=>:max_mbps, -

actual_latency=>:actual_latency); Oracle 1z0-053 Exam

Which statement describes the consequence?

For More Info Visit www.logicsmeet.com

A.The command produces an error.

B.The calibration process runs successfully and populates all the bind variables.

C.The calibration process runs successfully but the latency time is not computed.

D.The calibration process runs successfully but only the latency time is computed.

Answer: A

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 468

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?

A.Set a threshold for the default system-defined moving window baseline.

B.Add directives to the Automatic Database Diagnostic Monitor (ADDM).

C.Modify the profile for the targeted users for which control needs to be imposed.

D.Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

Answer: D

Section: (none)

Explanation/Reference:

Explanation:

Oracle 1z0-053 Exam

QUESTION 469

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed

For More Info Visit www.logicsmeet.com

that the USER_DATA tablespace was accidentally dropped.

On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

A.Option A

B.Option B

C.Option C

D.Option B

Answer: A

Section: (none)

Explanation/Reference:

Explanation:

Perform the following operations within a RUN block: 1.

Use SET UNTIL to specify the target time, restore point, SCN, or log sequence number for DBPITR. If specifying a time, then use the date format specified in the NLS_LANG and NLS_DATE_FORMAT environment

variables.

2.

Oracle 1z0-053 Exam

If automatic channels are not configured, then manually allocate disk and tape channels as needed. 3.

For More Info Visit www.logicsmeet.com

Restore and recover the database.

The following example performs DBPITR on the target database until SCN 1000:

RUN

{

SET UNTIL SCN 1000; RESTORE DATABASE; RECOVER DATABASE;

}

As shown in the following examples, you can also use time expressions, restore points, or log sequence numbers to specify the SET UNTIL time:

SET UNTIL TIME 'Nov 15 2004 09:00:00';

SET UNTIL SEQUENCE 9923;

SET UNTIL RESTORE POINT before_update;

QUESTION 470

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT · /u02 /backup/ %U' ,"

RMAN> RUN

(

ALLOCATE CHANNEL Chi DEVICE TYPE DISK;

EXECUTE SCRIPT full_backup;

)

Which statement is true when the RMAN RUN block Is executed?

A.The execution of the script fails because multiple channels cannot coexist.

B.The script is executed and both the channels are used for the script execution.

C.The new channel, CHI, is Ignored because a channel has been configured already. Oracle 1z0-053 Exam

D.ration parameter DCI is overridden because a new channel is allocated in RMAN RUN block.

Answer: D

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 471

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

A.Segment Advisor

B.SQL Access Advisor

C.Optimizer statistics gathering

For More Info Visit www.logicsmeet.com

D.Automatic SQL Tuning Advisor

E.Automatic Database Diagnostics Monitor

Answer: ACD

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 472

Examine the output of the query that you executed to list the objects in the recycle bin:

You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:

SQL> PURGE TABLE sales_tab;

What would be the outcome of this command?

A.All three tables in the recycle bin are purged

B.Only the table with the oldest DROPSCN is purged

C.The command returns an error because multiple entries with the same name exist in the recycle bin Oracle 1z0-053 Exam

D.Only the table with the latest DROPSCN is purged

Answer: B

Section: (none)

Explanation/Reference:

Explanation:

verified

http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_9018.htm If you specify the user-specified name, and if the recycle bin contains more than one object of that name, then the database purges the object that has been in the recycle bin the longest. Use the PURGE statement to remove a table or index from your recycle bin and release all of the space associated with the object, or to remove the entire recycle bin, or to remove part of all of a dropped tablespace from the recycle bin.

When the database purges a table, all table partitions, LOBs and LOB partitions, indexes, and other dependent objects of that table are also purged.

For More Info Visit www.logicsmeet.com

The database object must reside in your own schema or you must have the DROP ANY... system privilege for the type of object to be purged, or you must have the SYSDBA system privilege.

QUESTION 473

You issue the following RMAN command to set a retention policy on a database:

RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

What will be the outcome of issuing this command?

A.After two days, a backup will be marked obsolete

B.After two days, a backup will be deleted from the media

C.If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

D.If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

Answer: D

Section: (none)

Explanation/Reference:

Explanation:

Oracle 1z0-053 Exam

QUESTION 474

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

A.It does not allow you to change the moving window size.

B.Adaptive threshold functionalities use it by default to compute statistics.

C.It is created by default with the window size being equal to the AWR retention time.

D.It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 475

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

For More Info Visit www.logicsmeet.com

B.SQL profile recommendations

C.index-related recommendations

D.restructuring of SQL recommendations

Answer: B

Section: (none)

Explanation/Reference:

Explanation:

QUESTION 476

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.

Which three statements about resumable space allocation are true? (Choose three.)

A.Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.

B.A resumable statement is suspended only if an out of space error occurs. Oracle 1z0-053 Exam

C.When a resumable statement is suspended, the transaction that contains the statement is also suspended.

D.A resumable statement can only be suspended and resumed once during the execution of the statement.

E.You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

Answer: ACE

Section: (none)

Explanation/Reference:

Explanation:

The following three statements are true about resumable space allocation:

Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. When a resumable statement is suspended, the transaction that contains the statement is also suspended. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session. Resumable space allocation is an Oracle feature that allows certain statements to be suspended if space errors, such as out of space errors, space quota exceeded errors, or maximum extents reached errors, occur. Resumable statements include SELECT statements, DML statements, SQL*Loader imports and exports, and some DDL statements. You enable resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a value greater than zero. The parameter represents the amount of time, in seconds, that a resumable statement will be suspended before it is terminated and an error is generated. You can also set this value for a session using the ALTER SESSION ENABLE RESUMABLE TIMEOUT n; statement, or, you can disable resumable space allocation for a session using the ALTER SESSION DISABLE RESUMABLE; statement. If you have enabled resumable space allocation and a resumable statement experiences a space error, the statement is suspended. If the statement is contained within a transaction, the transaction is also suspended. This gives you the opportunity to correct the space issue. After the space issue is corrected, the suspended statement automatically resumes execution.

You can query the V $SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session. The event column of the V$SESSION_WAIT view will display statement suspended, wait error to be cleared for a statement that is suspended. The sid column identifies the session id that executed the suspended statement, and the seconds_in_wait column displays the number of seconds the statement has been suspended. The option that states a resumable statement is suspended only if an out of space error occurs is incorrect. A resumable statement is also suspended if a space quota is exceeded or a maximum extents reached error occurs. The option that states a resumable statement can only be suspended

For More Info Visit www.logicsmeet.com