Oracle Database 11g: Administrator I : 1z1-052 Exam

Killtest Practice Exams for 1Z0-052 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.48. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.
Answer: D

49. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;
REASON METRIC_VALUE
—————————— ————
Tablespace [TEST] is [28 perce 28.125
nt] full
What could be the reason for the elimination of the other rows in the output?
A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
Answer: C

High quality and Valued for the 1Z0-052 Exam: 100% Guarantee to Pass Your 1Z0-052 exam and get your 11g Certification. Come to http://www.Killtest.com The easiest and quickest way to get your 11g Certification.

100% Guarantee to Pass Your 11g exam and get your 11g Certification.
We guarantee your success in the first attempt. If you do not pass the 11g “1Z0-052″ (Oracle Database 11g: Administrator I : 1z1-052 Exam) on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee OR send you another same value product for free.

High quality and Value for the 1Z0-052 Exam.
Killtest Practice Exams for 1Z0-052 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.

36. In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table along with the user information.

What action would you take to achieve this task?
A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to audit object privileges.
D.Impose standard database auditing to audit SQL statements.
Answer: B

37. You execute the following command to audit database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
A.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
Answer: C