单项选择题
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）
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？（）
A. by using the Flashback Database feature
B. by using RMAN incomplete recovery
C. by performing a user-managed incomplete recovery
D. by dropping and re-creating the index tablespace -
单项选择题
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？（）
A. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
B. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
C. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
D. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available. -
单项选择题
AdamisworkingasaDatabaseAdministrator（DBA）forTeleSoftCorporation.HisdatabaseisrunningintheARCHIVELOGmode.Duringdatabasestartup，hediscoversthatoneofthediskscrashed，resultinginthepermanentlossofaread-writeUSERStablespace.TheUSERS01.dbfdatafilebelongstotheUSERStablespaceandis500MBinsize.HeneedstorecovertheUSERStablespacefromthebackup.Whilereviewingthebackupdetails，hediscoversthatthemostrecentavailablebackupisfivedaysold.ThisbackupwastakenwhentheUSERStablespacewasread-only.Aftercorrectingthehardwareproblemthatcausedthefailure，whatshouldAdamdotorecovertheUSERStablespace？（）
A. Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
B. Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
C. Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
D. Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
