Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?()A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment

Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?()

A. Rollback segment

B. Temporary segment

C. Data segment

D. Index segment


相关考题:

加粗文字的标记为() A.〈em〉B.〈B〉C.〈strong〉D.〈TABLE〉

Bootstrap中,通过对表格调用类()可实现响应式表格。 A..table-condensedB..table-stripedC..table-hoverD..table-responsive

通过对表格调用Bootstrap中的类()可实现条纹状表格效果。 A.table-stripedB.table-hoverC.table-responseD.table

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?() A.Table_open_cacheB.Table_open_cache_instancsC.Table_definition_cacheD.Tmp_table_sizeE.Max_heap_table_sizeF.Max_tmp_tables

假如有两个表的连接是这样的:table_1 INNERJOIN table_2,其中table_1和table_2是两个具有公共属性的表,这种连接会生成( )结果集。A.包括table_1中的所有行,不包括table_2的不匹配行B.包括table_2中的所有行,不包括table_1的不匹配行C.包括两个表的所有行D.只包括table_1和table_2满足条件的行

物化视图日志默认的名字是:() A. M$LOG_TABLE_NAMEB. MLOG$_TABLE_NAMEC. MLOG_ TABLE_NAME

DreamWeaver 的 Modify 菜单中,对整个选定表格的列宽度值从百分比转换为像素选哪项?A. Table→Clear Cell HeightsB. Table→Clear Cell WidthsC. Table→Convert Widths to PixelsD. Table→Convert Widths to Percent解析:Table→Clear Cell Heights 用来将表格的行高清除,Table→Clear Cell Widths 用来将表格的列宽清除,Table→Convert Widths to Pixels 将整个选定表格的列宽度值从百分比转换为像素,Table→Convert Widths to Percent 将整个选定表格的列宽度值从像素转换为百分比

【单选题】假如有两个表的连接是这样的: table_a inner join table_b 其中table_a和table_b是两个具有公共属性的表,这种连接会生成哪种结果集()A.包括table_a中的所有行,不包括table_b的不匹配行B.包括table_b中的所有行,不包括table_a的不匹配行C.包括和两个表的所有行D.只包括table_a和table_b满足条件的行

1、假设有两个表的连接:table1 INNER JOIN table2 ,其中table1和table2是两个具有公共属性的表,这种连接会生成()结果集。A.包括table1中的所有行,不包括table2的不匹配行B.包括table2中的所有行,不包括table1的不匹配行C.包括两个表的所有行D.只包括table1和table2满足条件的行

如果TABLE为数据段中0032单元的符号名,其中存放的内容为1234H,当执行指令”MOV AX,TABLE”和”LEA AX,TABLE”后,(AX)中的内容分别为多少?A.执行MOV AX , TABLE后(AX)=1234HB.执行LEA AX, TABLE 后 (AX)=0032H.C.执行MOV AX , TABLE后(AX)=0032HD.执行LEA AX, TABLE 后 (AX)=1234H