Exam Prep Questions

1:What information would you expect to find by querying the SESSION_ROLE view?

  • A. All the sessions in the database with their default roles

  • B. All roles granted to a session

  • C. Roles enabled for current user

  • D. All the roles currently active in the database

A1: Answer C is correct; in this view, you find all the roles enabled for the currently logged-in user. Answer A is incorrect; no single view shows all the sessions in the database and their default roles. Answer B in incorrect; roles aren't granted to sessions. Answer D is incorrect; there is no single view that tells you all the roles active in the database.
2:Which statements are true about a role? [select all that apply]

  • A. It is owned by DBA.

  • B. It is owned by the user ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial