You need to give the MANAGER role the ability to select from

题目
单选题
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? ()
A

GRANT select, insert, update ON student_grades TO manager

B

GRANT select, insert, update ON student_grades TO ROLE manager

C

GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;

D

GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;

E

GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  

F

GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

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

第1题:

You have a computer that runs Windows 7. You manually create a system restore point. You need torestore a copy of a file stored on drive C from two days ago. You must achieve this goal in the minimumamount of time. What should you do?()

  • A、From Recovery, select System Restore.
  • B、From Backup and Restore, select Restore my files.
  • C、From the command prompt, run Wbadmin get items.
  • D、From the properties of the file, select Previous Versions.

正确答案:A

第2题:

You need to share a financial spreadsheet with other employees of your company. The material is of a sensitive nature and you want to prevent the ability of users to use offline caching. How do you do this?()

  • A、Assign Special Permissions.
  • B、Select Shared folder properties, caching, deselect “Allow Caching”.
  • C、Select Manual Caching for Documents.
  • D、Select Manual Caching for Programs.

正确答案:B

第3题:

You are the network administrator for your company. The network consists of a single Active Directory domain named All network servers run Windows Server 2003.Terminal Server is installed on a member server named Server1, which is located in an organization unit (OU) named Servers. User of Server1 report unacceptable response times.To investigate, you start Task Manager on Server1. You discover that the average CPU usage is 80 percent. However, when you select the Processes tab, none of the processes show significant CPU usage.You need to identify the process that is responsible for the CPU usage.What should you do?()

A. In Task Manager, select the Show processes from all users option.

B. From a command prompt, run the query process command.

C. Open the Terminal Services Manager. Select Server1 from the list of servers, and then select the Processes tab.

D. Edit the Group policy object (GPO) for the Servers OU by adding your user account to the Profile a single process policy. Then use Task Manager to re-examine Server1.


参考答案:A

第4题:

You have a computer named Computer1 that runs Windows 7. The computer is a member of an ActiveDirectory domain. The network contains a file server named Server1 that runs Windows Server 2008. Youlog on to the computer by using an account named User1. You need to ensure that when you connect toServer1, you authenticate by using an account named Admin1.  What should you do on Computer1?()

  • A、From User Accounts, select Link online IDs.
  • B、From Windows CardSpace, select Add a card.
  • C、From Credential Manager, select Add a Windows credential.
  • D、From Local Security Policy, modify the Access this computer from the network user right

正确答案:C

第5题:

You have the Web Server (IIS) role installed on a server that runs Windows Server 2008. You create a Web site named contoso.com. You copy an application named WebContent to the server. You need to enable the WebContent application on the Web site. What should you do?()

  • A、At the command prompt on the server, run the appcmd add site command.
  • B、At the command prompt on the server, run the appcmd add vdir command.
  • C、Select the Web site from the Internet Information Services (IIS) Manager console. Select Add Application.
  • D、Select the Web site from the Internet Information Services (IIS) Manager console. Select Add Virtual Directory.

正确答案:C

第6题:

You add an Online Responder to an Online Responder Array. You need to ensure that the new  Online Responder resolves synchronization conflicts for all members of the Array.     What should you do()

  • A、From Network Load Balancing Manager, set the priority ID of the new Online Responder to 1.
  • B、From Network Load Balancing Manager, set the priority ID of the new Online Responder to 32.
  • C、From the Online Responder Management Console, select the new Online Responder, and then select Set as Array
  • D、From the Online Responder Management Console, select the new Online Responder, and then select Synchronize

正确答案:C

第7题:

You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?()

  • A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
  • B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
  • C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

正确答案:A

第8题:

Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()

  • A、MANAGER must be a role.
  • B、It allows the MANAGER to pass the specified privileges on to other users.
  • C、It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
  • D、It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
  • E、It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
  • F、It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

正确答案:B,E

第9题:

Your company has a server that runs Windows Server 2008. The server has the Web Server (IIS) role installed.  You need to activate SSL for the default Web site.  Which two actions should you perform?()

  • A、Obtain and import a server certificate by using the IIS Manager console.
  • B、Select the Generate Key option in the Machine Key dialog box for the default Web site.
  • C、Add bindings for the HTTPS protocol to the default Web site by using the IIS Manager console.
  • D、Install the Digest Authentication component for the Web server role by using the Server Manager console.

正确答案:A,C

第10题:

You have a computer that runs Windows XP Professional. The computer has an 802. 11g wireless network card. You have a wireless access point that is secured by using WiFi Protected Access (WPA). The service set identifier (SSID) of the wireless access point does not broadcast. You need to establish a wireless connection to the wireless access point. What should you do?() 

  • A、From the Device Manager, open the wireless network adapter properties and click Advanced. 
  • B、From the Device Manager, right-click the wireless network adapter and click Scan for hardware changes. 
  • C、From the Wireless Network Connection Properties, select View Wireless Networks. 
  • D、From the Wireless Network Connection Properties, click Change Advanced Settings. From the Wireless Networks tab, select Add a preferred network. 

正确答案:D

更多相关问题