单选题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 condit

第1题：

第2题：

第3题：

Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）

• A、0
• B、1
• C、2
• D、3

第4题：

存在两个结构相同的数据库表T1（col1，col2，col3）、T2（col1，col2，col3），写出一SQL语句将所有T1数据导入到T2表（）

• A、select col1，col2，col3 from T1 into T2（col1，col2，col3）
• B、insert T1 （col1，col，col3） into T2（col1，col2，col3）
• C、insert into T2 （col1，col2，col3） as select col1，col2，col3 from T1
• D、insert into T2（col1，col2，col3） select col1，col2，col3 from T1；

第5题：

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.

第6题：

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;

第7题：

A SQL Azure database generates an error when a row is inserted into any table in the database.  No error is generated when a row is deleted.  You need to recommend an approach for locating the source of the errors.  What should you recommend？（）  

• A、 Use a Dynamic Management View to check for locks.
• B、 Use a Dynamic Management View to check for blocked queries.
• C、 Use a Dynamic Management View to check for long-running queries.
• D、 Use a Dynamic Management View to check the size and maximum size of the database.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

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.

第15题：

设有关系模式商品（商品号，商品名称，单价，数量，类别），建立统计每类商品总数量的视图的正确语句是（）

• A、CREATE VIEW v1AS SELECT类别，SUM（数量）FROM商品GROUP BY类别
• B、CREATE VIEW v1AS SELECT类别，COUNT（数量）FROM商品GROUP BY类别
• C、CREATE VIEW v1（类别，总数量）AS SELECT类别，SUM（数量）FROM商品GROUP BY类别
• D、CREATE VIEW v1（类别，总数量）AS SELECT类别，COUNT（数量）FROM商品GROU PBY类别

第16题：

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;

第17题：

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.

第18题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

• A、 Remove all deterministic function calls from within the view. 
• B、 Remove all nondeterministic function calls from within the view. 
• C、 Schema-bind all functions that are called from within the view. 
• D、 Create the view and specify the WITH CHECK OPTION clause.

第19题：

You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

• A、Create CHECK constraints on the tables. 
• B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
• C、Create the view, specifying the WITH SCHEMABINDING option. 
• D、Create the view, specifying the WITH CHECK option. 

第20题：

第21题：

第22题：

第23题：

第24题：