单项选择题

A.A checkpoint defines the highest system change number……

Which statement is true regarding checkpoints and recovery？（）

A.A checkpoint defines the highest system change number （SCN）.
B.All redo entries higher or at the SCN are known to be written to the data files.
C.Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
D.The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.

<上一题目录下一题>

热门试题

单项选择题Inuser-managedbackupandrecoverprocedures，howaredatafilesbackedup？（）

A.Using SQL commands.
B.Using SQL*Plus commands.
C.Using operating system commands.
D.Using Recover Manager commands.

单项选择题ToincreasetheavailabilityofanAdvancedReplicationenvironment，youcanaddanewmastertoareplicationgroupwithoutquiescingthegroup.Thisisachieved（）.

A.Only when the new master site already has existing replication groups.
B.By issuing a single command to create, populate, and activate the new master.
C.When the master definition site is not the same for all of the master groups.
D.Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.

多项选择题WhichfouraretrueregardingtheWorkspaceManagerinOracle9i？（）

A.Automatically versions all tables.
B.Automatically installed with Oracle9i.
C.Merges changes with parent rows or discard changes.
D.Provides mechanism to identify and resolve conflicts.
E.Allows for version enabling tables by use of a packages procedure.

单项选择题Examine the following parameter settings from an initialization （init.ora） file： DB_CREATE_FILE_DEST =’ u01 oradata ’ DB_CREATE_ONLINE_LOG_DEST_1 =’ u02 oradata ’ DB_CREATE_ONLINE_LOG_DEST_2 =’ u03 oradata ’ If you create an Oracle Managed Files （OMF） database using these settings， what is the result？（）

A.A
B.B
C.C
D.D

单项选择题Oracle9iofferstheabilitytomonitorthedynamicuseoftheSGAthroughtheDB_CACHE_ADVICEparameter.WhenthisparameterissettoREADY，whatisitseffect？（）

A.The Advisory is on and will capture both CPU and memory overhead.
B.The Advisory is on but the memory for the Advisory is not allocated.
C.The Advisory is off and the memory for the Advisory is not allocated.
D.The Advisory is off but the memory for the Advisory remains allocated.