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

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. Which of the following is a valid SQL type?

  • (A) CHARACTER
  • (B) NUMERIC
  • (C) FLOAT
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is a legal expression in SQL?

  • (A) SELECT NULL FROM EMPLOYEE;
  • (B) SELECT NAME FROM EMPLOYEE;
  • (C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
  • (D) none of the above

A

Admin • 833.24K Points
Coach

Q. If every non-key attribute is functionally dependent on the primary key, then the relation will be in:

  • (A) First normal form
  • (B) Second normal form
  • (C) Third normal form
  • (D) Fourth normal form

A

Admin • 833.24K Points
Coach

Q. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?

  • (A) X→Z
  • (B) W→Z
  • (C) X→WY
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Relations produced from an E-R model will always be in

  • (A) First normal form
  • (B) Second normal form
  • (C) Third normal form
  • (D) Fourth normal form

A

Admin • 833.24K Points
Coach

Q. Third normal form is inadequate in situation where the relation

  • (A) Has multiple candidate keys
  • (B) Has candidate keys that are composite
  • (C) Has overlapped candidate keys
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. If a relation scheme is in BCNF, then it is also in

  • (A) First normal form
  • (B) Second normal form
  • (C) Third normal form
  • (D) Fourth normal form

A

Admin • 833.24K Points
Coach

Q. A primary key when combined with a foreign key create

  • (A) Parent child relationship between the tables that connect them.
  • (B) Network model between the tables that connect them.
  • (C) Many-to-many relationship between the tables that connect them.
  • (D) None of the above.

A

Admin • 833.24K Points
Coach

Q. The set of permitted value for each attribute is called its

  • (A) Attribute set
  • (B) Attentive range
  • (C) Domain
  • (D) Group

A

Admin • 833.24K Points
Coach

Q. The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is

  • (A) Flight number
  • (B) Flight number + place of departure
  • (C) Flight number+ date
  • (D) Flight number + destination

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.