logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
  • Question

  • Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?


  • Options
  • A. The multivalue, multicolumn problem
  • B. The inconsistent values problem
  • C. The missing values problem
  • D. The general-purpose remarks column problem

  • Correct Answer
  • The inconsistent values problem 

    • More questions

    • 1. 'dbo' stands for database object.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. SQL is a data sublanguage.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which one of the following symbols is not used in an ERD?

    • Options
    • A. Rectangle
    • B. Oval
    • C. Diamond
    • D. Circle
      • Discuss
    • 4. Data in operational systems are typically fragmented and inconsistent.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. VBScript is similar to JavaScript.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The source of the data is sometimes called the system of record.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. All primary keys are required.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Entities use identifiers while tables use keys.

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