RelationalDBDesignRelationalDBDesign


User Profiles  «Prev  Next»
 

Product Profiles - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. What effect does the product profile have on SQL*Plus?
Please select all the correct answers.
  A. It can limit access to SQL*Plus for certain users.
  B. It can limit access to specific commands for certain users.
  C. It can limit initial access to certain roles for certain users.
  D. It can grant SQL access to database structures for certain users.

2. Which of the following constants are always used when you are using an INSERT statement to limit access to a command in SQL*Plus?
Please select all the correct answers.
  A. SQL*Plus
  B. USERID
  C. COMMAND_NAME
  D. DISABLED

3. If you use the product profile to restrict a user’s access to a role that has not been granted to the user, what is the result?
Please select the best answer.
  A. The ungranted role will not be available to the user initially.
  B. No roles will be available to the user initially.
  C. No roles will be unavailable to the user initially.
  D. The product profile will have no effect with regard to roles.