logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 Comments
  • 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

    SQL Server 2000 problems

    Search Results

    • 1. SQL Server automatically creates an index on all primary and foreign keys.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. SERIALIZABLE is the strictest isolation level.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. SQL Server AFTER Triggers may be assigned views.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. With SQL Server, parameters and variables in T-SQL start with the "%" sign.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. By default, SQL Server will create one data file and one log file for each newly created database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Nonclustered indexes are faster than clustered indexes for retrieval.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SQL Server supports a language called Transact-SQL (also called T-SQL).

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Better security occurs if Windows-only authentication is selected.

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