QUESTION: 25

Assuming that the department_number column is not an index, which three statements are true about the following? (Choose three.) UPDATE employee SET salary_amount = salary_amount * 1.1 WHERE department_number = 403;

Read locks are applied.
A pseudo lock is applied.
Write locks are applied at the table level.
Write locks are applied on all updated rows.
Write locks will queue behind existing read locks.

Answer(s): B,C,E

Reveal Solution Next Question

QUESTION: 26

Two tables prepared simultaneously for a join is an example of what kind of parallelism?

Multi-AMP
Multi-step
Multi-session
Multi-statement
Multi-threading

Answer(s): B

Reveal Solution Next Question

QUESTION: 27

Given this request where col is the UPI of table T1: SELECT * FROM T1 WHERE col = 1
;SELECT* FROM T1 WHERE col = 2;
Which three types of parallelism does it exhibit? (Choose three.)

Multi-step
Multi-AMP
Multi-request
Multi-session
Multi-statement

Answer(s): A,B,E

Reveal Solution Next Question

QUESTION: 28

A person submits a high volume of all-AMP requests.
What two strategies can be used to increase parallelism? (Choose two.)

Use more sessions
Use NUSIs on the tables
Use multi-statement requests
Use multi-request transactions

Answer(s): A,C

Reveal Solution Next Question

Free NR0-016 Exam Braindumps (page: 8)

QUESTION: 25

QUESTION: 26

QUESTION: 27

QUESTION: 28

NR0-016 Discussions & Posts