1z0-071 Practice Test

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

Question 16

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

  1. Any user can create a PUBLIC synonym.
  2. A synonym has an object number.
  3. All private synonym names must be unique in the database.
  4. A synonym can be created on an object in a package.
  5. A synonym can have a synonym.

Question 17

Which is true about the ROUND, TRUNC and MOD functions?

  1. TRUNC(MOD(25,3),-1) is invalid.
  2. ROUND(MOD(25,3),-1) is invalid.
  3. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid and give the same result.
  4. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid but give different results.

Question 18

Which two are true about transactions in the Oracle Database? (Choose two.)

  1. DML statements always start new transactions.
  2. DDL statements automatically commit only data dictionary updates caused by executing the DDL.
  3. A session can see uncommitted updates made by the same user in a different session.
  4. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.
  5. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

Question 19

Examine the description of the MEMBERS table: Examine the partial query: SELECT city, last_name AS lname FROM members ...; You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order. Which two clauses must you add to the query? (Choose two.)

  1. ORDER BY 1, 2
  2. ORDER BY 1, lname DESC
  3. WHERE city IN ('%AN%')
  4. WHERE city = '%AN%'
  5. WHERE city LIKE '%AN%'
  6. ORDER BY last_name DESC, city ASC

Question 20

Examine this partial command: Which two clauses are required for this command to execute successfully? (Choose two.)

  1. the access driver TYPE clause
  2. the DEFAULT DIRECTORY clause
  3. the REJECT LIMIT clause
  4. the LOCATION clause
  5. the ACCESS PARAMETERS clause