RelationalDBDesign RelationalDBDesign

Creating Users   «Prev  Next»

Users and the data dictionary - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. Which view is the primary source of information about database users?
Please select the best answer.

2. You have retrieved a list of tablespace quotas for a user and some quotas are a -1. What does a -1 mean here?
Please select the best answer.
  A. The user exceeded quota by creating too many objects and now has a negative balance.
  B. The user is allowed to use up to 1 megabyte of space. Negative values represent megabytes.
  C. The user has no limit on the amount of space that may be used. Negative values represent unlimited quota.
  D. The user has not been assigned a quota on the tablespace. Negative values represent unassigned quotas.

3. You need to see if a user can create objects in the tablespace named USERS. Which two things should you check?
Please select all the correct answers.
  A. Check the DBA_TS_QUOTAS view to see if the user has been assigned quota on that tablespace.
  B. Check DBA_USERS to see if USERS is the default tablespace assigned to the user.
  C. Check DBA_SYS_PRIVS to see if the user has been granted the UNLIMITED TABLESPACE privilege.
  D. Check DBA_TABLESPACES to see if the user owns the tablespace.