Home

The rule that a value of a foreign key must appear as a value of some specific table is called a

A. Referential constraint.

B. Index.

C. Integrity constraint.

D. Functional dependency.

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. The default level of consistency in SQL is
  2. Which of the following addressing modes permits relocation without any change over in the code?
  3. The normalization was first proposed by .
  4. Protection of data from unauthorized Disclosure results in loss of _______
  5. An advantage of views is
  6. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  7. In E-R Diagram total participation is represented by
  8. The statement that is executed automatically by the system as a side effect of the modification of the…
  9. _____ database is used to provide statistical information or summaries of values based on various criteria.
  10. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  11. The clause alter table in SQL can be used to
  12. What is a disjoint less constraint?
  13. ____ table store information about database or about the system.
  14. As per equivalence rules for query transformation, selection operation distributes over
  15. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  16. The data in the database at a particular moment of time is called the _______
  17. A _____ is used to define overall design of the database
  18. When an E-R diagram is mapped to tables, the representation is redundant for
  19. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  20. A transaction is in state after the final statement has been executed.
  21. Which normal form is considered adequate for normal relational database design?
  22. Which of the following constitutes a basic set of operations for manipulating relational data?
  23. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  24. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  25. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  26. The one guideline to be followed while designing the database is
  27. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  28. The keyword to eliminate duplicate rows from the query result in SQL is
  29. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  30. Tree structures are used to store data in