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

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

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

3.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;

4.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 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 G”相关问题

  • 第1题：

    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

  • 第2题：

    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, user3
    • B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
    • C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
    • D、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;

    正确答案:D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

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


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

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

    B

    CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    C

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

    D

    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;


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

  • 第10题：

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


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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    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.

    正确答案:D

  • 第17题：

    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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

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


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

  • 第20题：

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

    B

    CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    C

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

    D

    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;


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

  • 第21题：

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


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

  • 第22题：

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

  • 第23题：

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


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

  • 第24题：

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


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

相关内容