Oracle
1Z0-068 · Question #32
1Z0-068 Question #32: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-068 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.
Question
Examine this query and output: SQL> select order_flag, cache_size, session_flag, keep_value, 2 from user_sequences where sequence_name = `SEQ1'; O CACHE_SIZE S K -- ---------------- -- - Y 10 N N Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence. The SEQ1 sequence is incremented from all instances equally and is frequently used. Which two statements should you execute to reduce SQ enqueue contention?
Options
- Aalter sequence seq1 cache 10000;
- Balter sequence seq1 order;
- Calter sequence seq1 noorder;
- Dexec sys.dbms_shared_pool.keep (
SEQ1',Q') - Ealter sequence seq1 keep;
Unlock 1Z0-068 to see the answer
You've previewed enough free 1Z0-068 questions. Unlock 1Z0-068 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.