This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Answer: D
Answer D is correct. A value -1 in the MAX_BLOCKS column of the
DBA_TABLESPACE_QUOTAS view means that the user has unlimited space quota for that
tablespace. View DBA_TABLESPACE_QUOTAS names all users and any tablespace quotas
that have been created for them.
A: If tablespace DATA01 has been dropped it will not be shown in
B: To check free space inside tablespace use DBA_FREE_SPACE view. This view identifies the
location and amount of free space, by tablespace name, file ID, starting block ID, bytes, and
blocks. Or DBA_FREE_SPACE_COALESCED can be used to identify the location of free
space in a tablespace that has been coalesced, by tablespace name and some other information.
C: If user has no quota on tablespace MAX_BLOCKS will be equal 0.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 471
Chapter 10: Managing Database Use
Consider the following command to create the user 'peter'.
CREATE USER peter
IDENTIFIED by panTEMPORARY TABLESPACE temp
Since no default tablespace was specified, what will happen if this command executed?...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09