Database Management System (DBMS) MCQs with answers Page - 148

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. In the process of decomposition is called as

  • (A) Normalization
  • (B) Generalization
  • (C) Aggregation
  • (D) Specalization

A

Admin • 833.24K Points
Coach

Q. A relation Schema R is in ……….. if it is in 3NF and satisfies an additional constant thatfor every FD X->A. X must be a candidate key.

  • (A) 1 NF
  • (B) 2 NF
  • (C) 3 NF
  • (D) BCNF

A

Admin • 833.24K Points
Coach

Q. A relation between 2 set of attributes is called as

  • (A) Join dependency
  • (B) Association
  • (C) Functional Dependency
  • (D) Multivalued dependency

A

Admin • 833.24K Points
Coach

Q. In 1NF, the value of the attribute must be

  • (A) Atomic
  • (B) Single
  • (C) Multivalued
  • (D) Null

A

Admin • 833.24K Points
Coach

Q. The process of Normalization is

  • (A) Iterative
  • (B) Non-reversible
  • (C) Reversible
  • (D) None

A

Admin • 833.24K Points
Coach

Q. Which normal form is most desirable ?

  • (A) DKNF
  • (B) 3 NF
  • (C) BCNF
  • (D) 4 NF

A

Admin • 833.24K Points
Coach

Q. A functional dependency is a relationship between

  • (A) Tables
  • (B) Columns
  • (C) Attributes
  • (D) Rows

A

Admin • 833.24K Points
Coach

Q. Two or more attributes that can be a key are called :

  • (A) determinants
  • (B) primary key
  • (C) Composite key
  • (D) foreign key

A

Admin • 833.24K Points
Coach

Q. Cartesian product in relational algebra is

  • (A) a Unary operator.
  • (B) a Binary operator.
  • (C) a Ternary operator
  • (D) not defined

A

Admin • 833.24K Points
Coach

Q. In the relational modes, cardinality is termed as:

  • (A) Number of tuples.
  • (B) Number of attributes.
  • (C) Number of tables.
  • (D) Number of constraints.

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.