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%
