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? （） -题库考试答案搜索网

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? （）

单选题

2022-02-21 19:17

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

查看答案

正确答案

试题解析

标签： CMS专题 Oracle认证考试 1Z0-007

感兴趣题目

As a visitor or guest in either a Chinese home or restaurant you will find that（）manners are important to the enjoyment of your meals and keep you in high spirits!

Owners are to be responsible for loss of or damage to the goods or delay in delivery of the goods only in case the loss，damage or delay has been caused by the improper or negligent stowage of the goods．This means that（）.

You intend to discharge medical or hazardous wastes ashore MARPOL annex V requires you to notify a receiving port or terminal in advance.How much advance notice require?（）

Max: You should go to pubs, or join a club.

Duty is an act or a course of action that people __________you to take by social customs, law or religion.

Duty is an act or a course of action that people ______you to take by social customs, law or religion.

If necessary to avoid collision or allow more time to（）the situation，a vessel shall slacken her speed or take all way off by stopping or reversing her means of propulsion．

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

Effects which are dutiable or subject to prohibitions or restrictions should be declared in （）.

（）are liable to be stoten, pilfered or may damaged due to improper handing or stowage.

During counterflooding to correct a severe list or trim aggravated by an off-center load，a ship suddenly takes a list or trim to the opposite side. You should（）.