Creating Users   «Prev  Next»

Creating Users in Oracle - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is the purpose of the IDENTIFIED BY clause of the CREATE USER command?
Please select the best answer.
  A. It allows you to record identifying marks for the user
  B. It is used to set the user's initial password
  C. It is used to specify the username of the new user
  D. It records your name as the user's creator

2. You want to allow a user up to 1 megabyte of data in the USERS tablespace. Which two QUOTA clauses could be used to do that?
Please select all the correct answers.
  A. QUOTA 1M ON USERS
  B. QUOTA ON USERS 1M
  C. QUOTA ON USERS 1024K
  D. QUOTA 1024K ON USERS

3. You are using Oracle Enterprise Manager (OEM) Cloud Control and have entered all the information for a new user in the Create User page. What must you do next to complete this task?
Please select the best answer.
  A. Commit the transaction
  B. Explicitly confirm the operation through the interface, since data entry alone does not create the account
  C. Select File > Save
  D. Exit OEM Cloud Control

4. You want to allow a user to use all the space in a tablespace. How do you accomplish that?
Please select the best answer.
  A. Assign the user a large quota, such as 999999999, so that the limit will never be reached.
  B. Don't assign a quota for that tablespace and there won't be a limit to enforce.
  C. Use the UNLIMITED keyword when assigning the user a quota on the tablespace.
  D. Specify DEFAULT TABLESPACE UNLIMITED when creating the user.

5. You have a provisioning script that runs CREATE USER, and you want it to complete without error if that user already exists from a previous, partially failed run. Which clause handles this?
Please select the best answer.
  A. REPLACE
  B. IF NOT EXISTS
  C. ON DUPLICATE SKIP
  D. FORCE