网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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;


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 managerB GRANT select, insert, update ON student_grades TO ROLE managerC 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;” 相关考题
考题 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.

考题 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.

考题 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.

考题 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

考题 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.

考题 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***

考题 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.

考题 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.

考题 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

考题 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. 

考题 .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.

考题 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. 

考题 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 RolesB、Net UsersC、AuthenticationD、IIS Manager Permissions

考题 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.

考题 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.

考题 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.

考题 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.

考题 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;

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

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

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

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

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

考题 单选题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 managerB GRANT select, insert, update ON student_grades TO ROLE managerC 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;

考题 多选题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?()AFrom Credential Manager, select Back up vault.BFrom User Accounts, select Create a password reset disk.CFrom User Accounts, select Manage your file encryption certificates.DFrom Authorization Manager, modify the Authorization Manager options.

考题 单选题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 itB Execute appcmd command on the command prompt on the serverC Open the IIS Manager Console and select the website. Select Add ApplicationD Execute appcmd -t on the command prompt on the server

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

考题 多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.