Oracle Database 11g: New Features for Administrators - 1Z0-050 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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 avoid round trips to the server by enabling caching of query results in client memory C. to improve performance by storing a copy of the data from the private SQL area of the PGA D. to avoid the storing of query plans and results in the server by creating a cache in the client memory

Discussion 0

Correct Answer: B Vote an answer

Question 2

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 value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. B. The COMMIT order in the captured workload is preserved during replay. C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. D. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins. E. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 3

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

A. AWR baselines are always created as repeating baselines. B. AWR baselines can be created on the basis of two time values. C. AWR baselines are always created with infinite expiration duration. D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Discussion 0

Correct Answer: B Vote an answer

Question 4

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 RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed. B. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE C. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR). D. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

Discussion 0

Correct Answer: B Vote an answer

Question 5

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.
The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it.
What action is required for dependent objects when you perform online table redefinition?

A. The dependent materialized view should have a complete refresh performed after the online table redefinition process. B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process. C. The materialized log should be dropped before the online table redefinition process. D. Referential integrity constraints must be manually enabled after the online table redefinition process.

Discussion 0

Correct Answer: A Vote an answer

Question 6

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 compresses all data added or modified henceforth but the existing data in the table is not compressed immediately. B. It produces an error because data already exists in the table. C. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data. D. It produces an error because compression can be enabled at table creation only.

Discussion 0

Correct Answer: A Vote an answer

Question 7

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE TO
dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database. B. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database. C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure. D. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

Discussion 0

Correct Answer: D Vote an answer

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 files are retained but 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 metadata is purged when the problem is resolved and the DBA closes the SR.

Discussion 0

Correct Answer: C Vote an answer

Question 9

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. B. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline. C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). D. Capture the plans from the previous version using STS and then load them into the stored outline.

Discussion 0

Correct Answer: C Vote an answer

Question 10

Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

A. when some disks in a disk group are offline B. when some disks in a failure group for a disk group are rebalancing C. when ASM disk goes offline D. when one or more ASM files are dropped

Discussion 0

Correct Answer: A Vote an answer

Question 11

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. Only the changes in the execution plan, and not performance regression, are detected. B. It produces less accurate results of the comparison analysis. C. It shortens the time of execution and reduces the impact on system resources D. It automatically calls the SQL Tuning Advisor for recommendations.

Discussion 0

Correct Answer: B,C Vote an answer

Question 12

You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

A. Set the CURSOR_SHARING parameter to EXACT for the database instance. B. Edit the automatic maintenance window group configuration. C. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance. D. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.

Discussion 0

Correct Answer: D Vote an answer