OCA OCP Oracle Certification Exam Braindumps

121.What would you do to reduce fragmentation within extents?
A.avoid using MINEXTENTS clause while creating a segment
B.reorganize the segments in the uniform extent size tablespaces
C.defragment nonuniform extent size tablespaces by using export/import
D.use locally managed tablespaces instead of dictionary-managed tablespaces

ANSWER: CD

 
122.Which three actions on the TEST_TBS tablespace would result in tablespace checkpoint? (Choose three.)
A.ALTER TABLESPACE test_tbs READ ONLY;
B.ALTER TABLESPACE test_tbs END BACKUP;
C.ALTER TABLESPACE test_tbs BEGIN BACKUP;
D.ALTER TABLESPACE test_tbs OFFLINE NORMAL;
E.ALTER TABLESPACE test_tbs OFFLINE IMMEDIATE;

ANSWER: ACD

 
123.You issued the following query on the V$INSTANCE_RECOVERY dynamic performance view: SELECT target_mttr, estimated_mttr FROM v$instance_recovery; You noticed that the value for the ESTIMATED_MTTR column is greater than the value for the TARGET_MTTR. What would happen in this scenario?
A.A checkpoint is initiated.
B.A warning is written in the alert log file.
C.The number of archiver processes is increased.
D.The control file is updated to mark another checkpoint record.
E.DBWn is requested to write enough dirty buffers to allow the   ESTIMATED_MTTR to fall back below the TARGET_MTTR.

ANSWER: E

 
124.In the parameter file of your production database, the LOG_CHECKPOINT_INTERVAL parameter is set to 3600. When does the checkpoint occur due to this setting?
A.when the number of transactions exceeds the specified value
B.when the specified number of database blocks are written to the data files
C.when a specified amount of time (in seconds) is exceeded after the last checkpoint
D.when the number of dirty buffers in the database buffer cache exceeds the specified value
E.when the number of operating system blocks between an incremental checkpoint and the last block written to the redo log is equal to or greater than the specified value

ANSWER: E

 
125. In your production database, all physical files are available. To make the recovery process faster in the event of a media or instance failure, you set the following parameters in the parameter file: Which statements are true regarding the setting of these parameters? (Choose all that apply.)
A.The FAST_START_MTTR_TARGET parameter is overridden because the LOG_CHECKPOINT_TIMEOUT parameter is set.
B.The FAST_START_MTTR_TARGET parameter is overridden because the LOG_CHECKPOINT_INTERVAL parameter is set.
C.An entry is generated in the database writer trace file if the checkpoint fails.
D.All the parameters are effective because they are independent parameters.

ANSWER: AB