Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-035
Title
: Orcacle9i dba New Features
For Oracle7.3 And Oracle9
Ocps
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services?
A. to transfer redo log information to one or more destinations
B. to apply redo log records sent from the primary database to a standby database at the receiving location
C. to synchronize changes to the control files on all standby databases with changes on the primary
database when a log switch occurs
D. to batch archived log files on the primary database until a defined number of checkpoints have been
processed and then to distribute the archives to each standby database
Answer: A
2. Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (-
2> ownname => 'OE', -
3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -
4> method_opt =>
'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?
A. The Oracle server creates a new histogram based on existing histogram definitions for all table, column,
and index statistics for the OE schema.
B. The Oracle server creates a histogram based on data distribution regardless of how the application uses
the column/s for all table, column, and index statistics for the OE schema.
C. The Oracle server creates a histogram based on data distribution and application usage of the column/s
for all table, column, and index statistics for the OE schema.
D. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all
table, column, and index statistics for the OE schema.
Answer: C
3. What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?
A. the filename format
B. information stored inside a data dictionary table
C. information stored in t