It produces an error because data already exists in the table.
It produces an error because compression can be enabled at table creation only.
It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.
第1题：
听力原文：Under the documentary credit, banks are in no way concerned with the sales contract on which the credit may be based.
(3)
A．Banks will deal with the documentary credit along with the sales contract.
B．Banks take no care of the sales contract while dealing with the documentary credit.
C．Documentary credit and the sales contract are both important to banks.
D．Banks will care for either the documentary credit or the sales contract.
第2题：
Which of the following statements about a Sales Catalog is TRUE？（）
第3题：
听力原文：W: What is function of the sale slip? It is so small that it is not always considered important.
M: It is small, of course, but it contains the details of the card and they also show the details and amount of the sale.
Q: What can we learn from the conversation?
(20)
A．The sales slips are not important.
B．The sales slips show the amount of the sale.
C．The sales slips perform. important functions in the bankcard transactions.
D．The sales slips contain the details of the card.
第4题：
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）
第5题：
Which statement is false about sales catalogs？（）
第6题：
你是一个出版公司的数据库开发人员，对特定的书名的每天的销售情况建立了如下的存储过程：
CREATE PROCEDURE get_sales_for_title
title varchar(80), @ytd_sales int OUTPUT
AS
SELECT @ytd_sales = ytd_sales
FROM titles
WHERE title = @title
IF @@ROWCOUNT = 0
RETURN(-1)
ELSE
RETURN(0)
另外建立了一个脚本执行这个存储过程，如果执行成功，将返回对应于书名的每天的销售情况的报表，如果执行失败，将返回“No Sales Found”，怎样建立这个脚本？
Ａ. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’, @ytd
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
Ｂ. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’, @ytd OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
Ｃ. DECLARE @retval int
DECLARE @ytd int
EXEC get_sales_for_title ‘Net Etiquette’,@retval OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
Ｄ. DECLARE @retval int
DECLARE @ytd int
EXEC @retval = get_sales_for_title ‘Net Etiquette’, @ytd OUTPUT
IF @retval < 0
PRINT ‘No sales found’
ELSE
PRINT ‘Year to date sales: ’ + STR (@ytd)
GO
第7题：
Which two types of information might be found at the Small Business Partner Central website？ （）
第8题：
Principles of Marketing Marketing is the part of your business where money is made. In order to succeed in business, the following two principles of marketing should be kept in mind. First, customers are the mainstay of any business. Attracting customers to a business makes the difference between succeeding and failing. Therefore, the business needs to direct all activities towards satisfying the customers’ needs. If customers are satisfied, there is a chance that they will be retained for a long time and possibly permanently. Undoubtedly they are likely to talk to other potential customers. Another principle for a business is that profitable sales volume is more important than maximum sales volume. The profitable sales volume is the volume of sales that actually will earn a business the most profit. And the maximum sales volume simply refers to the biggest sum of retail sales. Since the aim of most businesses is to make as much profit as possible, businesses value profits more than the volume of sales. A large volume of sales may result in a low profit margin, therefore, it is important for marketers to focus on their profitable sales volume. Decide if each of the following statement is TRUE (T) or FALSE (F).
1. In order to succeed in business, three principles of marketing should be kept in mind.()
2. If customers are satisfied, they will be likely to encourage more people to buy the products or services.()
3. The profitable sales volume is the volume of sales that will bring a business profit.()
4. The maximum sales volume refers to the biggest sum of retail sales.()
5. Profitable sales volume is as important as the maximum sales volume.()
第9题：
An installed customer has developed human resource constraints in the IT department. Which of the following allows the sales professional to proceed with future sales？（）
第10题：
Your company has an Active Directory domain that has an organizational unit named Sales. The Sales organizational unit contains two global security groups named sales managers and sales executives. You need to apply desktop restrictions to the sales executives group. You must not apply these desktop restrictions to the sales managers group. You create a GPO named DesktopLockdown and link it to the Sales organizational unit. What should you do next（）