Multiple Choice
Which of the following SQL statements will create a new role named PRCLERK?
A) CREATE prclerk;
B) CREATE ROLE prclerk;
C) CREATE ROLE prclerk ON payroll;
D) CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE;
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q84: <u>Object </u>privileges allow users to execute DDL
Q85: Even if a password has been assigned,a
Q86: The ON clause of the GRANT command
Q87: Which of the following commands will allow
Q89: Revoking a privilege originally granted with the
Q90: A privilege with the ANY keyword is
Q91: The WITH _ OPTION is required to
Q92: Which of the following clauses is required
Q93: Which of the following SQL statements will
Q122: System and object privileges can be taken