Oracle Database 11g: New Features for Administrators (1Z1-050) Free Practice Test

Question 1

Examine the following values of the Initialization parameters In the database having the SID ORCL:
BACKGROUNDJDUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01 /app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?

A. /u01/app/oracle/product/11.1.0/db_1

B. $ORACLE_HOME/log

C. /u01/app/oracle

D. $ORACLE_HOME/bdump

Correct Answer: C

Question 2

View the Exhibit exhibit1 to examine the series of SQL commands.

View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to
FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

A. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.

B. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.

C. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

Correct Answer: C

Question 3

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. Insert a finding directive for future ADDM tasks.

B. Create a repeating baseline template.

C. Create and populate a SQL Tuning Set from the AWR on every Monday.

D. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

Correct Answer: B

Question 4

Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE1;
What is the impact of this setting on the usage of Secure Files?

A. It does not allow the creation of Secure Files and generates an error if the SECUREFILE option is specified to create the LOB.

B. It forces Secure Files to be created even if the BASICFILE option is specified to create the LO

C. It forces Basic Files to be created even if the SECUREFILE option is specified to create the LOB.

D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a Basic File.

Correct Answer: C

Question 5

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=>5u,max_iops=>:max_iops, max_mbps=>:max_mbps, actual latency=>: actual_latency);
Which statement describes the consequence?

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

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

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

D. The command produces an error.

Correct Answer: D

Question 6

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

What is the reason for this error?

A. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

B. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

C. Another repair session is running concurrently.

D. The failure ID has not been mentioned in the command for data file 5.

Correct Answer: C

Question 7

Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

A. running the database in shared server mode

B. Close all sessions performing queries using database links.

C. setting up the directory to capture the workload

D. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.

Correct Answer: C,D

Question 8

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

A. SQL Tuning Set

B. Automatic Workload Repository (AWR) snapshots

C. Cursor cache

D. Stored outline

Correct Answer: A,C

Question 9

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

A. It produces less accurate results of the comparison analysis.

B. Only the changes in the execution plan, and not performance regression, are detected.

C. It automatically calls the SQL Tuning Advisor for recommendations.

D. It shortens the time of execution and reduces the impact on system resources

Correct Answer: A,D

Question 10

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode.
3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A. 1,4, 3, 5 (2 is not required.)

B. 2, 1,5,3,4

C. 1, 2,4, 5 (3 is not required.)

D. 1,4, 5, 3 (2 is not required.)

E. 1,2,4,5,3

Correct Answer: D

Question 11

The INVJHISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY
(inv_no NUMBER(3),
inv_date DATE,
inv_amtNUMBER(10,2))
partition by range (inv_date)
interval (numtoyminterval(1 ,'month'))
(partition pO values less than (to_date(l01-01-2005llldd-mm-yyyy1)),
partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INVJHISTORY table :
INV_NO INV_DATE INV_AMT
1 30-dec-2004 1000
2 30-dec-2005 2000
3 1-feb-2006 3000
4 1-mar-2006 4000
5 1-apr-2006 5000
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(l15-feb-2006l,ldd-mon-yyyy,)),FOR(TO_DATE(l15-apr-20061))
INTO PARTITION sys_py;
What would be the outcome of this command?

A. It produces an error because the date values specified in the merge do not match the date values stored in the table.

B. It executes successfully, and the transition point is set to "l-apr-20061.

C. It executes successfully, and the transition point is set to '15-apr-2006'.

D. It produces an error because the partitions specified for merging are not adjacent.

Correct Answer: D

Welcome to TestSimulate

Oracle Database 11g: New Features for Administrators (1Z1-050) Free Practice Test