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

Question 1

Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?

A. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

B. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE

D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.

Correct Answer: C

Question 2

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 3

View the Exhibit to examine the Automatic SQL Tuning result details.

Which action would you suggest for the selected SQL statement in the Exhibit?

A. Run the Access Advisor for the SQL statement.

B. Accept the recommended SQL profile.

C. Collect statistics for the related objects.

D. Run the Segment Advisor for recommendations.

Correct Answer: A

Question 4

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

A. direct path load of data from external files

B. logging in and logging out of sessions

C. flashback query

D. distributed transactions

E. all DDL statements having bind variables

Correct Answer: B,E

Question 5

View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ 'customers^be1, '(countryjd, cust_state_province)') FROM dual;
Which statement describes the significance of this command?

A. It collects statistics into the pending area in the data dictionary.

B. It creates a virtual hidden column in the CUSTOMERSjDBE table.

C. It creates a histogram to hold skewed information about the data in the columns.

D. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

Correct Answer: B

Question 6

View the Exhibit exhibit1 to observe the maintenance window property.

View the Exhibit exhibits to examine the output of the query.
Which two statements describe the conclusions? (Choose two.)

A. RESOURCE_PERCENTAGE should be increased.

B. RESOURCE_PERCENTAGE should be decreased.

C. The repeat time for the window should be decreased.

D. The window duration should be increased.

Correct Answer: A,D

Question 7

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 8

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

A. Traditional partition pruning and partitionwise joins are not supported on these tables.

B. Only a single partitioning key column can be specified.

C. Unique local indexes cannot be created on a system-partitioned table.

D. The same physical attributes must be specified for each partition.

E. All DML statements must use partition-extended syntax.

Correct Answer: A,C

Question 9

Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates only the space that is currently unallocated.

B. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.

C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.

E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

Correct Answer: B,E

Question 10

Which statement is true regarding the VALIDATE DATABASE command?

A. It checks for block corruption in the valid backups of the database.

B. It checks the database for intrablock corruptions only

C. It checks for only those corrupted blocks that are associated with data files.

D. It checks the database for both intrablock and interblock corruptions.

Correct Answer: B

Question 11

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for the current sessions only.

C. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

D. The statistics are treated as the current statistics by the optimizer for all sessions.

Correct Answer: A

Question 12

You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

A. to enhance the query performance by creating a cache in the client memory for sorting operations

B. to improve performance by storing a copy of the data from the private SQL area of the PGA

C. to avoid round trips to the server by enabling caching of query results in client memory

D. to avoid the storing of query plans and results in the server by creating a cache in the client memory

Correct Answer: C

Question 13

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

A. Auditing is enabled for certain privileges related to database security.

B. The audit trail is stored in an operating system file.

C. Auditing is disabled for all privileges.

D. Auditing is enabled for all privileges.

E. The audit trail is stored in the database

Correct Answer: A,E

Question 14

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?

A. A template needs to be associated with the task.

B. A workload needs to be associated with the task.

C. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.

D. The partial or complete workload scope needs to be associated with the task.

Correct Answer: B

Welcome to TestSimulate

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