1Z0-052章節(jié)練習(2019.02.08)

A.The DML operations re-create the Bitmap index blocks.
B.The Bitmap index is rebuilt automatically after a DML operation.
C.The smallest amount of a bitmap that can be locked is a bitmap segment.
D.Additional time is taken to remove NULL values from the Bitmap index after a DML operation.

A.You can add SQL test cases to the incident package.
B.You can add or remove the trace files to the package.
C.You cannot create an incremental incident package when the physical files are purged from the ADR.
D.You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.

A.4 and 5
B.1，3，and 6
C.4，5，and 6
D.3，4，and 5
E.1，2，and 6

A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.

A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

A.The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D.The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

A.2， 5， 1， 4， 3
B.1， 2， 3， 4， 5
C.5， 2， 1， 3， 4
D.2， 1， 5， 4， 3

A.committing a transaction
B.flashing back a transaction
C.recovering a failed transaction
D.running a read-consistent query
E.changing a tablespace status from READ ONLY to READ WRITE

A.Use the database link.
B.Use the SQL*Loader utility.
C.Use the Oracle Data Pump utility.
D.Create an external table and leave the data in the flat file

A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.