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

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 completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?

  • (A) total
  • (B) partial
  • (C) should be specified
  • (D) cannot be determined

A

Admin • 833.24K Points
Coach

Q. Functional dependencies are a generalization of

  • (A) key dependencies
  • (B) relation dependencies
  • (C) database dependencies
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following is another name for a weak entity?

  • (A) child
  • (B) owner
  • (C) dominant
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which is the main relation which is used in the university database which is referenced by all other relation of the university?

  • (A) teaches
  • (B) course
  • (C) department
  • (D) section

A

Admin • 833.24K Points
Coach

Q. The department relation has the an entry budget whose type has to be replaced by

  • (A) varchar (20)
  • (B) varchar2 (20)
  • (C) numeric (12,2)
  • (D) numeric

A

Admin • 833.24K Points
Coach

Q. In the above DDL command the foreign key entries are got by using the keyword

  • (A) references
  • (B) key reference
  • (C) relating
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Identify the error in the section relation

  • (A) no error
  • (B) year numeric (4,0)
  • (C) building varchar (15)
  • (D) sec_id varchar (8)

A

Admin • 833.24K Points
Coach

Q. Which of the following can be used as a primary key entry of the instructor relation.

  • (A) dept_name
  • (B) name
  • (C) id
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. In the section relation which of the following is used as a foreign key?

  • (A) course_id
  • (B) course_id,sec_id
  • (C) room_number
  • (D) course_id,sec_id,room_number

A

Admin • 833.24K Points
Coach

Q. To replace the relation section with some other relation the initial step to be carried out is

  • (A) delete section;
  • (B) drop section;
  • (C) delete from section;
  • (D) replace section new_table ;

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.