logo

CuriousTab

CuriousTab

Discussion

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

  • With SQL Server optimistic locking, an update lock is placed on the row when the row is read.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • More questions

    • 1. Structured data may include which of the following?

    • Options
    • A. Photo image
    • B. Video clip
    • C. Dates
    • D. None of the above.
      • Discuss
    • 2. Which of the following is not a restriction for a table to be a relation?

    • Options
    • A. The cells of the table must contain a single value.
    • B. All of the entries in any column must be of the same kind.
    • C. The columns must be ordered.
    • D. No two rows in a table may be identical.
      • Discuss
    • 3. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?

    • Options
    • A. Null status
    • B. Data type
    • C. Default value
    • D. Data constraints
      • Discuss
    • 4. You can check on the status of tables with the DESCRIBE or DESC command.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Which of the following applies to a class rather than an object?

    • Options
    • A. Query
    • B. Update
    • C. Scope
    • D. Constructor
      • Discuss
    • 6. JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Which of the following do you need to consider when you make a table in SQL?

    • Options
    • A. Data types
    • B. Primary keys
    • C. Default values
    • D. All of the above.
      • Discuss
    • 8. In all cases, normalization into BCNF is desirable.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. C++ is an object-oriented language and is simpler than Java.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

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