Oracle Data Warehousing 11g Essentials

1.

A customer is looking to upgrade to Oracle Database 11 g Release 2 when they bring in a new database server. Which two features of the release can the customer use to ensure that the performance of their new Oracle Database is maintained through the upgrade?

using Database Replay to capture the workload on the existing server, to be used in testing the new server environment adding 20% more memory to the new server to handle the increased requirements of Oracle Database 11 g Release 2 reproducing the current client environment on the new server to ensure that the new environment can deliver the same results with the same workload. using SQL Performance Analyzer to compare the performance of SQL statements in the new and old server environments running both systems in parallel during production usage

2.

In your database, the SQL Tuning Advisor is running automatically during the system maintenance window as a maintenance task. Which of its recommendations
would be implemented automatically?

creation of new Indexes refreshing optimizer statistic restructuring SQL statements creation or modification of a SQL Profile

3.

Which statement is true regarding Automatic Memory Management?

You need to specify only the SGA memory size. You need to specify the SGA and PGA memory sizes separately. You need to specify the total memory size, which is dynamically sized for SGA and PGA components and can beexchanged between the SGA and PGA. You need to specify the total memory size, which is dynamically sized for SGA and PGA components but cannot be exchanged between the SGA and PGA.

4.

Which three options correctly map SQL commands with their categories? (Choose thee)

MERGE: Data manipulation language DROP: data control language ROLLBACK: transition control REVOKE: Data control language ALTER: Data manipulation language

5.

Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?

Submit a job that queries the Automatic Workload Repository (AWK). Create an alert that sends a notification when the threshold value is reached. Invoke the Database Configuration Assistant (DBCA. to configure notifications and set threshold values. Specify the users who should receive notifications In the Preferred Credentials of the Enterprise Manager. Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message.

6.

You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid
this potential outcome, your best course of action would be to:

refrain from collecting statistics use Real Application Testing to capture the workload and the worked and then run the worked on a test machine use hints to create fixed plans for SQL statements use deferred publishing of statistics to allow you to test execution plans before making the statistics public use invisible indexes to dominate execution plans

7.

Your database is down. You log in as the user SYS and issue the following command:

SQL>STARTU P

Which stops occur and in what order as a result of executing this command?

Only the instance is started. Instance is started and then database is mounted but not opened. Instance is started, then the database is mounted and finally opened. Instance is started, then the database is opened and finally mounted.

8.

You issue the following command as a DBA:

SQL> SHUTDOWN

What would be the outcome of the above command?

It causes the instance to abort. It waits for all sessions to disconnect. It rolls back the current transactions and disconnects all sessions. It waits for the current transaction in each session to complete before disconnecting the sessions.

9.

Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility
would you use to start the listener?

Oracle Not Manager listener Control utility Database Configuration Assistant Oracle Net configuration Assistant

10.

You want to use the automatic management of backup and recovery operations feature for your database. Which configuration must you set?

Enable the flash recovery area and specify it as the archived redo log destination Disable the flash recovery area and start the database instance in ARCHIVELOG mode. Enable the flash recovery area but do not specify it as the archived redo log destination. Disable the flash recovery area and start the database instance in NOABCHIVELOG mo.

Oracle Data Warehousing 11g Essentials

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle Data Warehousing 11g Essentials

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner