DBMS MCQ Questions and Answers Quiz

61. The full form of DDL is

  1. Dynamic Data Language
  2. Detailed Data Language
  3. Data Definition Language
  4. Data Derivation Language

62. In E-R Diagram derived attribute are represented by

  1. Ellipse
  2. Dashed ellipse
  3. Rectangle
  4. Triangle

63. In E-R Diagram relationship type is represented by

  1. Ellipse
  2. Dashed ellipse
  3. Rectangle
  4. Diamond

64. In E-R diagram generalization is represented by

  1. Ellipse
  2. Dashed ellipse
  3. Rectangle
  4. Triangle

65. Which of the following is a comparison operator in SQL?

  1. Equals To
  2. LIKE
  3. BETWEEN
  4. All of the above

66. Which database level is closest to the users?

  1. External
  2. Internal
  3. Physical
  4. Conceptual

67. In a Hierarchical model records are organized as

  1. Graph.
  2. List.
  3. Links.
  4. Tree.

68. The method in which records are physically stored in a specified order according to a keyfield in each record is

  1. hash.
  2. direct.
  3. sequential.
  4. all of the above.

69. The database schema is written in

  1. HLL
  2. DML
  3. DDL
  4. DCL

70. Conceptual design

  1. is a documentation technique.
  2. needs data volume and processing frequencies to determine the size of the database.
  3. involves modelling independent of the DBMS.
  4. is designing the relational model.
Tags

MCQ Multiple Choice Questions and Answers on DBMS

DBMS Trivia Questions and Answers PDF

DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....