A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）A、Any row inserted or updated through view V1 must meet the condition

题目

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）

A、Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B、From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C、At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D、Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.

参考答案和解析

正确答案:A

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

第2题：

Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）

A、 use the @function @decimal in the column formula in the view
B、 select decimal on the numbers tab in the view properties box
C、 select decimal on the numbers tab in the column properties box
D、 use the @function @decimal to format the value in the field on the form that will display in the view

正确答案:C

第3题：

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

第4题：

The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

A、user tables
B、view segment
C、table segment
D、data dictionary
E、object segment
F、performance tables

正确答案:D

第5题：

tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

A、select the parenthesis when negative value in the view properties box
B、select the parenthesis when negative value in the column properties box
C、use the @function @negative to set this in the column formula in the view
D、use a formula to format the value in the field on the form that will be displaying in the view

正确答案:B

第6题：

Which two statements about views are true? （）

A、A view can be created as read only.
B、A view can be created as a join on two or more tables.
C、A view cannot have an ORDER BY clause in the SELECT statement.
D、A view cannot be created with a GROUP BY clause in the SELECT statement.
E、A view must have aliases defined for the column names in the SELECT statement.

正确答案:A,B

第7题：

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 create.) How do you obtain the definition of the view? （）

A、Use the DESCRIBE command in 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.

正确答案:D

第8题：

Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）

A、 use the @currenty in thr column formula in the view
B、 Select currency on the numbers tab in the view properties box
C、 Select currency on the numbers tab in the column properties box
D、 Select currency on the numbers tab in the field properties box

正确答案:C

第9题：

Which two statements are true regarding views?（）

A、A subquery that defines a view cannot include the GROUP BY clause
B、A view that is created with the subquery having the DISTINCT keyword can be updated
C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

正确答案:C,D

第10题：

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.

正确答案:D

A view is created with the follo

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容