可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

A view is created with the following s


A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()

  • AWhen view V1 is created
  • BEach time the REFRESH VIEW v1 statement is executed
  • CEach time an SQL statement is executed against view V1
  • DOnly the first time an SQL statement is executed against view V1
参考答案
参考解析:
分类:IBM(000-730)题库
相关推荐

1、Which of the following statement(s) is

Which of the following statement(s) is/are TRUE regarding lashing requirements to secure vehicles aboard Ro-Ro vessels? ()AIt is imperative that...

2、Which of the following procedures is s

Which of the following procedures is safest perform when updating licensed program products?()ALoad all updates in the commit stateBLoad all up...

3、A sequence was created with the DDL st

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully ex...

4、A view is created with the following s

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWha...

5、You need to create a view EMP_VU. The

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for depar...

6、When the dock is refilled with water a

When the dock is refilled with water after docking repair, the first work which should be done by engineers is ()Aigniting boilerBreleasing air in sea water systemCstarting generatorDcut off shore power