logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 See What Others Are Saying!
  • Question

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


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    Explanation
    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

    More questions

    • 1. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

    • Options
    • A. Two
    • B. Three
    • C. Four
    • D. Six
      • Discuss
    • 2. With JSP, the coding is done in Java and only in Java.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Indexes may be created or dropped at any time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Another name for multimedia data is unstructured data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The data model produced from the reverse engineering process is a true logical model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Failure to control confidentiality may lead to loss of competitiveness.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.