單項選擇題

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

你可能感興趣的試題

單項選擇題

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover 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？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover 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？（）