Creating Users   «Prev  Next»

User Management - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. You want to remove a user from your database and you are certain that the user owns no data. Which command should you use?
Please select the best answer.
  A. DROP USER username CASCADE
  B. DELETE username FROM DATABASE
  C. DROP USER username
  D. DELETE USER username

2. One of your fellow employees is taking a 3-month leave of absence. What is the best way to secure his account while he is gone?
Please select the best answer.
  A. Change his password to something only you know
  B. Lock his account
  C. Revoke his CREATE SESSION privilege
  D. Drop the user from the database

3. Which of the following commands will change Harold's password to WINDY_CITY?
Please select the best answer.
  A. ALTER USER HAROLD PASSWORD WINDY_CITY
  B. ALTER USER HAROLD IDENTIFIED BY WINDY_CITY
  C. ALTER USER HAROLD IDENTIFIED BY VALUES 'WINDY_CITY'
  D. ALTER USER HAROLD IDENTIFIED BY PASSWORD 'WINDY_CITY'

4. You want to reset a user's password, but you do not want to know it yourself. What is the best way to handle this situation?
Please select the best answer.
  A. Give the user the SYSTEM password, so he or she can reset the personal password without you looking
  B. Log the user into your terminal as SYSTEM, and walk away so he or she can change the password
  C. Change the user's password yourself, but pre-expire it so the user is forced to change it again
  D. Type in a random series of characters without looking , so that even you won't know the result