单项选择题
A. All the datafiles should be listed in the CREATE CONTROLFILE statement.
B. The DATA2.dbf and DATA3.dbf datafiles should be listed in the CREATE CONTROLFILE statement.
C. The SYSTEM01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
D. The SYSAUX01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
单项选择题 YourdatabaseisinARCHIVELOGmode.Youlostanindextablespaceduetoadiskfailurewhilethedatabasewasopen.YouhaveneitherabackupofthelostindextablespacenorthescriptscontainingtheCREATEINDEXstatementstorecreatetheindexes.Currently,severalusersareexecutinglong-runningqueriesonthedatabase.Whatwillhappentotheongoingactivityinthedatabase?()
单项选择题 YouaremaintainingyourdatabaseinOracle10g.YoufindthattheINDEXESindextablespaceshouldberecovered.Howwillyourecovertheindextablespace?()
单项选择题 You have created a password file using the following command: ORAPWD file=d:\oracle\ora9i\orapwU01 password=change_on_install entries=3 Which of the following is true about this password file?()