1z0-182

1z0-182 practice questions, page 6 of 6, with answer review and explanations.

Question 26

Which of the following statements is true about external tables?

  1. They describe data stored in the database.
  2. They describe how the external table layer presents data to the server.
  3. They are read/write tables.
  4. They describe how data is stored in the external source.

Question 27

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed? (Choose two.)

  1. The initialization parameter file is read.
  2. Oracle background processes are started.
  3. Online redo logs are opened.
  4. Oracle shared memory structures are allocated.
  5. Online data files are opened.
  6. Control files are read.
  7. The alert log has instance startup details written to it.

Question 28

You execute the SHUTDOWN ABORT command. Which two statements are true? (Choose two.)

  1. Subsequent instance startup performs media recovery.
  2. Uncommitted transactions are not rolled back by the shutdown.
  3. Subsequent instance startup performs instance recovery.
  4. Data files are closed normally.
  5. A checkpoint is written.