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. An attribute is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss
    • 2. If a relation is in third normal form, it does not need to be in second normal form.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?

    • Options
    • A. VBScript only
    • B. Jscript only
    • C. Java only
    • D. All of the above are supported
      • Discuss
    • 4. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

    • Options
    • A. Equi-join
    • B. Natural join
    • C. Outer join
    • D. Cartesian join
      • Discuss
    • 5. Locks placed by the DBMS are called ________ .

    • Options
    • A. implicit locks
    • B. explicit locks
    • C. exclusive locks
    • D. shared locks
      • Discuss
    • 6. The use of packaged data models can offer which of the following benefits?

    • Options
    • A. Reduce implementation time and costs
    • B. Higher quality models
    • C. Both A and B.
    • D. Neither A nor B.
      • Discuss
    • 7. The identifier of an entity will become the ________ of the new table.

    • Options
    • A. foreign key
    • B. main attribute
    • C. primary key
    • D. identity key
      • Discuss
    • 8. An autonomous homogenous environment is which of the following?

    • Options
    • A. The same DBMS is at each node and each DBMS works independently.
    • B. The same DBMS is at each node and a central DBMS coordinates database access.
    • C. A different DBMS is at each node and each DBMS works independently.
    • D. A different DBMS is at each node and a central DBMS coordinates database access.
      • Discuss
    • 9. Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.

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