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

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 correct regarding Aggregate functions?

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

A

Admin • 833.24K Points
Coach

Q. The Primary key must be

  • (A) non null
  • (B) unique
  • (C) option a or b
  • (D) option a and b

A

Admin • 833.24K Points
Coach

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

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

A

Admin • 833.24K Points
Coach

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

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

A

Admin • 833.24K Points
Coach

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

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

A

Admin • 833.24K Points
Coach

Q. What is ACID properties of Transactions?

  • (A) atomicity, consistency, isolation, database
  • (B) automatically, concurrency, isolation, durability
  • (C) atomicity, consistency, isolation, durability
  • (D) atomicity, consistency, inconsistent, durability

A

Admin • 833.24K Points
Coach

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

  • (A) fourth formal form
  • (B) third normal form
  • (C) first normal form
  • (D) second normal form

A

Admin • 833.24K Points
Coach

Q. Database locking concept is used to solve the problem of

  • (A) inconsistent data
  • (B) all of the options
  • (C) lost update
  • (D) uncommitted dependency

A

Admin • 833.24K Points
Coach

Q. UML is stands for

  • (A) universal modeling language
  • (B) united modeling language
  • (C) uni modeling language
  • (D) unified modeling language

A

Admin • 833.24K Points
Coach

Q. A record management system

  • (A) can handle many files of information at a time
  • (B) always uses a list as its model
  • (C) both can handle many files of information at a time and always uses a list as its model
  • (D) can be used to extract information stored in a computer file

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.