OCA OCP Oracle Certification Exam Braindumps

Printable Exams (in PDF format) Our Exam 1z0-035 Preparation Material provides you everything you will need to take your 9i DBA exam. The 9i DBA Certification details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get 9i DBA exam questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first 9i DBA exam try, but also save your valuable time .

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
Correct: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.
Correct: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 the ALERT.LOG file for the corresponding instance
D.information stored inside the corresponding initialization parameter file for the instance
Correct:A