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

违法和不良信息举报联系客服

免费注册登录

题目

单选题

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

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

相似问题和答案

第1题：

下列的SQL语句中，（）不是数据定义语句。

A. CREATE TABLE B. DROP VIEW

C. CREATE VIEW D. GRANT

正确答案：

第2题：

You want to create a role to meet these requirements： 1：The role is to be protected from unauthorized usage. 2：The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles（）

A、Create the role with global authentication.
B、Create the role with external authentication.
C、Create the role as a secure application role.
D、Create the role as a password-protected role.
E、Create a role and use Fine-Grained Access Control （FGAC） to secure the role.

正确答案:C

第3题：

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

参考答案：A

第4题：

You want to create a role to meet these requirements： 1. The role is to be protected from unauthorized usage. 2. The password of the role is not to be embedded in the application source code or stored in a table. method would you use to restrict enabling of such roles（）

A、Create the role with external authentication.
B、Create the role as a secure application role.
C、Create the role as a password-protected role.
D、Create a role and use Fine-Grained Access Control （FGAC） to secure the role

正确答案:B

第5题：

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

第6题：

下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）

A、GRANT INSERT ON emp TO acctsuper
B、GRANT CREATE TABLE TO acctsuper
C、GRANT SELECT ON emp TO acctsuper
D、GRANT UPDATE ANY TABLE TO acctsuper
E、GRANT CREATE SESSION TO acctsuper

正确答案:B,D,E

第7题：

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

第8题：

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.

参考答案：B, E

第9题：

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

第10题：

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）； This command errorsout displaying the following message： ERROR at line 1： ORA-01031： insufficient privileges ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）

A、 grant SYSDBA to the user
B、 grant SYSOPER to the user
C、 grant the RESOURCE role to the user
D、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

正确答案:E

更多相关问题

相关内容