精品推荐
阅读排行
· 工程竣工验收报告· 大学生毕业自我鉴定
· 大学生自我鉴定7
· 大学毕业生自我鉴定
· 大学生学年自我鉴定
· 大学毕业生自我鉴定
· 师范生实习鉴定评语
· 给老师的一封感谢信
· 心理健康教育论文
· 黑板报设计图欣赏
| 作者：不明 来源：www.pccode.net 整理 发布时间：2007-1-24 15:21:18 发布人：wongrs | |
|
file regularly. Answer: A You are a SQL Server 7.0 system administrator for you company. To provide users with Full Text search capabilities, you create a Full Text catalog and enable Full Text indexing for specific tables in a database. From your Windows NT Workstation computer, you want to remotely monitor the size of the Full Text catalog on Windows NT server computer that is running SQL Server. Which of the following tools is the most convenient to use for monitor the Full Text catalog? A. Performance Monitor B. Query Analyzer C. The SP_MONITOR system stored procedure D. SQL Server Profiler. Answer: A Notice: To obtain real-time information about the size of a specific full-text catalog, you can continuously monitor the appropriate instance of the Microsoft search Indexer Catalogs You load a lot data into your database, then you find that the space for log is almost full, how can you do to ensure the restore: (Choose all that apply) A. Make a full backup B. Make a differential backup C. Backup the transaction log with the default options D. Backup the transaction log with truncate only Answer: A, D The engine manufacturing application records data about all the engines that are manufactured at your plant, the database contains approximately 500 Million records and is approximately 50GB in size. The database increases by 1000 records per day. You want to accomplish the following goals: 1. Minimize the time required to recover the database 2. Provide the ability to recover the database to a specific time 3. Minimize the number of transaction logs that need to be during recovery 4. Minimize the time required to backup the database You take the following actions 1. Schedule a full database backup of the entire database to occur every Sunday at AM 1:00 2. Schedule transaction log backup to occur every day at P.M Which result or results do these action produce? ( Choose all that apply ) A. The time required to recover the database is minimized B. The database can be recovered to a specific time. C. The number of transaction logs that need to be applied during recovery is minimized D. The time required to backup the database is minimized Answer: B, D You check the free space on a log file and run a BACKUP LOG WITH NO_LOG on a database that is a publisher for transactional replica
|
|
| [ ] [返回上一页] [打 印] [收 藏] | |
上一篇文章：微软认证模拟试题：IE4.0考题(1)
下一篇文章：NT Workstation 4试题1(1) |