itgle.com

Evaluatethefollowingcommandanditsoutput：SQL>SELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurre

题目

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.

相似考题

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

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

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

4.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.

参考答案和解析
参考答案：D, E
更多“Evaluatethefollowingcommandanditsoutput:SQL>SELECT*FROMdba_temp_free_space;TABLESPACE_N ”相关问题

  • 第1题：

    select语句的完整语法较复杂，但至少包括的部分是（）。 A. 仅select B. select, from C. select, group D. select,where

    A．仅select

    B．select, from

    C．select, group

    D．select,where


    SELECT ，FROM

  • 第2题：

    在T-SQL语言中，SELECT语句的完整语法较复杂，但至少包括的部分（）。

    A．SELECT，INTO

    B．SELECT，FROM

    C．SELECT，GROUP

    D．仅SELECT


    SELECT ，FROM

  • 第3题：

    最基本的select语句可以只哪两个子句（）。

    A．select ,from

    B．select,group by

    C．select ,where

    D．select,order by


    A

  • 第4题：

    查询表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;


    AB

  • 第5题：

    SELECT语句中必选的子句是（）

    A．SELECT…FROM

    B．SELECT…FROM…WHERE

    C．SELECT…FROM…ORDER BY

    D．SELECT


    SELECT…FROM

相关内容