单项选择题X 纠错
A. The switch privilege will be granted to the user, Scott, for changing the consumer group to GRP1.
B. The switch privilege will be granted to the user, Scott, for changing the consumer group from GRP1 to any other group.
C. The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
D.The code will execute successfully but no privilege will be granted to the user, Scott.
你可能喜欢
单项选择题
A. The session is killed before starting the operation.
B. The session generates an error before starting the operation.
C. The session switches to the CANCEL_SQL resource consumer group before starting the operation.
D. The session hangs before starting the operation.
单项选择题
A. The statement will deactivate DAY_PLAN.
B. The statement will activate DAY_PLAN as the top plan.
C. The statement will activate MANAGERS_PLAN as the top plan.
D. The statement will return an error because MANAGERS_PLAN is not the top plan.
单项选择题
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.
单项选择题
A. The CPU cannot be assigned to the members of the SYS_GROUP group.
B. The members of the OTHER_GROUPS group will always be assigned 100 percent CPU.
C. The members of the OTHER_GROUPS group will never be assigned 100 percent CPU.
D. The members of the OTHER_GROUPS group will be assigned 100 percent CPU if the CPU is not assigned to the members of the SYS_GROUP group and the PAYROLL, SALES, and MARKETING groups.
单项选择题
A. the value of the NLS_LANGUAGE variable
B. the value of the NLS_TERRITORY variable
C. the value of the NLS_CURRENCY variable
D.the character encoding scheme used by the client application
单项选择题
A. The statement will be executed successfully, and a new time zone will be set for the database.
B. The statement will be executed successfully, but a new time zone will not be set for the database.
C. The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
D. The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
单项选择题
A. by using the RMAN utility
B. by using the export/import utility
C. by using the ALTER DATABASE command
D. by enabling the change tracking feature
单项选择题
A. B-tree Index
B. Bitmap Index
C. Function-based Index
D. Partitioned Index
单项选择题
A. The operating system local time zone will be set for a user session using the operating system environment variable.
B. The database local time zone will be set for a user session using the operating system environment variable.
C. The operating system local time zone will be set for the database using the operating system environment
D. The database local time zone will be set for the database using the operating system environment variable.
单项选择题
A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10:00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’