题目内容（请给出正确答案）

[主观题]

某公司承接了一项体育馆工程的施工任务，该工程规定建设用地 35280m2，总建筑面积55000m2，其中地下

部分建筑面积不少于8000m2。采用钢结构，构件的连接主要是采用焊接方式，局部采用螺栓连接。施工时，由于结构复杂，部分钢材采用进口钢材，并按照规定对进口钢材进行检查。

钢结构原材料的检查，对于进口钢材尚应检查()。

A．出厂合格

B．性能

C．中文标志

D．复验报告

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“某公司承接了一项体育馆工程的施工任务，该工程规定建设用地 3…”相关的问题

第1题

server’s msdb database in an e-mail message to the administrator of another SQL Server com

puter.

You create a job that contains the following steps:

--Detach the msdb database

--Send the database to the administrator in an e-mail message

--Reattach the msdb database

You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.

What should you do？

A．Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database

B．Delete the first and last steps in the job

C．Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message

D．Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database

点击查看答案

第2题

You are the administrator of two Microsoft Windows 2000 advanced server computers. On thes

e servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database？

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.

点击查看答案

第3题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You a

You？work？in？a？company？which？is？named？Wiikigo？Corp.？The？company？uses？SQL？Server？2008.？You？are？the？administrator？of？the？company？database.？Now？you？are？in？charge？of？a？SQL？Server？2008？instance.？There？is？a？database？named？DB1？in？the？instance.？In？the？database,？a？small？percentage？of？data？is？modified？everyday.？Ever？day？in？the？morning,？you？have？to？create？a？read-only？copy？of？the？database？for？reporting？purposes？and？make？sure？that？you？use？as？little？disk？space？as？possible.

In？the？options？below,？which？strategy？should？you？use？（）？？

A. You？should？use？database？snapshots？

B. You？should？use？database？backup？and？restore？

C. You？should？use？database？backup？and？restore？along？with？compression？

D. You？should？use？schema-bound？views？in？a？read-only？database.？The？database？resides？on？the？same instance.

点击查看答案

第4题

You are the administrator of a SQL Server 2000 database named Articles. A large city newsp

aper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.

A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

You want to ensure that the journalists can query the database. What should you do？

A．Create a new full-text catalog for the Articles database

B．Rebuild the full-text catalog for the Articles database

C．Create a new full-text index on the table that holds the text for the articles

D．Repopulate the full-text index on the table that holds the text for the articles

点击查看答案

第5题

You are the administrator of a SQL Server 2000 computer. The server contains a database na

med Sales. The database is configured as shown in the exhibit.

In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.

You want to accelerate query response time. What should you do？

A．Update the database statistics.

B．Add indexes to the foreign key fields.

C．Truncate the transaction log.

D．Run the database maintenance plan wizard.

E．Drop primary keys from all tables.

点击查看答案

第6题

You are the administrator of a SQL Server 2000 computer. The server contains a database th

at has the torn page detection database option enabled. Backups of the database are made daily.

The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.

You need to correct the problem. What should you do？

A．Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.

B．Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.

C．Execute the sp_resetstatus stored procedure.

D．Restore the suspect database from backups.

点击查看答案

第7题

You are the database administrator of a SQL Server 2000 computer. The server contains your

company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do？

A．Enable the torn page detection database option for each database.

B．Disable write caching on all disk controllers.

C．Ensure that write caching disk controllers have battery backups.

D．Create a database maintenance plan to check database integrity and make repairs each night.

点击查看答案

第8题

You are the administrator of a SQL Server computer. Users report that the database times o

ut when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.

You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do？

A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed

B．Use the sp_who stored procedure to discover who is logged in as spid 52

C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

D．Use System Monitor to log the locks that are granted in the database

点击查看答案

第9题

You are the administrator of a SQL Server 2000 computer. The server contains a database na

med MedicalRecords. You have recently added a hard disk to the server and configured the database.

The data files are configured as shown in the Database Properties exhibit.

The database is configured as shown in the Database Schema exhibit.

Each primary key is clustered. All foreign keys contain nonclustered indexes. You want to use the space on the new hard disk to make the database respond more quickly to queries.

What should you do？

A．Re-create the Notes table on the SECONDARY filegroup.

B．Re-create the nonclustered indexes on the SECONDARY filegroup.

C．Re-create the Patients and Doctors tables and their indexes on the SECONDARY filegroup.

D．Re-create the Cases and Notes tables and their indexes on the SECONDARY filegroup.

点击查看答案

第10题

You are the administrator of a SQL Server 2000 computer. The server contains a database na

med Sales. You perform. full database backups every two days. You also run regular database consistency checks on the server. The most recent check of the Sales database returns the following message.

“CHECKDB found 0 allocation errors and 9 consistency errors in the table 'Orders' (object ID 214575782).”

You want to correct the data integrity errors while minimizing the amount of data lost. What should you do？

A．Disconnect users from the Sales database. Enable the single user database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.

B．Disconnect users from the Sales database. Enable the DBO use only database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.

C．Disconnect users from the Sales database. Execute the RESTORE DATABASE statement for the Sales database

D．Execute the DBCC CLEANTABLE statement for the Orders table.

E．Execute the sp_table_validation stored procedure for the Orders table.

点击查看答案