1z0-071 Practice Test

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

Question 11

Which three are true about scalar subquery expressions? (Choose three.)

  1. They can be nested.
  2. They cannot be used in the VALUES clause of an INSERT statement.
  3. A scalar subquery expression that returns zero rows evaluates to zero.
  4. They can be used as default values for columns in a CREATE TABLE statement.
  5. A scalar subquery expression that returns zero rows evaluates to NULL.
  6. They cannot be used in GROUP BY clauses.

Question 12

Examine this query: Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)

  1. Use the DEFINE command before executing the query.
  2. Replace '&1' with '&&1' in the query.
  3. Use the UNDEFINE command before executing the query.
  4. Execute the SET VERIFY OFF command before executing the query.
  5. Execute the SET VERIFY ON command before executing the query.
  6. Store the query in a script and pass the substitution value to the script when executing it.

Question 13

You need to allow user ANDREW to: 1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table. 2. GRANT that permission to other users. Which statement will do this?

  1. GRANT UPDATE ON customers.title, customers.address TO andrew;
  2. GRANT UPDATE (title, address) ON customers TO andrew;
  3. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
  4. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
  5. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
  6. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

Question 14

You own table DEPARTMENTS, referenced by views, indexes, and synonyms. Examine this command which executes successfully: DROP TABLE departments PURGE; Which three statements are true? (Choose three.)

  1. It will remove the DEPARTMENTS table from the database.
  2. It will drop all indexes on the DEPARTMENTS table.
  3. It will remove all views that are based on the DEPARTMENTS table.
  4. It will remove all synonyms for the DEPARTMENTS table.
  5. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
  6. It will delete all rows from the DEPARTMENTS table, but retain the empty table.

Question 15

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

  1. It requires that data be contained in hierarchical data storage.
  2. It best supports relational databases.
  3. It provides independence for logical data structures being manipulated from the underlying physical data storage.
  4. It is the only language that can be used for both relational and object-oriented databases.
  5. It guarantees atomicity, consistency, isolation, and durability (ACID) features.
  6. It is used to define encapsulation and polymorphism for a relational table.