当前位置: 首页 >全部分类 >计算机类考试>微软认证>You are the administrator of a SQL Server 2000 database. You import a table of geographic
网友您好, 请在下方输入框内输入要搜索的题目:
网友您好, 请在下方输入框内输入要搜索的题目:
搜题

题目

You are the administrator of a SQL Server 2000 database. You import a table of geographic

information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.

You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A. Create a 60-MB data file named geography.ndf

B. Create a 95-MB data file named geography.ndf

C. Create a 60-MB data file named geography.mdf

D. Create a 95-MB data file named geography.mdf

E. Place the table in the PRIMARY filegroup.

F. Place the table in a new filegroup named LOCATION.

查看参考答案
更多“You are the administrator of a SQL Server 2000 database. You import a table of geographic”相关的问题

第1题

You are the administrator of a SQL server computer. The server is running SQL Server 6.5 a
nd SQL Server 7.0.

You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

You cancel the SQL Server upgrade wizard.

You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?

A.Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.

B.Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.

C.Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.

D.Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

点击查看答案

第2题

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install
SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take? (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.

点击查看答案

第3题

You are the administrator of several SQL Server 2000 computers. You want to retrieve infor
mation from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do?

A.Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B.Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C.Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D.Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

点击查看答案

第4题

You are the administrator of a SQL Server 2000 computer. You create several jobs on the se
rver and schedule them to run during the evening.

You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.

You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?

A.Configure SQLAgentMail to use a valid MAPI profile

B.Configure SQL Mail to use a mailbox that delegates permissions to the operator

C.Use the net send notification method to send the operator e-mail messages

D.Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

点击查看答案

第5题

You are the administrator of a SQL Server 2000 computer. Your company uses the server to s
tore service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do?

A.Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B.Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C.Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D.Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

点击查看答案

第6题

You are the database administrator for an accounting company. You are installing SQL Serve
r 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.

During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.

What should you do?

A.Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.

B.Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.

C.Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.

D.Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.

点击查看答案

第7题

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.

点击查看答案

第8题

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.CPS

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.

CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.

You are installing SQL Server 2000 on CPSRV1.

You specify a service account for each SQL Server service as shown in the following table:

After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain.

What should you do?

A.Configure the services to run under the local system account

B.Add CPSRV1 to the CPUSERS domain

C.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1

D.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.

E.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.

点击查看答案

第9题

以下属于网络数据库SQL Server中常见的版本的是()

A.SQL Server 2000企业版

B.SQL Server 2000标准版

C.SQL Server 2000个人版

D.SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是

点击查看答案

第10题

You are the administrator of a 12 SQL Server 2000 computers. These servers are located in
company offices throughout the world.

You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.

After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.

You need to make the New York City server a target server instead of a master server. What should you do?

A.On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.

B.On the JobMaster server, enlist all other servers as target servers.

C.On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.

D.On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.

点击查看答案
开通会员查看答案
该问题答案仅对会员开放,欢迎开通会员
推荐
季卡
¥49.90
查看1200次答案
月卡
¥39.80
查看600次答案
年卡
¥99.80
查看2000次答案
请选择支付方式
微信支付
支付宝支付
点击支付或扫码即表示你已同意并接受《服务协议》《会员须知》
立即支付
请使用微信扫码支付(元)
订单号:
遇到问题请联系在线客服
恭喜您,购买会员成功 系统为您生成的账号密码如下:
重要提示: 请勿将会员账号共享给其他人使用,违者账号将被封禁。
发送账号到微信 保存账号查看答案
怕账号密码记不住?建议关注微信公众号绑定微信,开通微信扫码登录功能
重置密码
账号:
旧密码:
新密码:
确认密码:
确认修改
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服

扫码关注微信公众号

开通微信扫码登录功能

警告:系统检测到您的账号存在安全风险

为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!

- 微信扫码关注赏学吧 -
警告:系统检测到您的账号存在安全风险
抱歉,您的账号因涉嫌违反赏学吧会员政策被冻结。您可在“赏学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封,或联系客服
- 微信扫码关注赏学吧 -