AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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

Send email to admin@getfreedumps for new dumps request!!!