考试网 >> IT认证 >> 微软 >> MCSE模拟题 >> MCSE模拟试题：SQLServer考题

发布时间：2006-06-28 03:59     点击：

    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 replication. You check the free space after running this command and note that free space has not changed. What is the most likely reason that free space has not changed?

    A. The distributor database is full

发表评论： 匿名发表 用户名: 查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任 留言板管理人员有权保留或删除其管辖留言中的任意内容 本站提醒：不要进行人身攻击。谢谢配合。