Free NR0-016 Exam Braindumps (page: 8)

Page 7 of 28

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;

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

Answer(s): B,C,E



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

  1. Multi-AMP
  2. Multi-step
  3. Multi-session
  4. Multi-statement
  5. Multi-threading

Answer(s): B



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.)

  1. Multi-step
  2. Multi-AMP
  3. Multi-request
  4. Multi-session
  5. Multi-statement

Answer(s): A,B,E



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

  1. Use more sessions
  2. Use NUSIs on the tables
  3. Use multi-statement requests
  4. Use multi-request transactions

Answer(s): A,C






Post your Comments and Discuss TeraData NR0-016 exam with other Community members:

NR0-016 Discussions & Posts