单选题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

题目
单选题
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 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.

2.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.

3. 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 ArrayD、From the Online Responder Management Console， select the new Online Responder， and then select Synchronize

4. 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
解析： 暂无解析
更多“You need to give the MANAGER role the ability to select from”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    .Your companys virtual environment includes Windows Server 2008 R2 Hyper-V servers. You manage the environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You need to provide a user with the ability to perform only the Create， Delete， Start， Stop， Pause， Resume， and Shut Down virtual machine （VM） management tasks on your host servers .  What should you do？（）

    • A、In VMM，create a Self-Service user role.
    • B、In VMM，create a Delegated Administrator user role.
    • C、In VMM，assign the Local Administrator permission for the host servers to the user.
    • D、In Authorization Manager， create a role on the users client computer and add the user to this role.

    正确答案:A

  • 第5题：

    You have a server that runs Windows Server 2008. The server has the Web Server （IIS） server role installed and all the Web Server role services installed.  You need to provide a user the ability to administer a Web site. Which feature should you configure？（）

    • A、Net Roles
    • B、Net Users
    • C、Authentication
    • D、IIS Manager Permissions

    正确答案:D

  • 第6题：

    You have a Virtual Hard Disk (VHD) and a computer that runs Windows 7. The VHD has Windows 7installed. You need to start the computer from the VHD.  What should you do?（）

    • A、From Diskpart.exe， run Select vdisk.
    • B、From Disk Management， modify the active partition.
    • C、Run Bootcfg.exe and specify the /default parameter.
    • D、Run Bcdedit.exe and modify the Windows Boot Manager settings.

    正确答案:D

  • 第7题：

    You have a computer that runs Windows 7. The computer is in a workgroup. You need to ensure that youcan decrypt Encrypting File System (EFS) files on the computer if you forget your password.  What are two possible ways to achieve this goal?（）

    • A、From Credential Manager， select Back up vault.
    • B、From User Accounts， select Create a password reset disk.
    • C、From User Accounts， select Manage your file encryption certificates.
    • D、From Authorization Manager， modify the Authorization Manager options.

    正确答案:B,C

  • 第8题：

    单选题
    You need to ensure that the new sales manager is able to view clients within only the North and South regions. What should you do?（）
    A

    Add a Denied member set for the West clients to NorthRole.

    B

    Add an Allowed member set for the South clients to NorthRole.

    C

    Create a new role for the sales manager and add a Denied member set for the South clients.

    D

    Create a new role for the sales manager and add an Allowed member set for the South clients. Remove the sales manager from SouthAndWestRole.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You have a computer that runs Windows XP Professional. You download new video card driver from the Internet, and then install the driver. You restart the computer. You discover that the newly loaded video driver is named VgaSave.  You need to restore the previous version of the video card driver.What should you do?（）
    A

    From the Device Manger, scan for hardware changes. 

    B

    From the Device Manager, access the video card properties, and then select Roll Back. 

    C

    From the Device Manager, access the VgaSave properties, and then run the Hardware Troubleshooter. 

    D

    Restart the computer. From the Advanced Startup Options menu, select Last Known Good Configuration. 


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You grant a user the Delegated Administrator user role. You need to provide the user with the ability to manage VMs through the VMM Self-Service Portal. What should you do？（）
    A

    In VMM， grant the user the Self-Service user role.

    B

    In VMM， grant the user the Administrator user role.

    C

    Enable the Integrated Windows Authentication option for the VMM Self-Service Portal.

    D

    Enable the Single sign-on for Terminal Services option for the VMM Self-Service Portal.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    You have a computer that runs Windows 7. The computer is in a workgroup. You need to ensure that youcan decrypt Encrypting File System (EFS) files on the computer if you forget your password.  What are two possible ways to achieve this goal?（）
    A

    From Credential Manager， select Back up vault.

    B

    From User Accounts， select Create a password reset disk.

    C

    From User Accounts， select Manage your file encryption certificates.

    D

    From Authorization Manager， modify the Authorization Manager options.


    正确答案： A,B
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You have a computer that runs Windows XP Professional. You download new video card driver from the Internet, and then install the driver. You restart the computer. You discover that the newly loaded video driver is named VgaSave.  You need to restore the previous version of the video card driver.What should you do?（） 

    • A、From the Device Manger, scan for hardware changes. 
    • B、From the Device Manager, access the video card properties, and then select Roll Back. 
    • C、From the Device Manager, access the VgaSave properties, and then run the Hardware Troubleshooter. 
    • D、Restart the computer. From the Advanced Startup Options menu, select Last Known Good Configuration. 

    正确答案:B

  • 第17题：

    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 Controller.
    • D、From the Online Responder Management Console， select the new Online Responder， and then select  Synchronize Members with Array Controller.

    正确答案:C

  • 第18题：

    You need to ensure that when you insert a blank DVD into the DVD drive, Windows Explorer opensautomatically and enables you to select files to burn to DVD.  What should you do?（）

    • A、From Default Programs， modify the AutoPlay settings.
    • B、From Default Programs， modify the default program settings.
    • C、From Device Manager， modify the properties of the DVD drive.
    • D、From System Configuration Utility， modify the Startup settings.

    正确答案:A

  • 第19题：

    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;

    正确答案:D

  • 第20题：

    单选题
    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***


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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;


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    As an administrator at Cer-tech .com， you install Web server （IIS） role on a server that runs WindowsServer 2008. You created a new site called Cer-tech .com. You need to install an application on thewebsite called web content. You copy the application to the server. What should you do to add theapplication on the website？（）
    A

    Create a virtual directory and copy the website contents in it. Copy the application in the directory andinstall it

    B

    Execute appcmd command on the command prompt on the server

    C

    Open the IIS Manager Console and select the website. Select Add Application

    D

    Execute appcmd -t on the command prompt on the server


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    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,F
    解析： 暂无解析

相关内容