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

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 Rectangles divided into two parts represents

  • (A) entity set
  • (B) relationship set
  • (C) attributes of a relationship set
  • (D) primary key

A

Admin • 833.24K Points
Coach

Q. We indicate roles in E-R diagrams by labeling the lines that connect to

  • (A) diamond , diamond
  • (B) rectangle, diamond
  • (C) rectangle, rectangle
  • (D) diamond, rectangle

A

Admin • 833.24K Points
Coach

Q. An entity set that does not have sufficient attributes to form a primary key is termed a

  • (A) strong entity set
  • (B) variant set
  • (C) weak entity set
  • (D) variable set

A

Admin • 833.24K Points
Coach

Q. Weak entity set is represented as

  • (A) underline
  • (B) double line
  • (C) double diamond
  • (D) double rectangle

A

Admin • 833.24K Points
Coach

Q. If you were collecting and storing information about your music collection, an album would be considered a(n)

  • (A) relation
  • (B) entity
  • (C) instance
  • (D) attribute

A

Admin • 833.24K Points
Coach

Q. Which one of the following can be treated as a primary key in teaches relation?

  • (A) id
  • (B) semester
  • (C) sec_id
  • (D) year

A

Admin • 833.24K Points
Coach

Q. The primary key in the section relation is

  • (A) course_id
  • (B) sec_id
  • (C) both course_id and sec_id
  • (D) all the attributes

A

Admin • 833.24K Points
Coach

Q. The relation with primary key can be created using

  • (A) create table instructor (id, name)
  • (B) create table instructor (id, name, primary key(name))
  • (C) create table instructor (id, name, primary key (id))
  • (D) create table instructor ( id unique, name )

A

Admin • 833.24K Points
Coach

Q. How can the values in the relation teaches be deleted?

  • (A) drop table teaches;
  • (B) delete from teaches;
  • (C) purge table teaches;
  • (D) delete from teaches where id =’null’;

A

Admin • 833.24K Points
Coach

Q. In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?

  • (A) 2
  • (B) 4
  • (C) 5
  • (D) 1

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.