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. 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
    • 2. Total specialization is represented by double lines between the supertype and subtype on an EER.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

    • Options
    • A. Null status
    • B. Data type
    • C. Default value
    • D. Data constraints
      • Discuss
    • 4. In 1:N relationships, which entity becomes the parent entity is arbitrary.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

    • Options
    • A. Read committed
    • B. Read uncommitted
    • C. Repeatable read
    • D. Serializable
      • Discuss
    • 6. In a relation, the order of the rows matters.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A transitive dependency is which of the following?

    • Options
    • A. A functional dependency between two or more key attributes.
    • B. A functional dependency between two or more nonkey attributes.
    • C. A relation that is in first normal form.
    • D. A relation that is in second normal form.
      • Discuss
    • 8. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A distributed database can use which of the following strategies?

    • Options
    • A. Totally centralized at one location and accessed by many sites
    • B. Partially or totally replicated across sites
    • C. Partitioned into segments at different sites
    • D. All of the above
      • Discuss
    • 10. There is one physical schema for each logical schema.

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