1z0-071 Practice Test

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

Question 36

Examine the description of the BOOKS table: The table has 100 rows. Examine this sequence of statements issued in a new session: INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

  1. The second ROLLBACK command replays the delete.
  2. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.
  3. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.
  4. The second ROLLBACK command undoes the insert.
  5. The second ROLLBACK command does nothing.

Question 37

Which two statements are true about an Oracle database? (Choose two.)

  1. A table can have multiple primary keys.
  2. A column definition can specify multiple data types.
  3. A table can have multiple foreign keys.
  4. A VARCHAR2 column without data has a NULL value.
  5. A NUMBER column without data has a zero value.

Question 38

Examine the data in the EMP table: You execute this query: Why does an error occur?

  1. An alias name must not contain space characters.
  2. An alias name must always be specified in quotes.
  3. An alias name must not be used in an ORDER BY clause.
  4. An alias name must not be used in a GROUP BY clause.

Question 39

Which two actions can you perform with object privileges? (Choose two.)

  1. Create roles.
  2. Create FOREIGN KEY constraints that reference tables in other schemas.
  3. Delete rows from tables in any schema except SYS.
  4. Set default and temporary tablespaces for a user.
  5. Execute a procedure or function in another schema.

Question 40

No user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)? (Choose three.)

  1. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks, and erases all its savepoints.
  2. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
  3. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
  4. ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction.
  5. COMMIT ends the transaction and makes all its changes permanent.
  6. COMMIT erases all the transaction's savepoints and releases its locks.