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 AI Database 26ai? (Select all that apply)
Please select all the correct answers.
  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.

4. Since every Oracle AI Database 26ai database is a multitenant container database, which additional question should be part of your pre-creation checklist that would not have mattered in a non-CDB architecture?
Please select the best answer.
  A. Which storage vendor manufactures the underlying disks
  B. Which container the account should belong to: a specific PDB as a local user, or the CDB root as a common user
  C. Which version of SQL*Plus the user will connect with
  D. How many CPU cores the host server has available

5. Which of the following are valid authentication options for a new user, beyond a local password? Select all that apply.
Please select all the correct answers.
  A. IDENTIFIED EXTERNALLY, delegating authentication to the operating system
  B. NO AUTHENTICATION, for a schema-only account that can never log in interactively
  C. IDENTIFIED BY BLANK, creating an account with an intentionally empty password
  D. Authentication against a cloud identity provider such as Microsoft Entra ID or OCI IAM