You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code:
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
(’SCOTT’, ’GRP1’, FALSE);
How will you grant the switch privilege to the user, Scott?()
A. by using the DBMS_SESSION package
B. by granting the DBA role
C. by using the DBMS_RESOURCE_MANAGER package
D. by using the DBMS_RESOURCE_MANAGER_PRIVS package
您可能感兴趣的试卷
你可能感兴趣的试题
You issue the following code:
EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP
(’SCOTT’ ’GRP1’, TRUE);
What will be the result of executing the above code?()
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.
You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:
SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE (PLAN => ’DSS_PLAN’,
GROUP_OR_SUBPLAN => ’DSS_USERS’,
NEW_CPU_P1 => 80,
NEW_SWITCH_GROUP => ’CANCEL_SQL’,
NEW_SWITCH_ESTIMATE => TRUE,
NEW_SWITCH_TIME => 600);
A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()
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.
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 performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()
You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace. What methods can you use to recreate the indexes?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
In which case would you use the Flashback Database feature to perform a recovery?()
The loss of the control file forced you to recreate the control file. After recreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a fivedigit number starting with 0. What could be the possible reason?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
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? ()