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. The terms alternate key and candidate key mean the same thing.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A relation has which of the following properties?

    • Options
    • A. Each row is not unique.
    • B. Attributes can have the same name within a given table.
    • C. Each relation has a unique name.
    • D. The order of the columns is significant.
      • Discuss
    • 3. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

    • Options
    • A. A domain constraint
    • B. A range constraint
    • C. An intrarelation constraint
    • D. An interrelation constraint
      • Discuss
    • 4. In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

    • Options
    • A. One-to-One Relationship
    • B. One-to-Many Relationship
    • C. Many-to-Many Relationship
    • D. Composite Relationship
      • Discuss
    • 5. Which of the following database activities determines the entities, attributes, and relationships of data?

    • Options
    • A. Conceptual data modeling
    • B. Logical database design
    • C. Physical database design and definition
    • D. Database implementation
      • Discuss
    • 6. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

    • Options
    • A. VARCHAR2
    • B. CHAR
    • C. LONG
    • D. NUMBER
      • Discuss
    • 7. The command to remove rows from a table 'CUSTOMER' is:

    • Options
    • A. REMOVE FROM CUSTOMER ...
    • B. DROP FROM CUSTOMER ...
    • C. DELETE FROM CUSTOMER WHERE ...
    • D. UPDATE FROM CUSTOMER ...
      • Discuss
    • 8. ODBC minimum SQL grammar contains which of the following?

    • Options
    • A. INSERT, UPDATE, DELETE only
    • B. Stored Procedures only
    • C. Literals for date, time and timestamp only
    • D. CREATE VIEW, DROP VIEW only
      • Discuss
    • 9. Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. If an XML document does not have a DTD, then by definition it is:

    • Options
    • A. not-type-valid.
    • B. type-valid.
    • C. an HTML document.
    • D. None of the above is correct.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.