User Profiles  «Prev  Next»

Product Profiles - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Before it was desupported, what could the SQL*Plus Product User Profile control?
Please select all the correct answers.
  A. Whether a database user could start the SQL*Plus executable.
  B. The availability of selected commands for specified users within SQL*Plus.
  C. Which granted roles were initially enabled for specified users in SQL*Plus.
  D. The database privileges granted on tables, views, and other schema objects.

2. In a historical PUP row that disabled a command, which literal values normally remained fixed?
Please select all the correct answers.
  A. SQL*Plus in the product field
  B. The target username in the user field
  C. The command name in the attribute field
  D. DISABLED in the character-value field

3. Historically, what happened if a PUP row attempted to disable a role that had not been granted to the user?
Please select the best answer.
  A. The role was automatically granted but remained disabled.
  B. Only the ungranted role was added to the initial role set.
  C. Every role granted to the user was disabled.
  D. None of the roles granted to that user were disabled by the attempted restriction.