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

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

Answer :
  • Oracle Data Block

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

Answer :
  • FALSE

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.

Which technique should you use to minimize downtime while plugging this non-CDB into the CDB?

Answer :
  • The DBMS_PDB package

Which statement is true about data file?

Answer :
  • The data file is a physical file

Which statement is true about CDB?

Answer :
  • CDB database is a container database

Which statement is true about granting privilege?

Answer :
  • Grant create session to u1

The redo log buffer and shared pool are elements of?

Answer :
  • SGA