logo

CuriousTab

CuriousTab

Discussion


Home Database Introduction to SQL See What Others Are Saying!
  • Question
  • SUM, AVG, MIN, and MAX can only be used with numeric columns.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 


  • More questions

    • 1. A shared database should:

    • Options
    • A. be accurate and available.
    • B. provide for backup and recovery.
    • C. be secure.
    • D. All of the above.
    • Discuss
    • 2. Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Most operational systems are based on the use of transient data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. An extranet is which of the following?

    • Options
    • A. The use of Internet protocols with limited access to company data by the company's customers and suppliers.
    • B. The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.
    • C. The use of Internet protocols with limited access to company data by people within an organization.
    • D. The use of Internet protocols with unlimited access to company data by people within an organization.
    • Discuss
    • 5. In OLAP, we are interested in ________ .

    • Options
    • A. levels only
    • B. dimensions only
    • C. measures only
    • D. measures and dimensions
    • Discuss
    • 6. A database management system (DBMS) is a:

    • Options
    • A. hardware system used to create, maintain, and provide controlled access to a database.
    • B. hardware system used to create, maintain, and provide uncontrolled access to a database.
    • C. software system used to create, maintain, and provide controlled access to a database.
    • D. software system used to create, maintain, and provide uncontrolled access to a database.
    • Discuss
    • 7. Which of the following indicates the minimum number of entities that must be involved in a relationship?

    • Options
    • A. Minimum cardinality
    • B. Maximum cardinality
    • C. ERD
    • D. Greater Entity Count (GEC)
    • Discuss
    • 8. Features of XML include which of the following?

    • Options
    • A. The tags are used to describe the appearance of the content.
    • B. Addresses the structuring and manipulation of the data involved.
    • C. Governs the display of information in a Web browser.
    • D. All of the above.
    • Discuss
    • 9. The Enterprise tier of the three-tiered database architecture includes:

    • Options
    • A. managing the data.
    • B. managing the User-system interface.
    • C. processing HTTP protocol.
    • D. processing scripting tasks.
    • Discuss
    • 10. Transient data is which of the following?

    • Options
    • A. Data in which changes to existing records cause the previous version of the records to be eliminated
    • B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
    • C. Data that are never altered or deleted once they have been added
    • D. Data that are never deleted once they have been added
    • Discuss


    Comments

    There are no comments.

Enter a new Comment