Question:Evaluate the following SQL:
CREATE USER sam IDENTIFIED BY sam;
GRANT
CREATE ANY MATERIALIZED VIEW,
CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE
TO dw_manager
WITH ADMIN OPTION;
GRANT dw_manager TO sam WITH ADMIN OPTION;
Which three actions among the following is the user SAM able to perform? 

A Select from a table 
B Create and drop a materialized view 
C Alter a materialized view that was created 
D Grant and revoke the role to and from other users 
E Enable the role and exercise any privileges in the role's privilege domain 

+ Answer
B D E 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description