1Z0-497 practice question 22 of 25

Which command do you use to create a local role while you are connected as the local user?

Full set: 150 questions

Answer options

A: create local role l_hr;

B: create role c##_hr container=current;

C: create role l_hr container=current; Correct answer

D: create role l_hr container=all;

Correct Answer:

C. create role l_hr container=current;

Explanation

You can include CONTAINER=CURRENT in the CREATE ROLE statement to specify the role as a local role.
Reference: Oracle Database Security Guide , Creating a Local Role

Keep practicing

Take the free 1Z0-497 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test