题目内容

What should you do？

A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

查看答案

搜索结果不匹配？点我反馈

更多问题

You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory.
Developers at your company upgrade an inventory tracking application. Users report that when they insert new information in the Locations table, the upgrade application returns the following error message ‘string or binary data would be truncated. The statement has been terminated.’
When you use SQL profiler to trace the activity of the application, you receive the results as shown in the trace exhibit.
You examine the design of the locations table as shown in the table design exhibit.
Table Schema
You need to configure the database to support both versions of the application without affecting server performance. What should you do？

Alter the data type of the description field to varchar(50).
B. Alter the data type of the Special field to varchar(50).
C. Alter the data type of the CubicFeet field to float.
D. In the locations table, create an INSTEAD OF trigger that truncates the description field at 10 characters when the record is updated.
E. In the locations table, create an INSTEAD OF trigger that truncates the Special field at 10 characters when the record is updated.

查看答案

出境大动物或种用动物应在出境前45天预报检。()

A. 正确
B. 错误

查看答案

商检机构可根据需要，对检验的进出口商品加施商检标志或封识。()

A. 正确
B. 错误

查看答案

某公司资产负债率为50%，资产总额为100万元，净利润为15万元，则该企业的权益净利润率为 ()。

A. 0.075
B. 0.3
C. 0.15
D. 0.2

查看答案