Killtest Practice Exams for Oracle9i Database:Performance Tuning 1z0-033 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.Printable Exams (in PDF format) Our Exam 1z0-033 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 .
181. Which two SQL operations on large tables require the use of a temporary segment for sorting? (Choose two.)
A.querying with UNION ALL
B.joins that are not using index
C.using index access for table joins
D.using the ANALYZE TABLE statement with the ESTIMATE clause
E.using the ANALYZE TABLE statement with the COMPUTE clause
ANSWER: BE
182. In your database the SORT_AREA_SIZE and HASH_AREA_SIZE are set to small values. Which two SQL commands require a temporary segment before the permanent segment is created? (Choose two.)
A.CREATE INDEX
B.CREATE UNDO TABLESPACE
C.CREATE ROLLBACK SEGMENT
D.ENABLE UNIQUE KEY CONSTRAINT
ANSWER: AD
Tags:
Post comment:
◎welcome to give out your point。