Database Management System - DBMS Quiz Question with Answer

41. When a program is abnormally terminated, the equivalent of a ……………… command occurs.

  1. QUIT
  4. EXIT

42. The method of access which uses key transformation is known as

  1. Random
  2. Direct
  3. Hashing
  4. Sequential

43. Which rules are defined in relational models they from as an essential part of any relation database:

  1. Record
  2. Integrity rules
  3. Database
  4. Memory

44. 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):

  1. Referential integrity constraint.
  2. Transitive dependency
  3. Insertion anomaly.
  4. Normal form

45. A top-to-bottom relationship among the items in a database is established by a

  1. Relational Schema
  2. Hierarchical schema
  3. Network schema
  4. All of the above

46. A functional dependency is a relationship between or among:

  1. Relations
  2. Tables
  3. Rows
  4. Attributes

47. In RDBMS, Data is presented as a collection of ............

  1. Relations
  2. Table
  3. Attributes
  4. Entities

48. In RDBMS, Data is presented as a collection of............

  1. Relations
  2. Table
  3. Attributes
  4. Entities

49. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

  1. Relations
  2. Fields
  3. Records
  4. Keys

50. In an ER model, …………… is described in the database by storing its data.

  1. Relationship
  2. Entity
  3. Attribute
  4. Notation

Tags :

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....