Creating Users   «Prev  Next»

Steps for Creating Oracle User - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following should you decide on before creating a user? Select all that apply.
Please select all the correct answers.
  A. A default tablespace for the user
  B. A default datafile for the user
  C. A temporary table for the user
  D. A temporary tablespace for the user

2. Which of the following commands are valid for managing users?
Please select all the correct answers.
  A. DELETE USER
  B. CREATE USER
  C. MODIFY USER
  D. ALTER USER


3. Which of the following statements are true regarding the `CREATE USER` command in Oracle 19c? (Select all that apply)
Please select the best answer.
  A. The command allows you to specify a default tablespace for the new user.
  B. The `IDENTIFIED BY` clause is optional when creating a new user.
  C. The command can be used to grant system privileges to the new user.
  D. Quotas can be set on tablespaces for the user within the `CREATE USER` command.