User Profiles  «Prev  Next»

Wildcards Profile[SQL] - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which characters are wildcards when used with the Oracle SQL LIKE condition?
Please select all the correct answers.
  A. _
  B. *
  C. %
  D. #

2. Which approach should authorize BRIAN to insert rows into APP_OWNER.ORDERS from approved database clients?
Please select the best answer.
  A. Add a wildcard row to the SQL*Plus Product User Profile.
  B. Start SQL*Plus with -RESTRICT 1.
  C. Grant the required object privilege to a role, and grant that role to BRIAN.
  D. Add BRIAN to the login.sql file.

3. Which SQL*Plus commands are disabled at restriction level 2?
Please select all the correct answers.
  A. HOST
  B. SPOOL
  C. START
  D. GET

4. Which data dictionary view lists the roles that are currently enabled for the user in the current session?
Please select the best answer.
  A. USER_ROLE_PRIVS
  B. SESSION_ROLES
  C. ROLE_TAB_PRIVS
  D. DBA_SYS_PRIVS

5. What does the Oracle AI Database 26ai view DBA_SYS_PRIVS_ALL report?
Please select the best answer.
  A. Only object privileges granted directly to the current user.
  B. Only roles enabled in the current session.
  C. System and schema privileges granted to users and roles.
  D. SQL*Plus commands disabled by -RESTRICT.