The Database Resource&#819...

单项选择题X 纠错

The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement： SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’； What will be the outcome of this statement？（）

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.

参考答案：

进入题库练习

单项选择题

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.

点击查看答案进入题库练习

单项选择题

Click the Exhibit（s） button to view the DEPARTMENTS plan.

After analyzing the Exhibit， what conclusion will you draw？（）

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.

点击查看答案进入题库练习

单项选择题

You issued the following statement：
SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1；
Which parameter is NOT overridden by using the above statement？（）

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

点击查看答案进入题库练习

单项选择题

Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：
SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；
What will be the result of issuing the above statement？（）

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.

点击查看答案进入题库练习

单项选择题

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.
How will you migrate your database from UTF8 to AL16UTF16？（）

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

点击查看答案进入题库练习

单项选择题

Click the Exhibit（s） button to view the EMPLOYEES table.

The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month， you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create？（）

A. B-tree Index
B. Bitmap Index
C. Function-based Index
D. Partitioned Index

点击查看答案进入题库练习

单项选择题

You issued the following command at the UNIX environment：
% setenv ORA_SDTZ ’OZ_TZ’
What will be the impact of issuing the above command？（）

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.

点击查看答案进入题库练习

单项选择题

You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue？（）

A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10：00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’

点击查看答案进入题库练习

单项选择题

You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）

A. FRENCH_AI
B. FRENCH_CI
C. AI_FRENCH
D. CI_FRENCH

点击查看答案进入题库练习

单项选择题

You created the ORDERS table in your database by using the following code：
SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；
Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；
SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；
SQL> COMMIT；
Next， you issued the following statement to change the time zone for the database：
SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；
What will be the result of executing the above statement？（）

A. The statement will fail.
B. The statement will be executed successfully， and the new time zone will be set for the database.
C. The statement will be executed successfully， but the new time zone will be set for the current session.
D.The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

点击查看答案进入题库练习