logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
  • Question

  • When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):


  • Options
  • A. transitive dependency.
  • B. insertion anomaly.
  • C. referential integrity constraint.
  • D. normal form.

  • Correct Answer
  • referential integrity constraint. 

    • More questions

    • 1. OLE DB tabular data providers present data in the form of rowsets.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A tuple is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
      • Discuss
    • 3. Which of the following types of databases are the most common?

    • Options
    • A. Personal
    • B. Workgroup
    • C. Department
    • D. Enterprise
      • Discuss
    • 4. In unsupervised data mining, explanations are created after patterns are found.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Java bytecode is machine-specific code.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A star schema has what type of relationship between a dimension and fact table?

    • Options
    • A. Many-to-many
    • B. One-to-one
    • C. One-to-many
    • D. All of the above.
      • Discuss
    • 7. A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. SQL*Plus will finish the statement and execute it when the user types in this:

    • Options
    • A. A left slash ( \ ) followed by [Enter].
    • B. A colon ( : ) followed by [Enter].
    • C. A semicolon ( ; ) followed by [Enter].
    • D. A period ( . ) followed by [Enter].
      • Discuss
    • 9. Business Intelligence (BI) systems do not obtain data from operational databases.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Centralized systems are more susceptible to security threats than client/server architectures.

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