logo

CuriousTab

CuriousTab

Discussion

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

  • A functional dependency is always an equation.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • More questions

    • 1. A subtype discriminator is which of the following?

    • Options
    • A. An attribute of the supertype whose values determine the subtype
    • B. An attribute of the subtype whose values determine the supertype
    • C. An attribute of the supertype whose values determine the supertype
    • D. An attribute of the subtype whose values determine the subtype
      • Discuss
    • 2. A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):

    • Options
    • A. INSTEAD OF trigger.
    • B. BEFORE trigger.
    • C. AFTER trigger.
    • D. BEGIN trigger.
      • Discuss
    • 4. A data warehouse administrator is concerned with which of the following?

    • Options
    • A. The time to make a decision but not the typical roles of a database administrator
    • B. The time to make a decision and the typical roles of a database administrator
    • C. The typical roles of a data administrator and redesigning existing applications
    • D. The typical roles of a database administrator and redesigning existing applications
      • Discuss
    • 5. MySQL is just as powerful as Oracle and is half the price.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Client/server security includes which of the following?

    • Options
    • A. Physical security
    • B. Change control security
    • C. Measures taken to secure all systems
    • D. All of the above.
      • Discuss
    • 7. In ODBC, a data source that is local to a single computer is called a:

    • Options
    • A. system data source.
    • B. file data source.
    • C. user data source.
    • D. SQL text file.
      • Discuss
    • 8. When mapping a supertype/subtype relationship which of the following is true?

    • Options
    • A. The supertype primary key is assigned to each subtype.
    • B. The subtype primary key is assigned to each supertype.
    • C. There is no link between the supertype/subtype entities.
    • D. There is no primary key/foreign key relationship between a supertype/subtype.
      • Discuss
    • 9. A subtype entity is a special case of another entity called a supertype entity.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. A correlated subquery is where the outer query depends on data from the inner query.

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