Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 411:

  Examine the contents of the EMP table:

  

  Examine this query that executes successfully:

  

  What is the result?

  A. It will return the five employees earning the lowest salaries, in ascending order.

  B. It will return the six employees earning the highest salaries, in descending order.

  C. It will return the six employees earning the lowest salaries, in ascending order.

  D. It will return the five employees earning the highest salaries, in descending order.

  Correct Answer: A

• Question 412:

  Which statement fails to execute successfully?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 413:

  Examine this statement which executes successfully:

  

  Which statement will violate the CHECK constraint?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 414:

  You execute these commands:

  

  Which two, used independently, can replace so the query returns 1?

  A. ROLLBACK;

  B. ROLLBACK TO SAVEPOINT post_insert;

  C. ROLLBACK TO post_insert;

  D. COMMIT;

  E. COMMIT TO SAVEPOINT post_insert;

  Correct Answer: BC

• Question 415:

  Examine this description of the PRODUCTS table:

  

  Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.

  Which three commands execute successfully on PRODUCTS? (Choose three.)

  A. CREATE INDEX price_idx ON products (price);

  B. ALTER TABLE products SET UNUSED (expiry_date);

  C. DROP TABLE products;

  D. ALTER TABLE products DROP COLUMN expiry_date;

  E. TRUNCATE TABLE products;

  F. ALTER TABLE products DROP UNUSED COLUMNS;

  Correct Answer: ACF