logo

CuriousTab

CuriousTab

Discussion


Home Database SQL Server 2000 See What Others Are Saying!
  • Question
  • Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?


  • Options
  • A. READ_ONLY
  • B. SCROLL_LOCK
  • C. OPTIMISTIC
  • D. READCOMMITTED

  • Correct Answer
  • READCOMMITTED 


  • More questions

    • 1. Which one of the following symbols is not used in an ERD?

    • Options
    • A. Rectangle
    • B. Oval
    • C. Diamond
    • D. Circle
    • Discuss
    • 2. Data in operational systems are typically fragmented and inconsistent.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. VBScript is similar to JavaScript.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. The source of the data is sometimes called the system of record.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. All primary keys are required.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Entities use identifiers while tables use keys.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. SOAP is now just a name, not an acronym.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. A function returns one value and has only output parameters.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment