You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement: SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => ’SALES_PLAN’, GROUP_OR_SUBPLAN => ’MANAGERS’, CPU_P1 => 100, CPU_P2 =>0, SWITCH_GROUP => ’CLERKS’, SWITCH_TIME_IN_CALL => 600); A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()
A、 The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.
B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
D、 The query starts under the MANAGERS group, the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes, and then switches back to the MANAGERS group after the query completes.
相关问题推荐
-
In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()
AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.
BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.
CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
-
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
A、REBUILD
B、CASCADE
C、TRUNCATE
D、ROW MOVEMENT
E、SHRINK SPACE COMPACT
F、SHRINK SPACE CASCADE
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
AThe DBWn process writes to the datafile.
BChanges in the background process are recorded.
CThe log file is updated with the current SCN number.
DThe System Change Number (SCN) is recorded in the control file.
EThe changes to the listener configuration in the listener.ora file are recorded.
-
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
ASYSDATE should not be used with TIMESTAMP.
BThe database must have multiplexed redo log files.
CThe database must be in the MOUNT state to execute the command.
DThe database must be opened with the RESETLOGS option after the flashback operation.
EThe entire database needs to be restored from the most recent backup before the flashback operation.
-
You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use?()
A、 FILE
B、 PARFILE
C、 LOGFILE
D、 FEEDBACK