Oracle认证考试

View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_speci

题目

View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）

  • A、The database instance is running with manual PGA management.
  • B、The database instance is running with manual shared memory management.
  • C、The database instance has the MEMORY_TARGET value set to a nonzero value.
  • D、All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed
参考答案和解析
正确答案:C
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

CNA中可以通过下列哪几种方式查看BestPCCPCH_RSCP()

A.View In Table

B.View In Grid

C.View In GridChart

D.View In Map

E.View In Statistic


参考答案：A, B, C, D, E

第2题：

选择下面哪一个命令，可以在工作时获得最好的视觉效果()

A.“View-SimpleWireframe”

B.“View-Wireframe”

C.“View-Draft”

D.“View-Enhanced”


参考答案：D

第3题：

What does"a bird's-eye view"mean?

A． See a view with a bird' s eyes.

B． A bird looks at a beautiful view.

C． It is a general view from a high position.

D． If is a scenic place.


正确答案：C
a bird’s-eye view是美国俚语，意为“从高处向下看的景致：俯视”。A项意为“用鸟的眼睛看景点”；B项意为“鸟在看美景”；D项意为风景点。故C为正确选项。

第4题：

删除视图salary的命令是 A) DROP salary VIEW B）DROP VIEW salary C）DELETE salary VIEW D）DELETE salary


正确答案：B
本题考查SQL中删除视图的命令．删除视图的命令格式为：
　　DROP VIEW <视图名>
　　故选项B为正确答案。

第5题：

What is true about updates through a view? ()

A. You cannot update a view with group functions.

B. When you update a view group functions are automatically computed.

C. When you update a view only the constraints on the underlying table will be in effect.

D. When you update a view the constraints on the views always override the constraints on the underlying tables.


参考答案：A

第6题：

In the past half century, language teaching and learning practices have been influenced by three different views of language, namely, __________.

A.the structural view

B.the functional view and the interactional view

C.the structural view and the interactional view

D.the functional view and the interactional view


参考答案：A

第7题：

在数据库已打开的情况下，利用SQL命令从学生表中派生出含有“学号”、“姓名”和“年龄”字段的视图，下列语句正确的是

A．CREATE VIEW xs_view AS； SELECT学号，姓名，年龄FROM学生表

B．CREATE VIEW xs_view； SELECT学号，姓名，年龄FROM学生表

C．CREATE VIEW xs_view AS； (SELECT学号，姓名，年龄FROM学生表)

D．CREATE VIEW xs_view； (SELECT学号，姓名，年龄FROM学生表)


正确答案：A
解析：在SQL的数据定义功能中，可以对视图进行定义，语句格式为：CREATEVIEWview_name[(column_name[，column_name]．．．)]ASselect_statement

第8题：

CNA中可以通过()对测试路线上PCCPCHBestRSCP进行分段统计

A.View In Grid

B.View In GridChart

C.View In Table

D.View In Statistic


参考答案：C

第9题：

You are granted the CREATE VIEW privilege. What does this allow you to do? ()

A. Create a table view.

B. Create a view in any schema.

C. Create a view in your schema.

D. Create a sequence view in any schema.

E. Create a view that is accessible by everyone.

F. Create a view only of it is based on tables that you created.


参考答案：C

第10题：

修改本地视图的命令是

A) OPEN VIEW B）CREATE VIEW

C）USE VIEW D）MODIFY VIEW


正确答案：D
修改本地视图的命令是MODIFY VIEW穿件视图的命令是CREATE VIEW，打开视图的命令是USE VIEW,VisualFoxPro中没有OPEN VIEW命令，故选项D为正确答案。

更多相关问题
相关内容