多选题Top N analysis requires （） and （）.Athe use of rowidBa GROUP BY clauseCan ORDER BY clauseDonly an inline viewEan inline view and an outer query

第1题：

An IPS sensor with3 sniffing interfaces can be configuredas：  （）

• A、 3 promiscuous sensors
• B、 3 inline sensors
• C、 1 inline sensor， 1 promiscuous sensor
• D、 2 inline sensors， 1 promiscuous sensors

第2题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第3题：

内联函数的正确定义是（）

• A、inline int small（）；int small（）{/*……*/}
• B、int small（）；inline int small（）{/*……*/}
• C、int inline small（）；int small（）{/*……*/}
• D、int small（）；int inline small（）{/*……*/}

第4题：

What is true regarding subqueries?（）

• A、The inner query always sorts the results of the outer query
• B、The outer query always sorts the results of the inner query
• C、The outer query must return a value to the outer query
• D、The inner query returns a value to the outer query
• E、The inner query must always return a value or the outer query will give an error

第5题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command on the EMP_DEPT_VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第6题：

Top N analysis requires （） and （）.

• A、the use of rowid
• B、a GROUP BY clause
• C、an ORDER BY clause
• D、only an inline view
• E、an inline view and an outer query

第7题：

Which method of the ChildActionExtensions class calls a child action method and renders the result inline in the parent view？（）

• A、RenderPartial
• B、Action
• C、Render
• D、RenderAction

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A schedule defined entirely within the confines of a Scheduler job object is known as a （n） （）

• A、 Fixed schedule
• B、 Inline schedule
• C、 Stored schedule
• D、 Hard-coded schedule
• E、 None of the above

第14题：

下列查询年龄最大的前四个学生（包括并列的情况）的语句，正确的是（）。

• A、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage ASC
• B、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage ASC
• C、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage DESC
• D、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage DESC

第15题：

How can a JFS2 filesystem be added to a volume group that has insufficient space to host a log LV？（） 

• A、Create the filesystem with an inline log.
• B、Create the filesystem referring to the jfs2log in rootvg.
• C、Create the filesystem and format the logical volume with ’logform’.
• D、Create the filesystem’s underlying logical volume with an inline log.

第16题：

Which best describes an inline view?（）

• A、a schema object
• B、a subquery that can contain an ORDER BY clause
• C、another name for a view that contains group functions
• D、a subquery that is part of the FROM clause of another query

第17题：

What is true regarding subqueries?（）

• A、The inner query always sorts the results of the outer query.
• B、The outer query always sorts the results of the inner query.
• C、The outer query must return a value to the inner query.
• D、The inner query returns a value to the outer query.
• E、The inner query must always return a value or the outer query will give an error.

第18题：

DIMM（Dual-Inline-Menory-Modules）

第19题：

第20题：

第21题：

第22题：

第23题：