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?（）..

第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.

点击查看答案

第2题

[单选题] 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.

点击查看答案

第3题

[] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、A. Create a table view. B、B. Create a view in any schema. C、C. Create a view in your schema. D、D. Create a sequence view in any schema. E、E. Create a view that is accessible by everyone. F、F. Create a view only of it is based on tables that you created.

点击查看答案

第4题

[单选题] 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?（）

A、When view V1 is created B、Each time the REFRESH VIEW v1 statement is executed C、Each time an SQL statement is executed against view V1 D、Only the first time an SQL statement is executed against view V1

点击查看答案

第5题

[多选题] Which two statements about creating constraints are true? （）

A、Constraint names must start with SYS_C B、All constraints must be defines at the column level C、Constraints can be created after the table is created D、Constraints can be created at the same time the table is created E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案

第6题

[多选题] Which two statements about creating constraints are true?（）

A、Constraint names must start with SYS_C B、All constraints must be defines at the column level C、Constraints can be created after the table is created D、Constraints can be created at the same time the table is created E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案

第7题

[] Which two statements about creating constraints are true?（）

A、A. Constraint names must start with SYS_C B、B. All constraints must be defines at the column level. C、C. Constraints can be created after the table is created. D、D. Constraints can be created at the same time the table is created. E、E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

点击查看答案

第8题

[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints B、creates a view even if the underlying parent table has constraints C、creates a view in another schema even if you don't have privileges D、creates a view regardless of whether or not the base tables exist

点击查看答案

第9题

[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints B、creates a view even if the underlying parent table has constraints C、creates a view in another schema even if you don't have privileges D、creates a view regardless of whether or not the base tables exist

点击查看答案

第10题

[单选题] What does the FORCE option for creating a view do?（）

A、creates a view with constraints B、creates a view even if the underlying parent table has constraints C、creates a view in another schema even if you don't have privileges D、creates a view regardless of whether or not the base tables exist

点击查看答案

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?（）

请使用微信扫码支付