10 multiple-choice questions related to Database Management Systems (DBMS):

on

Here are 10 multiple-choice questions related to Database Management Systems (DBMS) with their answers:

Question 1: Definition of DBMS

Q1: A Database Management System (DBMS) is primarily used for:

  • A) Data processing
  • B) Managing databases
  • C) Compiling programs
  • D) Controlling hardware devices

Answer: B) Managing databases

Question 2: Types of DBMS

Q2: Which of the following is NOT a type of DBMS?

  • A) Hierarchical
  • B) Network
  • C) Relational
  • D) Graphical

Answer: D) Graphical

Question 3: SQL

Q3: SQL stands for:

  • A) Standard Query Language
  • B) Sequential Query Language
  • C) Structured Query Language
  • D) Simple Query Language

Answer: C) Structured Query Language

Question 4: Primary Key

Q4: In a relational database, a primary key is:

  • A) A unique identifier for each record
  • B) A field that allows duplicate values
  • C) A field that stores large text
  • D) A field that links to another table

Answer: A) A unique identifier for each record

Question 5: Normalization

Q5: The process of organizing data to reduce redundancy is called:

  • A) Denormalization
  • B) Normalization
  • C) Encapsulation
  • D) Segmentation

Answer: B) Normalization

Question 6: ACID Properties

Q6: Which of the following is NOT one of the ACID properties of a transaction?

  • A) Atomicity
  • B) Consistency
  • C) Isolation
  • D) Distribution

Answer: D) Distribution

Question 7: JOIN Operation

Q7: A JOIN operation in SQL is used to:

  • A) Combine rows from two or more tables based on a related column
  • B) Remove rows from a table
  • C) Update rows in a table
  • D) Create a new table

Answer: A) Combine rows from two or more tables based on a related column

Question 8: Foreign Key

Q8: A foreign key is:

  • A) A unique identifier in the same table
  • B) A unique identifier in a different table
  • C) A field that uniquely identifies a record in another table
  • D) A primary key in the same table

Answer: C) A field that uniquely identifies a record in another table

Question 9: Indexes

Q9: Indexes in a database are used to:

  • A) Store large binary data
  • B) Improve the speed of data retrieval operations
  • C) Ensure data integrity
  • D) Link different tables

Answer: B) Improve the speed of data retrieval operations

Question 10: ER Model

Q10: An Entity-Relationship (ER) model is primarily used for:

  • A) Database normalization
  • B) Designing and modeling a database
  • C) Writing SQL queries
  • D) Backup and recovery

Answer: B) Designing and modeling a database


Comments

Post a Comment