单项选择题
A. The queries that are currently executing will abort and an error message will be returned to the user.
B. The queries that are currently executing will execute normally but future queries will not executed.
C. Data Manipulation Language (DML) statements cannot be performed on the tables on which the indexes are based.
D. The currently executing and future queries will execute normally, but will be slower
单项选择题 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?()
单项选择题 AdamisworkingasaDatabaseAdministrator(DBA)forTeleSoftCorporation.HisdatabaseisrunningintheARCHIVELOGmode.Duringdatabasestartup,hediscoversthatoneofthediskscrashed,resultinginthepermanentlossofaread-writeUSERStablespace.TheUSERS01.dbfdatafilebelongstotheUSERStablespaceandis500MBinsize.HeneedstorecovertheUSERStablespacefromthebackup.Whilereviewingthebackupdetails,hediscoversthatthemostrecentavailablebackupisfivedaysold.ThisbackupwastakenwhentheUSERStablespacewasread-only.Aftercorrectingthehardwareproblemthatcausedthefailure,whatshouldAdamdotorecovertheUSERStablespace?()