Exadata Database Machine: 12c Administration Workshop Quiz Questions and Answers

Loss of control file of database won’t impact the database availability.

Answer :
  • FALSE

Which is the smallest unit of storage in an Oracle database?

Answer :
  • Oracle Data Block

The redo log buffer and shared pool are elements of?

Answer :
  • SGA

Which two tasks can be performed on an external table?

Answer :
  • updating the table by using an update statement
  • creating a public synonym

Which two statements are true about extents?

Answer :
  • Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  • The blocks of a newly allocated extent, although free, may have been used before.

Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?

Answer :
  • A window group must have been created with the WEEKEND_PLAN resource plan

The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA).

Answer :
  • TRUE

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

Answer :
  • REMAP_SCHEMA

What is SPFILE?

Answer :
  • A Binary file that contains parameter for the DB instance.

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of the maximum trigger as an alert. What is the outcome?

Answer :
  • It generates an error because the warning threshold cannot exceed 100%