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

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. Database management systems are intended to

  • (A) eliminate data redundancy
  • (B) establish relationship among records in different files
  • (C) manage file access and maintain data integrity
  • (D) all of the options

A

Admin • 833.24K Points
Coach

Q. The language used application programs to request data from the DBMS is referred to as the

  • (A) ddl
  • (B) all of the options
  • (C) dml
  • (D) query language

A

Admin • 833.24K Points
Coach

Q. In a large DBMS

  • (A) each subschema contains every field in the logical schema
  • (B) each user can access every subschema
  • (C) none of the options
  • (D) each user can "see" only a small part of the entire database

A

Admin • 833.24K Points
Coach

Q. Which of the following is not binary operation?

  • (A) union
  • (B) project
  • (C) set difference
  • (D) cartesian product

A

Admin • 833.24K Points
Coach

Q. Which of the following is correct regarding Aggregate functions?

  • (A) it takes a list of values and return a single values as result
  • (B) it takes a list of values and return a list of values as result
  • (C) it takes a single value and returns a list of values as result
  • (D) it takes a single value and returns a single value as result

A

Admin • 833.24K Points
Coach

Q. A command to remove a relation from an SQL database

  • (A) delete table
  • (B) drop table
  • (C) erase table
  • (D) alter table

A

Admin • 833.24K Points
Coach

Q. which of the following is not an Aggregate function?

  • (A) min
  • (B) max
  • (C) select
  • (D) avg

A

Admin • 833.24K Points
Coach

Q. The attribute that can be divided into other attributes is called

  • (A) simple attribute
  • (B) composite attribute
  • (C) multi-valued attribute
  • (D) derived attribute

A

Admin • 833.24K Points
Coach

Q. In an Entity-Relationship Diagram “Ellipses” represents

  • (A) attributes
  • (B) weak entity set
  • (C) relationship sets
  • (D) multi-valued attributes

A

Admin • 833.24K Points
Coach

Q. In an Entity-Relationship Diagram “Diamonds” represents

  • (A) attributes
  • (B) multi-valued attributes
  • (C) weak entity set
  • (D) relationship sets

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.