1z0-071 Practice Test

1z0-071 Practice Test practice questions, page 11 of 11, with answer review and explanations.

Question 51

Examine the description of the EMPLOYEES table: Which two queries will result in an error? (Choose two.) A. B. C. D. E. F.

Question 52

You create a table named 123. Which statement runs successfully?

  1. SELECT * FROM TABLE(123);
  2. SELECT * FROM "123";
  3. SELECT * FROM \'123\';
  4. SELECT * FROM '123';

Question 53

Which two statements are true regarding indexes? (Choose two.)

  1. An update to a table can result in updates to any or all of the table's indexes.
  2. An update to a table can result in no updates to any of the table's indexes.
  3. A UNIQUE index can be altered to be non-unique.
  4. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped.
  5. A table belonging to one user cannot have an index that belongs to a different user.

Question 54

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)? (Choose two.)

  1. The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.
  2. None of the set operators can be used when selecting CLOB columns.
  3. There must be an equal number of columns in each SELECT list.
  4. Each SELECT statement in the query can have an ORDER BY clause.
  5. The FOR UPDATE clause cannot be specified.