试题详情
- 单项选择题 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、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 rows
- C
关注下方微信公众号,在线模考后查看
热门试题
- What command
- Given: What is
- The tnsnames.ora fil
- ()是具有只读类型的表和视图集,存储了数
- You find t
- Given: Which t
- 下列哪一个操作可以用来为一个备份操作手动
- Oralce数据库中,以下()函数可以针
- Which two̳
- You scheduled&
- You need
- Given:
- Which statement expl
- Given: Which c
- Your system
- You have a very larg
- Which two operations
- Which one is a syste
- 下列哪种约束实现域完整性?()
- Which /SQL*Plus feat