单选题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?（）AGRANT select, insert, update ON student_grades TO managerBGRANT select, insert, update ON student_grades TO ROLE managerCGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT 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 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 perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich 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***
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH 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 run Runas and specify the /savecred parameter to start anapplication. You need to delete the stored password. What should you do?（）A、Run Del and specify the /p parameter.B、Run Runas and specify the /noprofile parameter.C、From Credential Manager， modify the Windows credentials.D、From Authorization Manager， modify the Authorization Manager options.
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
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 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 DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
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 manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. Developers are members of an AD security group named Development. You need to ensure that on a specific host server， members of the Development group can perform only the Create，Modify，and Remove VM management tasks. What should you do？（）A、Create a Self-Service user role and add the Development group to this role.B、Create a Delegated Administrator user role and add the Development group to this role.C、In Authorization Manager， create a role on the client computer of each member of the Development group， and add the Development group to this role.D、Install Hyper-V Manager on the client computer of each member of the Development group，and grant the Development group administrative privileges on the specific server.
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 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 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 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?（）AGRANT select, insert, update ON student_grades TO managerBGRANT select, insert, update ON student_grades TO ROLE managerCGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT 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?（）AGRANT select, insert, update ON student_grades TO manager;BGRANT select, insert, update ON student_grades TO ROLE manager;CGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
单选题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?（）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
单选题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?（）AFrom Default Programs， modify the AutoPlay settings.BFrom Default Programs， modify the default program settings.CFrom Device Manager， modify the properties of the DVD drive.DFrom System Configuration Utility， modify the Startup settings.
单选题You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）ACREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3BCREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3CCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3DCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;ECREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
单选题You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）ACREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3BCREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3CCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3DCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;ECREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
单选题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?（）AGRANT select, insert, update ON student_grades TO manager;BGRANT select, insert, update ON student_grades TO ROLE manager;CGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
单选题You manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. Developers are members of an AD security group named Development. You need to ensure that on a specific host server， members of the Development group can perform only the Create，Modify，and Remove VM management tasks. What should you do？（）ACreate a Self-Service user role and add the Development group to this role.BCreate a Delegated Administrator user role and add the Development group to this role.CIn Authorization Manager， create a role on the client computer of each member of the Development group， and add the Development group to this role.DInstall Hyper-V Manager on the client computer of each member of the Development group，and grant the Development group administrative privileges on the specific server.
多选题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.
单选题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? （）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
单选题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？（）ANet RolesBNet UsersCAuthenticationDIIS Manager Permissions
单选题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? （）AGRANT select, insert, update ON student_grades TO managerBGRANT select, insert, update ON student_grades TO ROLE managerCGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT 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?（）AAdd a Denied member set for the West clients to NorthRole.BAdd an Allowed member set for the South clients to NorthRole.CCreate a new role for the sales manager and add a Denied member set for the South clients.DCreate a new role for the sales manager and add an Allowed member set for the South clients. Remove the sales manager from SouthAndWestRole.