logo

CuriousTab

CuriousTab

Discussion

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

  • 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

  • Correct Answer
  • REPEATABLE READ 

    • More questions

    • 1. JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

    • Options
    • A. a particular column in a particular underlying table.
    • B. a particular column in a particular row.
    • C. a particular row in a particular underlying table.
    • D. None of the above is correct.
      • Discuss
    • 4. Sequences guarantee valid surrogate key values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Views can be used to show the results of computed columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A proxy server controls the passage of messages or files through to the organization's network.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. No two attributes of the same entity type should have the same name.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Independent data marts are often created because an organization focuses on a series of short-term business objectives.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

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