logo

CuriousTab

CuriousTab

Discussion

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

  • An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:


  • Options
  • A. COBOL.
  • B. VB.NET.
  • C. TRANSACT SQL.
  • D. Visual Basic.

  • Correct Answer
  • TRANSACT SQL. 

    • More questions

    • 1. 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
    • 2. 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
    • 3. You can check on the status of tables with the DESCRIBE or DESC command.

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

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. 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
    • 7. In all cases, normalization into BCNF is desirable.

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

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The ODBC core API consists of which of the following functions?

    • Options
    • A. Commit or rollback transactions only
    • B. Connect to data sources with driver-specific information only
    • C. Connect to data sources only
    • D. Both 1 and 3 above are in the OBDC core API.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.