-
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.
-
ou are developing an ASP.NET MVC 2 application. You create a view that will be returned by action methods in multiple controllers. You need to place the view in the appropriate folder. To which subfolder within the Views folder should you add the view?()
A . Master
B . Default
C . Shared
D . Commo
-
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
-
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 departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
Dreamweaver的视图(View)菜单中,FrameBorders表示()
A . 选择显示状态栏
B . 显示未选定的层的边框
C . 选择未选定的表格的边框
D . 启动拖放帧创建所必需的边框
-
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 departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
DBMS执行CREATE VIEW语句的结果只是把(),并不执行其中的SQL语句。
-
AdobeIllustrator9.0中可以建立“视图”(View)以方便局部的观察,下列描述正确的是?()
A . Adobe Illustrator9.0只能建立一个“视图”
B . 你可以通过“编辑视图”(ViewEditView)命令改变所建“视图”的名称或将其删除
C . 你可以通过“编辑视图”(ViewEditView)命令改变所建“视图”的内容
D . Adobe Illustrator9.0中“视图”一旦建立,不会随此部分编辑内容的变化而再发生任何变化
-
在AutoCAD中,VIEW视图管理命令有时无法作用,这种情况下,应检查()。
A . SNAP是否为开启状态
B . VIEWRES是否为PastZoom状态
C . ORTHO是否为OSNAP状态()。
D . Regenauto变量是否设置为OFF状态
-
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.
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
servlet属于MVC(Model-View-Controller)中的视图(view) 。
-
servlet属于MVC(Model-View-Controller)中的视图(view)。
-
在关系数据库中,视图(view)是三级模式结构中的( )。
-
在关系数据中,视图(view)是三级模式结构中( )
-
SQL中创建视图应使用CREATE VIEW语句。
-
下面列出的关于“视图(View)”的条目中,哪一条是不正确的( )
-
如果要创建视图,使用的命令是create view
-
练习 9 :从视图“ View_DBscores ”查询 ” 郭洪亮 ” 所选的课程名称和成绩
-
CREATE VIEW语句用于在SQL中建立视图。如果要求对视图更新时,必须满足子查询中的条件表达式,应当在该语句中使用短语()。
A.WITH UPDATE
B.WITH INSERT
C.WITH DELETE
D.WITH CHECK OPTION
-
create 或 replace 命令不能修改视图,只能新建视图。
-
【判断题】补间动画只是改变了View对象绘制的位置,而没有改变View对象本身。
A.Y.是
B.N.否
-
将各个系教师的平均工资定义为视图average_salary. create view average_salary as select dept_name,max(salary) from instructor; group by dept_name;
-
29、已添加自定义Dialog布局dialog_layout.xml文件。如何创建自定义Dialog的视图,请补全相关代码: View diy=getLayoutInflater(____________________,null);