You created a user, USER01, and granted it two roles, APPLROLE and HRROLE. Next you execute the following command to set the default role for the user: SQL> ALTER USER user01 DEFAULT ROLE NONE; Which three statements are true in this scenario? (Choose three.)
The user can use the roles but cannot grant them to another user.
The user will be prompted to set the default role while logging in.
The user will not be able to use the privileges that exist in the APPLROLE and HRROLE roles until the user enables the roles.
The user can use the privileges that are granted to it directly.
The user can set its default role explicitly after connecting to the database.
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?