Oracle Database 11g: New Features for Administrators

Question 1

SQL> EXECUTE
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

A. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

B. It produces an error because no snapshot information is provided to create the baseline.

C. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

D. It creates a baseline template that never expires.

Correct Answer: D

Question 2

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

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

B. running the database in shared server mode

C. Close all sessions performing queries using database links.

D. setting up the directory to capture the workload

Correct Answer: A,D

Question 3

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is stored in the redo logs.

C. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

D. The data remains encrypted when it is read into memory.

Correct Answer: B

Question 4

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

A. Truncate the table.

B. Drop the table.

C. Partition the table

D. Rename a column in the table.

E. Add a column to the table.

Correct Answer: E

Question 5

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of
data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?

A. It produces an error because data already exists in the table.

B. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

C. It produces an error because compression can be enabled at table creation only.

D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

Correct Answer: B

Question 6

Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?

A. The LOB values are automatically stored in encrypted mode.

B. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

C. The LOB values are automatically compressed.

D. The LOB values are cached by default in the buffer cache.

Correct Answer: B

Question 7

In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It is not persistent across instance startup and shutdown unlike conventional patching.

B. It takes more time to install or uninstall compared with conventional patching.

C. It can be installed and uninstalled via OPatch unlike conventional patching.

D. It consumes more memory compared with conventional patching.

E. It does not require down time to apply or remove unlike conventional patching.

Correct Answer: D,E

Question 8

Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

A. The incident files and dumps are not retained in the ADR for the manually created incidents.

B. The incident metadata is purged when the problem is resolved and the DBA closes the SR.

C. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.

D. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR

Correct Answer: C

Question 9

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. Another repair session is running concurrently.

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

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

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

Correct Answer: A

Question 10

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

A. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

B. It produces results that can be used to create the SQL plan baseline.

C. It shows only the overall impact on workload and not the net SQL impact on workload.

D. The importance of SQL statements is based on the size of the objects accessed.

E. It detects changes in SQL execution plans.

Correct Answer: A,B,E

Question 11

Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT .PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?

A. All fixed plan baselines are converted into nonfixed plan baselines.

B. The plan baselines are verified with the SQL profiles.

C. All the nonaccepted SQL profiles are accepted into the plan baseline.

D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

Correct Answer: D

Question 12

Which statement is true regarding virtual private catalogs?

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

B. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

C. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

D. The virtual private catalog owner cannot create and modify the stored scripts.

Correct Answer: C

Question 13

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

A. PL/SQL functions, procedures, and packages

B. initialization parameter settings

C. the table and index definitions and actual data

D. all the optimizer statistics

E. ADR diagnostic files

Correct Answer: A,B,D

Question 14

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. $ORACLE_HOME/bdump

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

C. $ORACLE_HOME/log

D. /u01/app/oracle

Correct Answer: D

Question 15

View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)

A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

E. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

Correct Answer: A,C,E

Oracle Database 11g: New Features for Administrators - 1Z0-050 Exam Practice Test

Latest Update

Useful Links

Contact Us