1z0-071 Practice Test

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

Question 41

Examine the description of the EMPLOYEES table: Which two queries return rows for employees whose manager works in a different department? (Choose two.) A. B. C. D. E.

Question 42

Which three are true about dropping columns from a table? (Choose three.)

  1. A column must be set as unused before it is dropped from a table.
  2. A primary key column cannot be dropped.
  3. Multiple columns can be dropped simultaneously using the ALTER TABLE command.
  4. A column can be removed only if it contains no data.
  5. A column that is referenced by another column in any other table cannot be dropped.
  6. A column drop is implicitly committed.

Question 43

Which three statements are true about views in an Oracle Database? (Choose three.)

  1. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.
  2. Views have no segment.
  3. Views have no object number.
  4. Views can join tables only if they belong to the same schema.
  5. A view can be created that refers to a non-existent table in its defining query.
  6. Rows inserted into a table using a view are retained in the table if the view is dropped.

Question 44

You start a session and execute these commands successfully: Which two are true? (Choose two.)

  1. To drop the table in this session, you must first truncate it.
  2. Other sessions can view the committed row.
  3. You can add a column to the table in this session.
  4. You can add a foreign key to the table.
  5. When you terminate your session, the row will be deleted.

Question 45

Examine this statement: Which two statements are true? (Choose two.)

  1. The names of employees earning the maximum salary will appear first in an unspecified order.
  2. All remaining employee names will appear in descending order.
  3. All remaining employee names will appear in an unspecified order.
  4. All remaining employee names will appear in ascending order.
  5. The names of employees earning the maximum salary will appear first in ascending order.
  6. The names of employees earning the maximum salary will appear first in descending order.