logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
  • Question

  • To define what columns should be displayed in an SQL SELECT statement:


  • Options
  • A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
  • B. use USING to name the source table(s) and list the columns to be shown after SELECT.
  • C. use SELECT to name the source table(s) and list the columns to be shown after USING.
  • D. use USING to name the source table(s) and list the columns to be shown after WHERE.

  • Correct Answer
  • use FROM to name the source table(s) and list the columns to be shown after SELECT. 

    • More questions

    • 1. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

    • Options
    • A. ONLY
    • B. UNIQUE
    • C. DISTINCT
    • D. SINGLE
      • Discuss
    • 3. A composite attribute does not get mapped into a relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. A collection of literals or object types is called a bag.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. SQL Server indexes are special data structures used to improve performance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A recursive relationship is a relationship between an archetype and an instance of that archetype.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Data processing logic includes such activities as data validation and identification of processing errors.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Total specialization is represented by double lines between the supertype and subtype on an EER.

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