logo

CuriousTab

CuriousTab

Discussion

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

  • An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. Apache Web server does not support servlets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

    • Options
    • A. primary key.
    • B. foreign key.
    • C. composite key.
    • D. surrogate key.
      • Discuss
    • 3. If attribute A determines both attributes B and C, then it is also true that:

    • Options
    • A. A ? B.
    • B. B ? A.
    • C. C ? A.
    • D. (B,C) ? A.
      • Discuss
    • 4. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

    • Options
    • A. all columns of the table are to be returned.
    • B. all records meeting the full criteria are to be returned.
    • C. all records with even partial criteria met are to be returned.
    • D. None of the above is correct.
      • Discuss
    • 6. An attribute's value is either a literal or an object identifier.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SUM, AVG, MIN, and MAX can only be used with numeric columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. In a 1:N relationship, the foreign key is placed in:

    • Options
    • A. either table without specifying parent and child tables.
    • B. the parent table.
    • C. the child table.
    • D. either the parent table or the child table.
      • Discuss
    • 10. SQL is a programming language.

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