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 Security Manager and have entered all the information for a new user. What must you do next to complete this task?
Please select the best answer.
  A. Commit the transaction
  B. Click the Create button
  C. Select File > Save
  D. Exit Security Manager

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.