1 / 4

1Z0-514 Preparation Material - PowerPoint PPT Presentation

CertsChief Best IT Certification practice test material provider with thousands of professional it certification Exams, like as CompTIA, Microsoft, Vmware, IBM and more. CertsChief Pass Your Exam with 100% Guarantee with CertsChief Preparation Material. Please visit at:

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

1Z0-514 Preparation Material

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

http://www.certschief.comCertification Preparation Material



Oracle Database 11g Essentials

Demo Product - For More Information - Visit:

Edition = DEMO

ProductFull Version Features:

 90 Days Free Updates

 30 Days Money Back Guarantee

 Instant Download Once Purchased

 24/7 Online Chat Support

Page | 1

http://www.certschief.comCertification Preparation Material

Question: 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?

A. using Database Replay to capture the workload on the existing server, to be used in testing the new server


B. adding 20% more memory to the new server to handle the increased requirements of Oracle Database 11 g

Release 2

C. reproducing the current client environment on the new serverto ensure that the new environment can deliver the

same results with the same workload.

D. using SQL Performance Analyzer to compare the performance of SQL statements in the new and old server


E. running both systems in parallel during production usage

Answer: A, C

Question: 2

In your database, the SQL Tuning Advisor is running automatically during the system maintenancewindow as a

maintenance task. Which of its recommendations would be implemented automatically?

A. creation of new Indexes

B. refreshing optimizer statistic

C. restructuring SQL statements

D. creation or modification of a SQL Profile

Answer: D

Question: 3

Which statement is true regarding Automatic Memory Management?

A. You need to specify only the SGA memory size.

B. You need to specify the SGA and PGA memory sizes separately.

C. 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.

D. 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.

Answer: C

Question: 4

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

A. SELECT: transaction control

B. DROP: data control language

C. ROLLBACK: transition control

D. REVOKE:Data control language

Page | 2

http://www.certschief.comCertification Preparation Material

E. ALTER: Data manipulation language

F. MERGE: Data manipulation language

Answer: C, D, F

Question: 5

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

A. Submit a job that queries the Automatic Workload Repository (AWK).

B. Create an alert that sends a notification when the threshold value is reached.

C. Invoke the Database Configuration Assistant (DBCA. to configure notifications and set threshold values.

D. Specify the users who should receive notifications In the Preferred Credentials of the Enterprise Manager.

E. Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message.

Answer: B

Question: 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:

A. refrain from collecting statistics

B. use Real Application Testing to capture the workload and the worked and then run the worked on a test machine

C. use hints to create fixed plans for SQL statements

D. use deferred publishing of statistics to allow you to test execution plans before making the statistics public

E. use invisible indexes to dominate execution plans

Answer: D

Question: 7

Which two statements are true regarding the usage of integrity constraints? (Choose two.)

A. I EM h column can have only one constraint.

B. Primary key constrain) can consist of multiple columns from the same table.

C. Foreign key column can reference e a primary key column in the same of or different tables.

D. More than one row in a table cannot contain null value In a column with unique constraint.

E. A chock constraint can enforce conditions that refer to the values in other columns in the table.

Answer: B, C

Page | 3

http://www.certschief.comCertification Preparation Material

Demo Product - For More Information - Visit:

20% Discount Coupon Code:


Page | 4

  • Login