题目内容

You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）

A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
D. A TOP-N query is created to limit the rows to 20 percent of the total row

查看答案

搜索结果不匹配？点我反馈

更多问题

有下列（）情形之一的，应收账款质押登记的质权人应自该情形产生之日起10个工作日内办理注销登记。

A. 主债权消灭
B. 质权实现
C. 质权人放弃登记载明的应收账款之上的全部质权
D. 其他导致所登记质押消灭的情形

AC220V或DC216V灯具的供电回路工作电流不宜大于（）A；安全电压灯具的供电回路工作电流不宜大于（）A。

A. 15，5
B. 15，10
C. 10，5
D. 10，10

《高速铁路有砟轨道线路维修规则》规定，短心轨与叉跟尖轨尖端间隙大于（）mm，应进行修理或更换。

《铁路技术管理规程》（普速铁路部分）接触网带电部分至机车车辆或装载货物的距离，不小于（）mm。

A. 200
B. 250
C. 300
D. 350