logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 Comments
  • Question

  • By default, SQL Server will create one data file and one log file for each newly created database.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • SQL Server 2000 problems

    Search Results

    • 1. Locks placed by the DBMS are explicit locks.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In optimistic locking, the assumption is made that conflict will occur.

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

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

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. SQL Server automatically creates an index on all primary and foreign keys.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. SQL Server supports three recovery modes: simple, full and Bulk.

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