Practicetest 1Z0-033 Oracle it-exams
Practicetest 1Z0-033 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-033 Oracle9i Database: Performance Tuning our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-033 Oracle it-exams
QUESTION 1
In your test database, you want to automatically collect database statistics at regular intervals. You execute the spauto.sql script to automate this task. What must you ensure before executing this script?
A. The AQ_TM_PROCESSES parameter is set to a value higher than one.
B. The THREAD parameter is set to a nonzero value.
C. The OPTIMIZER_MODE parameter is set to CHOOSE.
D. The JOB_QUEUE_PROCESSES parameter is set to a nonzero value.
E. The LOCK_SGA parameter is set to TRUE.
Answer: D
QUESTION 2
You receive complaints from database users about performance degradation. On investigation, you find that this is due to unnecessary sort operations in the database. Which are the two operations that would reduce sorting? (Choose two.)
A. using UNION instead of UNION ALL, wherever possible
B. using sort-merge join instead of the nested-loop join
C. using ANALYZE command for large objects with ESTIMATE clause instead of COMPUTE
D. creating indexes on the columns that are used in equijoins
Answer: CD
QUESTION 3
While doing a routine performance check of your test database, you find that a large number of statements are getting invalidated in the library cache, thereby causing the statements to be reparsed. What could be the reason for the invalidations?
A. Statistics have not been collected on the referenced columns.
B. There is not enough free space in the Shared Pool.
C. The structures of dependent objects have been modified.
D. Stored outlines are being used.
E. The Shared Pool Reserved Space is not configured.
Answer: C
QUESTION 4
Which statement could require a sort?
A. SELECT DISTINCT dept_id
FROM emp:
B. UPDATE emp SET salary=salary*1.1
WHERE id=7722;
C. SELECT emp_id, name
FROM emp
WHERE emp-id=7722;
D. SELECT emp_id, name
FROM emp
WHERE emp_id BETWEEN7722and7100;
Answer: A
Practicetest 1Z0-033 Oracle it-exams
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, it-exams.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
1Z0-033 Oracle9i Database: Performance Tuning our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.
Practicetest 1Z0-033 Oracle it-exams
QUESTION 1
In your test database, you want to automatically collect database statistics at regular intervals. You execute the spauto.sql script to automate this task. What must you ensure before executing this script?
A. The AQ_TM_PROCESSES parameter is set to a value higher than one.
B. The THREAD parameter is set to a nonzero value.
C. The OPTIMIZER_MODE parameter is set to CHOOSE.
D. The JOB_QUEUE_PROCESSES parameter is set to a nonzero value.
E. The LOCK_SGA parameter is set to TRUE.
Answer: D
QUESTION 2
You receive complaints from database users about performance degradation. On investigation, you find that this is due to unnecessary sort operations in the database. Which are the two operations that would reduce sorting? (Choose two.)
A. using UNION instead of UNION ALL, wherever possible
B. using sort-merge join instead of the nested-loop join
C. using ANALYZE command for large objects with ESTIMATE clause instead of COMPUTE
D. creating indexes on the columns that are used in equijoins
Answer: CD
QUESTION 3
While doing a routine performance check of your test database, you find that a large number of statements are getting invalidated in the library cache, thereby causing the statements to be reparsed. What could be the reason for the invalidations?
A. Statistics have not been collected on the referenced columns.
B. There is not enough free space in the Shared Pool.
C. The structures of dependent objects have been modified.
D. Stored outlines are being used.
E. The Shared Pool Reserved Space is not configured.
Answer: C
QUESTION 4
Which statement could require a sort?
A. SELECT DISTINCT dept_id
FROM emp:
B. UPDATE emp SET salary=salary*1.1
WHERE id=7722;
C. SELECT emp_id, name
FROM emp
WHERE emp-id=7722;
D. SELECT emp_id, name
FROM emp
WHERE emp_id BETWEEN7722and7100;
Answer: A
Practicetest 1Z0-033 Oracle it-exams
nina008 - 23. Dez, 05:13
