单选题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， - 搜考题

违法和不良信息举报联系客服

免费注册登录

题目

单选题

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

参考答案：C

第2题：

You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

A、by using the ANALYZE utility
B、by using the DBVERIFY utility
C、by using the DB_BLOCK_CHECKING parameter
D、by using the DBMS_REPAIR package

正确答案:D

第3题：

You want to enable users of a Web application to modify the Web application‘s UI and behavior. These modifications must be maintained at the user level so that when users return to the Web application, the changes are still in effect. You need to achieve this goal by using the minimum amount of custom code.What should you do?（）

A. Persist control data by using view state.

B. Use Web Part controls.

C. Maintain a profile for each user.

D. Enable session state on the Web application.

参考答案：B

第4题：

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.

正确答案:A

第5题：

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A、 You must enable the block change tracking feature.
B、 You must have enable the flashback feature.
C、 You must use the OMF in your database.
D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

正确答案:D

第6题：

You want to log into the router and make a configuration change.After loggin in as the root user, what is the next command you must enter?()

A. enable

B. configure

C. edit

D. cli

参考答案：D

第7题：

A user in your company has a laptop， which he uses both， on and off the network. You want to change the users profile to roaming but when you attempt to change the setting， the Roaming profile option is grayed out. How can you change the laptop users profile to roaming？（）

A、In Control Panel， System， User Profiles Tab， change profile to roaming.
B、Have him log back into the network.
C、Change the Profile to a Mandatory User Profile.
D、Change the profile to a Mandatory Roaming Profile.

正确答案:B

第8题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT any transaction TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

参考答案：B, C, D, F

第9题：

You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）

A、 the system change number
B、 the locations of the redo log files
C、 the locations of the datafiles
D、 the physical location of all the database changes

正确答案:D

第10题：

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

A、 The batch operation started by the user， SCOTT， terminates with an error.
B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

正确答案:A,D

更多相关问题

相关内容