单项选择题
Examine the command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
What does the command accomplish?()
A.Creates an additional copy of the database online redo log files.
B.Stores the primary key column values of each row involved in a DML operation in the online redo log files.
C.Stores the primary key column values of each row involved in a DML operation in the supplemental log files.
D.Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.
相关考题
-
单项选择题
Howcanyoumakeasharedserver-sideinitializationparameterfileavailabletoallinstancesofaRealApplicationClustersdatabase?()
A.Include an SPFILE parameter in each instance-specified initialization file.
B.Create an SPFILE copy on each client from which the instance will be started.
C.Store the SPFILE in a raw partition with a vendor-specifies location and name.
D.Use a single client to start the instances and create the SPFILE on this client. -
多项选择题
AutomaticConsumerGroupSwitchingisanimportantnewfeatureoftheDatabaseResourceManager.Whichthreeplandirectiveparametersareusedtocontrolthisfeature?()
A.SWITCH_TIME
B.SWITCH_GROUP
C.MAX_SESS_POOL
D.SWITCH_ESTIMATE -
单项选择题
You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change?()
A.A
B.B
C.C
D.D
