DBMS MCQ (Multiple Choice Questions and Answers)

DBMS MCQ (Multiple Choice Questions and Answers)

11. Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

  1. DML(Data Manipulation Language)
  2. Query
  3. Relational Schema
  4. DDL(Data Definition Language)

Answer : A
Explanation: The term “DML” stands for the Data Manipulation Language used to perform the required changes in the relation’s values and hence, Option A is correct.

12. What are the different view to present a Table?

  1. Pivote TableView
  2. Design View
  3. Datasheet View
  4. All Of Above

Answer : D
Explanation: Different view to present a table are: Pivote TableView, Design View, Datasheet View.

13. E-R model uses this symbol to represent weak entity set

  1. Diamond
  2. Dotted Rectangle
  3. Doubly Outlined Rectangle
  4. None Of These

Answer : C
Explanation: E-R model uses Doubly Outlined Rectangle 13. E-R model uses this symbol to represent weak entity set.

14. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

  1. Candidate key
  2. Sub key
  3. Foreign key
  4. Super key

Answer : D
Explanation: Super key is a set of one or more attributes taken collectively to uniquely identify a record. So option D is correct.

15. A top-to-bottom relationship among the items in a database is established by a

  1. Hierarchical schema
  2. Network schema
  3. Relational Schema
  4. All of the above

Answer : A
Explanation: A top-to-bottom relationship among the items in a database is established by a Hierarchical schema. So option A is correct.

16. A transaction completes its execution is said to be

  1. Saved
  2. Committed
  3. Loaded
  4. Rolled

Answer : B
Explanation: None.

17. ROLLBACK in a database is ____ statement.

  1. DDL
  2. DML
  3. TCL
  4. DCL

Answer : C
Explanation: ROLLBACK in a database is TCL statement.

18. The data model which describes how the data is actually stored is:

  1. Internal Model
  2. Logical Model
  3. External Model
  4. None Of These

Answer : A
Explanation: The data model which describes how the data is actually stored is reffered as internal model. So option A is correct.

19. A Database Management System is a type of ___________ software.

  1. It is a kind of application software
  2. It is a type of system software
  3. It is a kind of general software
  4. Both B and C

Answer : B
Explanation: The DBMS (also called Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well and hence only statement B is correct.

20. The file organization that provides very fast access to any arbitrary record of a file is:

  1. Ordered file
  2. Unordered file
  3. B-Tree
  4. Hashed file

Answer : D
Explanation: The file organization that provides very fast access to any arbitrary record of a file is hashed file. SO, option D is correct.

Pages: 1 2 3

This Post Has 3 Comments

Leave a Reply