DBMS MCQ Questions and Answers Quiz

51. Which are the two ways in which entities can participate in a relationship?

  1. Passive and active
  2. Total and partial
  3. Simple and Complex
  4. All of the above

52. In the architecture of a database system external level is the

  1. physical level.
  2. logical level.
  3. conceptual level
  4. view level.

53. _____________ function divides one numeric expression by another and returns theremainder.

  1. POWER
  2. MOD
  3. ROUND

54. Which of the operations constitute a basic set of operations for manipulating relational data?

  1. Predicate calculus
  2. Relational calculus
  3. Relational algebra
  4. None of the above

55. Key to represent relationship between tables is called

  1. Primary key
  2. Secondary Key
  3. Foreign Key
  4. None of these

56. Relational calculus is a

  1. Procedural language.
  2. Non- Procedural language.
  3. Data definition language.
  4. High level language.

57. Transaction processing is associated with everything below except

  1. producing detail, summary, or exception reports.
  2. recording a business activity.
  3. confirming an action or triggering a response.
  4. maintaining data.

58. Which of the following operation is used if we are interested in only certain columns of atable?

  3. UNION
  4. JOIN

59. _________ data type can store unstructured data

  1. RAW
  2. CHAR

60. In an E-R diagram attributes are represented by

  1. rectangle.
  2. square.
  3. ellipse.
  4. triangle.

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....