Multiple choice

Five roles were created using the statements shown:

CREATE ROLE payMANAGER;

CREATE ROLE oeclerk IDENTIFIED BY salary;

CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;

CREATE ROLE genuser IDENTIFIED GLOBALLY;

CREATE ROLE dev IDENTIFIED USING dev_test;

Whichof the following statements indicates that a user must be authorized to use the role by the enterprise directory service before the role is enabled?

  1. CREATE ROLE payclerk;

  2. CREATE ROLE genuser IDENTIFIED GLOBALLY;

  3. CREATE ROLE oeclerk IDENTIFIED BY salary;

  4. CREATE ROLE dev IDENTIFIED USING dev_test;

  5. CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

IDENTIFIED GLOBALLY means the role is authorized by the enterprise directory service (like Oracle Internet Directory) before it can be enabled. The user must be authenticated and authorized by the directory service, not just the database password.

Keep practicing — related questions