READ Free Dumps For Oracle- 1z0-023
| Question ID 8726 | A DBA performs the query: SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username= "SCOTT; That returns the result: TABLESPACE_NAME MAX_BLOCKS ------------------------------ ------------------ DATA01 -1 What does -1 indicate?
|
| Option A | Tablespace DATA01 has been dropped.
|
| Option B | Tablespace DATA01 has no free space.
|
| Option C | The user has no quotas on tablespace DATA01.
|
| Option D | The user has an unlimited quota on tablespace DATA01.
|
| Option E | The user has exceeded his or her quota on the tablespace DATA01.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: 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. Incorrect Answers: A: If tablespace DATA01 has been dropped it will not be shown in DBA_TABLESPACES_QUOTAS view. 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
| Question ID 8748 | A DBA performs the query: SELECT tablespace_name, max_blocksFROM dba_tablespace_quotasWHERE username= "SCOTT; That returns the result: TABLESPACE_NAME MAX_BLOCKS
DATA01 -1 What does -1 indicate?
|
| Option A | Tablespace DATA01 has been dropped.
|
| Option B | Tablespace DATA01 has no free space.
|
| Option C | The user has no quotas on tablespace DATA01.
|
| Option D | The user has an unlimited quota on tablespace DATA01.
|
| Option E | The user has exceeded his or her quota on the tablespace DATA01.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: 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. Incorrect Answers: A: If tablespace DATA01 has been dropped it will not be shown in DBA_TABLESPACES_QUOTAS view. 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