Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement： SQLALTER TABLSPACE temp OFFLINE NORMAL； What is the result of this statement？（）A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.
Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement： SQL>ALTER TABLSPACE temp OFFLINE NORMAL； What is the result of this statement？（）
- A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
- B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
- C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
- D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.
相关考题：
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A、Only the SET command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
You have written a custom menu for a Forms application. You saved the menu module to the file custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu. When you run the form, the custom menu does not appear. What can you do to fix this problem?（）A、Generate the menu module executable. B、Save the menu module as custmenu.mmx. C、In the Property Sheet for the form, set the Starting Menu property to custmenu. D、In the Property Sheet for the form, set the Menu Module property to custmenu.mmb.
Given below is a list of scenarios： 1）A user terminates his session abnormally. 2）The connection between the server and the client application terminates because of a network failure. 3）A schema is accidentally dropped. 4）The tablespace is accidentally dropped from the database. 5）The hard disk gets corrupted and the data files in the disk are lost. 6）The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery（）A、4 and 5B、1，3，and 6C、4，5，and 6D、3，4，and 5E、1，2，and 6
Which option best describes the features of the Personal Worklist page, as compared with AdvancedWorklist?（）A、provides an overview of notificationsB、provides the capability to administer notificationsC、provides the most detailed options for searching workflowD、provides the most detailed options for searching workflow, and provides the capability to administer notifications
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）A、All the objects of scott are moved to the Recycle Bin.B、Any objects in the Recycle Bin belonging to scott are purged.C、All the objects owned by scott are permanently dropped from the database.D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure？（） A、 only encryption and compression settings for all SecureFile LOBsB、 only encryption and deduplication settings for only SecureFile CLOBsC、 deduplication，encryption，and compression settings for all SecureFile LOBsD、 deduplication，encryption，and compression settings only for SecureFile CLOBs