logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 Comments
  • Question

  • In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?


  • Options
  • A. Complete backup
  • B. Transaction Log
  • C. Differential backup
  • D. None of the above is correct.

  • Correct Answer
  • Differential backup 

    • SQL Server 2000 problems

    Search Results

    • 1. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

    • Options
    • A. REPEATABLE READ
    • B. SERIALIZABLE
    • C. READ COMMITTED
    • D. READ UNCOMMITTED
      • Discuss
    • 2. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

    • Options
    • A. Nonrepeatable read
    • B. Phantom read
    • C. Dirty read
    • D. Consistent read
      • Discuss
    • 3. Locks placed by command are called ________ .

    • Options
    • A. implicit locks
    • B. explicit locks
    • C. exclusive locks
    • D. shared locks
      • Discuss
    • 4. A cursor type in which the application can only move forward through the recordset is called:

    • Options
    • A. forward only.
    • B. static.
    • C. keyset.
    • D. dynamic.
      • Discuss
    • 5. A cursor type in which the application sees the data as they were at the time the cursor was opened is called:

    • Options
    • A. forward only.
    • B. static.
    • C. keyset.
    • D. dynamic.
      • Discuss
    • 6. Which of the following is a way to create and modify tables using SQL Server?

    • Options
    • A. Write SQL code using either CREATE or ALTER SQL statements only.
    • B. Use the graphical facilities of SQL Server Enterprise Manager only.
    • C. Both of the two methods above will work.
    • D. Neither of the two methods above will work.
      • Discuss
    • 7. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

    • Options
    • A. Nonclustered
    • B. Clustered
    • C. Primary
    • D. Secondary
      • Discuss
    • 8. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

    • Options
    • A. Nonclustered
    • B. Clustered
    • C. Primary
    • D. Secondary
      • Discuss
    • 9. With which type of SQL Server recovery model are all database changes logged?

    • Options
    • A. Differential recovery
    • B. Full recovery
    • C. Simple recovery
    • D. Bulk-logged recovery
      • Discuss
    • 10. The strictest transaction isolation level provided by SQL Server is called:

    • Options
    • A. REPEATABLE READ.
    • B. SERIALIZABLE.
    • C. READ COMMITTED.
    • D. READ UNCOMMITTED.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.