Creating Users   «Prev  Next»

User Management Quiz

Each question is worth 1 point. Select the best answer for each question, then click Submit.
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 their account while they are gone?
Please select the best answer.
  A. Change the password to something only you know
  B. Lock the account
  C. Revoke the 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 they can change their password
  B. Log in as SYSTEM and walk away so the user can change the password
  C. Set a temporary password and expire it so the user must change it at next login
  D. Type random characters without looking, so even you won't know the result

Your Score: Submit the quiz to see your results.