Question Set

1. SQL Server supports three recovery modes: simple, full and Bulk.



Ask Your Doubts Here

Type in
(Press Ctrl+g to toggle between English and the chosen language)

Comments

  • By: guest on 01 Jun 2017 11.16 pm
    SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are: 1. Simple Recovery Model
    2. Full Recovery Model
    3. Bulk-logged Recovery Model
Show Similar Question And Answers
QA->A Server that can act as both client and server is:....
QA->In an examination A obtains 48 % of full marks and B obtains 33% of full marks. Together they get 567 marks. Find the full marks :....
QA->Three SQL, DDL, CREATE commands are–....
QA->A _____ is a computer attached to the internet that runs a special web server software and can send web pages out to the other computer over the internet.....
QA->The maximum speed at which data, can be transferred between two modes on a network is called:....
MCQ->You are the administrator of the Windows 2000 Server network shown in the exhibit. Users in the Research group and the Executive group have permission to access the Internet through a Windows 2000 Server computer running Microsoft Proxy Server. These users must enter their proxy server user names and passwords to connect to the proxy server, to the Internet, and to your local intranet server. The users who do not access the Internet do not have user accounts on the proxy server and, therefore, cannot connect to the intranet server. You want all users to be able to connect to the intranet server without entering a separate user name and password. What should you do?....
MCQ->SQL Server supports three recovery modes: simple, full and Bulk.....
MCQ->You install a Windows 2000 Server computer on your network. You place several shared folders on a 12-GB primary partition formatted by FAT32. During nine months of continuous operation, the number of users who access the server and their access frequency remains constant. The average size of the files on the server remains approximately constant. After the server runs continuous for nine months, users report that the server does not retrieve files from the shared folders as fast as when you first installed the server. What should you do to resolve the problem?....
MCQ->Consider the following statements : 1. A recovery ratio of less than 1 implies that the soil has compressed. 2. A recovery ratio greater than 1 implies that the soil has swelled. 3. A recovery ratio of less than 1 implies that the soil has swelled. 4. A recovery ratio greater than 1 implies that the soil has compressed. Which of the following statements given above is/are correct ?....
MCQ->You are the administrator of a Windows 2000 Server computer. The server contains one network adapter and is a file and print server for critical company resources. You install a second network adpater in the server and connect it to the same network subnet as the first adapter. You want to ensure that the first adapter is used for all network traffic and the second adapter is used only if the first adapter fails or is disconnected from the network. You also want to ensure that the server always has network connectivity even if one network adapter fails. What should you do?....
Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution