商品入库的最普通方式是（)。A．车站码头提货B．仓库自行提货C．专用线接车D．零担到货

A．Each extra column in the copy with more columns must not have a default value

B．Columns that are common to both versions of the table must be defined in the same order on the master and the slave

C．The slave database cannot have more columns than the master. Only the master database can have more columns

D．Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

E．The master database cannot have more columns than the slavE．Only the slave deatbase can have more columns

ch mysqldump option can be used when dumping data from the master server in order to include the master server‘s binary log information？（）

A.Include-master-info

B.Master-binlog

C.Include-log-file

D.Master-data

amed lblTitle.You create a content page that references the master page.You need to change the Text property of the master page‘s lblTitle control from the content page.Which code segment should you use？（）

A.

B.

C.

D.

A. Set Page.MasterPageFile in the Page‘s Page_Init event.

B. Set Page.MasterPageFile in the Page‘s OnInit override.

C. Set Page.MasterPageFile in the Page‘s Page_Load event.

D. Set Page.MasterPageFile in the Page‘s Page_PreInit event.

A．DROP TABLE S Age

B．DROP Age FROM S

C．ALTER TABLE S DROP Age

D．ALTER TABLE S Age

听力原文：M: Do you want anything from the shop？

W: Yes, please. I need some water, I'm really thirsty.

Q: What does the woman need some water？

(16)

A．she's really hungry.

B．she's really thirsty.

C．she's really angry.

D．she's really sleepy.

ing data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.

You want to complete the data load as quickly as possible. What should you do？ (Each correct answer represents part of the solution. Choose all that apply.)

A．Apply a bulk update lock to the table.

B．Use separate client connections to load the files into the table simultaneously.

C．Create a clustered index on the table.

D．Specify the Full Recovery model for the database.

E．Specify the Bulk-Logged Recovery model for the database.

y month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.

A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.

After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.

You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.

What should you do？

A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.

B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.

C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.

D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

A: Can I borrow your geography notes from Professor Johnson's class？.B: ______

A．I beg your pardon. But why don't you ask Betty for it？

B．What do you need it for？ You can have it anytime you like.

C．Sure. I need it too. Here you are.

D．Sorry, I am using it myself. You can have it later.