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?