网友您好，请在下方输入框内输入要搜索的题目：

搜题

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

提问人：网友haotongxue 发布时间：2022-01-07

[主观题]

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.

简答题官方参考答案（由简答题聘请的专业题库老师提供的解答）

查看官方参考答案

更多“You are the database administrator of a SQL Server 2000 computer. The server contains your”相关的问题

第1题

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.

点击查看答案

第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题

The database allows you to ________ the sales figures in a number of ways.

点击查看答案

第4题

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which co

ntains one redo member. When you attempt to start the database, you receive the following errors:Which statement should you use to resolve this issue？（）

Your database is in ARCHIVELOG mode. You have two

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B.ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG‘;

点击查看答案

第5题

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener？（）

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

点击查看答案

第6题

You are working on a 24X7 database. You want to design a backup strategy for your database

that uses user managed backups. You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true？（）

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

点击查看答案

第7题

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of t

he DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

点击查看答案

第8题

You are using recovery Manager （RMAN) with a recovery catalog to backup up your production

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations.While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs？（）

A. Open the database in NORMAL mode

B. Open the database in read-only mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

点击查看答案

第9题

The database allows you to ________ the sales figures in a number of ways.

A.buy

B.credit

C.access

D.data

点击查看答案

第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.

点击查看答案

第11题

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

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

考试指南全部 >

自考本科怎么自己报名网上操作步骤有哪些成人自考大专考什么科目专业科目一览表 2024自考考试时间考试科目汇总 2024年自考本科考试时间具体时间安排一览表 11省2024年10月自考报名时间及考试时间一览表成人自考本科2024年报名时间什么时候开始报考 2024年自考全国统一考试时间安排具体开考时间是几号 2024想自学考试怎么报名在哪里报名 2024自考本科在哪个网站报名详细报考流程是什么 2024自考本科什么时候报名怎么报名

购买搜题卡查看答案

购买前请仔细阅读《购买须知》

请选择支付方式

微信支付

支付宝支付

点击支付即表示你同意并接受《服务协议》和《购买须知》

立即支付已付款，但不能查看答案，请点这里登录即可>>

搜题卡使用说明

1. 搜题次数扣减规则：

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次