Evaluatethefollowingcommandanditsoutput:SQLSELECT*FROMdba_temp_free_space;TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput?()A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused,andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse,andthespacethatiscurrentlyunallocated.

Evaluatethefollowingcommandanditsoutput:SQL>SELECT*FROMdba_temp_free_space;TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput?()

A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.

B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.

C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.

D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused,andthespacethat isavailableforreuse.

E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse,andthespacethatiscurrentlyunallocated.


相关考题:

标准SQL基本查询模块的结构是A)SELECT…FROM…ORDER BYB)SELECT…WHERE…GROUP BYC)SELECT…WHERE…HAVINGD)SELECT…FROM…WHERE

Evaluate the following command and its output:Which two statements correctly interpret the output?() A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

标准SQL基本查询模块的结构是A.SELECT. . . FROM. . . ORDER BYB.SELECT. . . WHERE. . . GROUP BYC.SELECT. . . WHERE. . . HAVINGD.SELECT. . . FROM. . . WHERE.

最基本的select语句可以只包括()子句和()子句。A.select,fromB.select,group byC.select,whereD.select,order by

select语句的完整语法较复杂,但至少包括的部分是()。 A. 仅select B. select, from C. select, group D. select,whereA.仅selectB.select, fromC.select, groupD.select,where

查询表erexam和表exampaper自然左外联接,查询语句就可以写成()。A.SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;B.SELECT * FROM erexam NATURAL LEFT JOIN exampaper;C.SELECT * FROM erexam NATURAL JOIN exampaper;D.SELECT * FROM erexam OUTER JOIN exampaper;E.SELECT * FROM erexam NATURAL OUTER JOIN exampaper;F.SELECT * FROM erexam LEFT OUTER JOIN exampaper;

在T-SQL语言中,SELECT语句的完整语法较复杂,但至少包括的部分()。A.SELECT,INTOB.SELECT,FROMC.SELECT,GROUPD.仅SELECT

SELECT语句中必选的子句是()A.SELECT…FROMB.SELECT…FROM…WHEREC.SELECT…FROM…ORDER BYD.SELECT

最基本的select语句可以只哪两个子句()。A.select ,fromB.select,group byC.select ,whereD.select,order by