This preview shows page 1. Sign up to view the full content.
Unformatted text preview: S database will be dictionary managed by default.
Answer: B, E
You work as a database administrator for Certkiller .com. In your development
environmentenvironment, the developers are responsible for modifying the table
structure according to the application requirements. However, you want to keep
track of the ALTER TABLE commands being executed by developers, so you
enable auditing to achieve this objective.
Which two views would you refer to find out the audit information? Choose two
D.DBA_COMMON_AUDIT_TRAIL Actualtests.com - The Power of Knowing 1Z0-042 Answer: A, C
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements
regarding the LOGGING clause of the CREATE TABLESPACE... statement are
correcte? Choose two.
A.This clause is not valid for a temporary or undotablespace.
B.If thetablespaceis in the NOLOGGING mode, no operation on thetablespacewill
C.Thetablespacewill be IntheNOLOGGING mode by default, if not specified while
D.Thetablespace-level logging attribute can be overridden by logging specification at the
table, index, materialized view, materialized view log, and partition levels.
Answer: A, D
You work as a database administrator for Certkiller .com. Users complain that their
query is taking a long time to complete. You suspect the database buffer cache size
to be the reason, and you define an alert to be generated when the buffer cache hit
metric goes below 85%. When you observe the dynamic performance views, you
find that the buffer cache hit ratio is 81% but no alerts are being generated.
What could be the reason for this problem?
A.The advisory memory has been turned off.
B.The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C.The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D.The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E.The STATISTICS_LEVEL parameter has...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09