Home

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

You can do it
  1. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  2. For correct behaviour during recovery, undo and redo operation must be
  3. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  4. ____ table store information about database or about the system.
  5. In SQL the word natural can be used with
  6. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  7. In E-R Diagram total participation is represented by
  8. HSAM stands for .
  9. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  10. An advantage of the database management approach is
  11. What are the desirable properties of a decomposition
  12. DROP is a statement in SQL.
  13. The middleware databases in which the business rules act are applicable to _______ tier architectures
  14. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  15. The rule that a value of a foreign key must appear as a value of some specific table is called a
  16. When an E-R diagram is mapped to tables, the representation is redundant for
  17. The normal form that is not necessarily dependency preserving is
  18. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  19. If an entity can belong to only one lower level entity then the constraint is
  20. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  21. What is a disjoint less constraint?
  22. DBMS helps achieve
  23. Which of the following constitutes a basic set of operations for manipulating relational data?
  24. Which of the following statement on the view concept in SQL is invalid?
  25. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  26. In an ER model,_____ is described in the database by storing its data.
  27. In 2NF
  28. Relations produced from an E-R model will always be
  29. Which of the following is not a recovery technique?
  30. Which of the following ensures the atomicity of the transaction?