Create CHECK constraints on the tables.
Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
Create the view, specifying the WITH SCHEMABINDING option.
Create the view, specifying the WITH CHECK option.
第1题：
听力原文：M: Do you provide investment service?
W: Yes. We are a commercial bank. We help customers with the purchase and sales of securities.
Q: What does the man want to do?
(13)
A．He will provide investment service.
B．He will help the customers.
C．He will join the commercial bank.
D．He will purchase or sell securities.
第2题：
Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
A.
B.
C.
D.
第3题：
利用SQL派生一个包含“课程名称”、“姓名”和“成绩”的视图，要求按“课程名称”升序排序，正确的语句是( )。
A．CREATE VIEW view1 AS； (SELECT课程.课程名称,学生.姓名,成绩.成绩； FROM课程INNER JOIN成绩； INNER JOIN学生： ON成绩.学号=学生.学号； ON课程.课程编号=成绩.课程编号； GROUP BY课程名称)
B．CREATE VIEW view1 AS； (SELECT课程.课程名称,学生.姓名,成绩.成绩； FROM课程INNER JOIN成绩； INNER JOIN学生： ON成绩.学号=学生.学号； ON课程.课程编号=成绩.课程编号； ORDER BY课程名称)
C．CREATE VIEW view1 AS； SELECT课程.课程名称,学生.姓名,成绩.成绩； FROM课程INNER JOIN成绩； INNER JOIN学生： ON成绩.学号=学生.学号； ON课程.课程编号=成绩.课程编号； GROUP BY课程名称
D．CREATE VIEW view1 AS； SELECT课程.课程名称,学生.姓名,成绩.成绩； FROM课程INNER JOIN成绩； INNER JOIN学生； ON成绩.学号=学生.学号； ON课程.课程编号=成绩.课程编号； ORDER BY课程名称
第4题：
现有客户表customers（主键：客户编号cid），包含10行数据，订单表orders（外键：客户编号cid），包含6条数据。执行sql语句：select * from customers right outer join orders on customers.cid=orders.cid。最多返回（）条记录。
第5题：
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
第6题：
A. USER_TAB_PRIVS_MADE
B. USER_TAB_PRIVS
C. USER_COL_PRIVS_MADE
D. USER_COL_PRIVS
第7题：
How many orders are included in standard ship orders? Can you list some?
第8题：
It takes a lot of time and effort to develop and maintain a marketing campaign that resonates(共鸣)with your potential clients. However, you should think more about how to develop a marketing campaign. After all, we’re always looking for ways to increase our competitiveness. Here are some marketing strategies for you to check out.
Partner(结伴)with allies. Marketing partnerships have many benefits to push a marketing campaign. For starters, when you stand side by side with someone else, you can deliver better content. If you are at the top of your business, marketing partnerships are cheaper to maintain your success and expose your brand.
Embrace user-generated content. According to a survey of 839 millennia’s(千万富翁)they spend 5.4 hours a day communicating with their peers, about 30 percent of their total media time. Similarly, you can also make this by sharing personal stories and exchanging ideas with your customers. This is a good way of carrying out advertisement.
Help customers solve a problem. As perfectly stated on Hubs pot,”You’re in business because you provide solutions.”Some of the ways you can help customers solve a problem is by: creating how-to-content; offering exclusives that make their lives easier; listening to them or answering their questions; or creating APPs or tools.
Let customers interact. No matter the product or service you’re offering, your customers want to interact with your company, or at least other customers. AMC, for example, created an online tool that allowed you to write down your imaginations. American Express connects small business owners to each other and helpful resources through its open forum.
26. This article mainly talks about().
A. some marketing strategies
B. your potential clients
C. communicative skills
27. You are suggested in the second paragraph to().
A. fight against your opponent
B. find
allies with someone else
C. always focus on yourself
28. To embrace user-generated content does good at().
A. making friends with strangers
B. choosing capable employees
C. Carrying out advertisement
29. Which of the following is NOT a way of helping customers solve a problem?
A. creating how-to-content
B. listening to customers
C. having dinner with customers
30. AMC created an online tool so that().
A. one can write down what he imagines
B. your dreams and thoughts will come true
C. they can gather information from customers
参考答案：26、A 27、B 28、C 29、C 30、A
第9题：
Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）
第10题：
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）