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

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. The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

  • (A) bcnf algorithm
  • (B) 2nf algorithm
  • (C) 3nf synthesis algorithm
  • (D) 1nf algorithm

A

Admin • 833.24K Points
Coach

Q. Which normal form is considered adequate for normal relational database design?

  • (A) 2nf
  • (B) 5nf
  • (C) 4nf
  • (D) 3nf

A

Admin • 833.24K Points
Coach

Q. Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

  • (A) zero
  • (B) more than zero but less than that of an equivalent 3nf decomposition
  • (C) proportional to the size of f+
  • (D) indeterminate

A

Admin • 833.24K Points
Coach

Q. Which of the normal form is based on multivalued dependencies?

  • (A) first
  • (B) second
  • (C) third
  • (D) fourth

A

Admin • 833.24K Points
Coach

Q. Html document must always be saved with:

  • (A) .html
  • (B) .htm
  • (C) .doc
  • (D) both .html & .htm

A

Admin • 833.24K Points
Coach

Q. How many levels of headings are in html:

  • (A) 2
  • (B) 7
  • (C) 6
  • (D) 4

A

Admin • 833.24K Points
Coach

Q. The Java specification defines an application programming interface for communication between the Web server and the application program.

  • (A) servlet
  • (B) server
  • (C) program
  • (D) randomize

A

Admin • 833.24K Points
Coach

Q. How many JDBC driver types does Sun define?

  • (A) one
  • (B) two
  • (C) three
  • (D) four

A

Admin • 833.24K Points
Coach

Q. Which JDBC driver Type(s) can be used in either applet or servlet code?

  • (A) both type 1 and type 2
  • (B) both type 1 and type 3
  • (C) both type 3 and type 4
  • (D) type 4 only

A

Admin • 833.24K Points
Coach

Q. What MySQL property is used to create a surrogate key in MySQL?

  • (A) unique
  • (B) sequence
  • (C) auto_increment
  • (D) none of the mentioned

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.