网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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 packageB by granting the DBA roleC by using the DBMS_RESOURCE_MANAGER packageD by using the DBMS_RESOURCE_MANAGER_PRIVS package” 相关考题
考题
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.
考题
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;
考题
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;
考题
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. enableB. configureC. editD. cli
考题
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 utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package
考题
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.
考题
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.
考题
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 numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
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 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.
考题
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)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;
考题
You are configuring a roaming user profile for a Scott Peters. You create a user account named ScottP on a Windows 2000 Server. You define a network profile directory path named //Server1/Profiles/%Username%. When Scott logs onto the computer， he receives the error message， "Windows cannot locate your roaming profile and is attempting to log you on with your local profile which will not be propagated to the server. The details of network cannot be found". What should you do？（）A、Change the %Username% variable to ScottP.B、Create a home folder for the Client computer.C、Map a device to network profile directory.D、Share the directory， which holds his profile.
考题
You manage a server that runs Windows Server 2008. You have installed the Windows SharePointServices （WSS） server role on the server. The server is configured to accept incoming mail. Tostreamline the process， you create a new document library. You have to make sure that any user can sendemail to the document library. What should you do to achieve this task？（）A、Change the incoming email settings for the document libraryB、Enable basic user authentication for the document libraryC、Modify the document library settings to accept emails from SMTP serversD、Change the permissions for the document library
考题
You need to configure the local security policy setting to request a user name and password when you make changes to the computer system. What should you do？（）A、Enable the Password must meet complexity requirements setting.B、Enable the User Account Control： Detect application installations and prompt for elevation setting.C、Configure the Interactive logon： Prompt user to change password before expiration setting to a value between 1 and 999.D、Configure the User Account Control： Behavior of the elevation prompt for administrators in Admin Approval mode setting to the Prompt for credentials option.
考题
You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. The Default Domain Policy GPO is configured to prompt users to change their password 14 days before it expires. A user who returns from a two-week vacation reportes that she cannot log on to the domain. You discover that when she last logged on, she was prompted to change her password. She reports that she did not change her password before leaving on vacation. You need to ensure that the user can log on to the domain. What should you do?（）A、Enable the user account.B、Reset the password for the user account.C、Use Active Directory Users and Computers to select the Password never expires option.D、Configure the Prompt user to change password before expiration security policy option to 21 days.
考题
单选题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.
考题
多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
考题
单选题You want to log in to the router and make a configuration change. After logging in as the root user, what is the next command you must enter?（）A
enableB
configureC
editD
cli
考题
单选题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 TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
单选题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 are the administrator of a Windows 2000 Professional portable computer that is shared by users in the sales department. You want to configure a roaming user profile for each user. You want each individual user profile setting to be available from any location, including by using a dial-up connection. You log on to the computer by using the local Administrator account. You create user accounts for the users in the sales department. When you attempt to configure each individual user account profile to be a roaming profile, you find that you cannot. You receive the change Profile Type dialog box as shown in the exhibit (Click the Exhibit button) You want to be able to configure each user account to use a roaming user profile. What should you do?（ ）A
From System in Control Panel, select the Change Type option, and then select the Roaming profile option. B
From Users and passwords in Control Panel, select the Advanced tab, and then define the path for the profile location. C
Use the Network Connection wizard to create a virtual private network (VPN) connection to the network, and define the mandatory profile path on each domain user account. D
Connect the portable computer to the network, and configure the user accounts for a roaming user profile.
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
单选题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.
考题
单选题You are attempting to connect to your ISP. You view the status change from Dialing to Verifying user name and password. After several seconds， the status changes to Disconnecting. You are then disconnected from the computer you dialed. You verify that your user name and password are entered correctly. You want to enable your Computer to connect to your ISP correctly. What should you do？ （）A
Configure your connection to enable data encryption.B
Configure your connection to use the UNIX SLIP server.C
Configure your connection to allow unsecured passwords.D
Instruct your ISP to configure your account to support Multilink.
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
考题
单选题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 utilityB
by using the DBVERIFY utilityC
by using the DB_BLOCK_CHECKING parameterD
by using the DBMS_REPAIR package
考题
单选题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 TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
热门标签
最新试卷