Home

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

You can do it
  1. DBMS helps achieve
  2. ______is a preferred method for enforcing data integrity
  3. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  4. Which of the following is true for network structure?
  5. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  6. The one guideline to be followed while designing the database is
  7. In 2NF
  8. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  9. In a relational schema, each tuple is divided into fields called
  10. In E-R Diagram total participation is represented by
  11. ____ table store information about database or about the system.
  12. Which of the following addressing modes permits relocation without any change over in the code?
  13. The keyword to eliminate duplicate rows from the query result in SQL is
  14. Which of the following relational algebraic operations is not from set theory?
  15. In SQL, testing whether a subquery is empty is done using
  16. Which one is true statement :
  17. The graphical representation of a query is .
  18. ______contains information that defines valid values that are stored in a column or data type.
  19. The rule that a value of a foreign key must appear as a value of some specific table is called a
  20. Data items grouped together for storage purposes are called a
  21. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  22. Which of the following is not a property of transactions?
  23. Which of the following is not a consequence of concurrent operations?
  24. Relations produced from an E-R model will always be
  25. _____clause is an additional filter that is applied to the result.
  26. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  27. When an E-R diagram is mapped to tables, the representation is redundant for
  28. The data models defined by ANSI/SPARC architecture are
  29. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  30. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are