Skip to main content

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

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


Labels:

Comments

Post a Comment

Popular posts from this blog

Top 5 Safe Chat Apps for Kids with Parental Controls

Now a days kids are growing up with technology at their fingertips. While communication apps help children stay connected with family and friends, safety remains a top concern for parents. Unregulated platforms can expose children to inappropriate content, online predators, and cyberbullying. That’s why choosing a kid-friendly chat app with parental controls is essential. To help parents find the best options, we’ve compiled a list of the top five safest chat apps for kids that offer safe and controlled environment. 1. Messenger Kids (By Meta) Best for: Safe video calls and text messaging with parental supervision Features: Parents approve all contacts No ads or in-app purchases Fun filters, stickers, and games Monitored messaging and activity reports Why It’s Safe: Messenger Kids is designed for children under 13 and requires parental approval for every contact. Parents can monitor chats and control screen time through the Parent Dashboard. Download Messenger Kids 2...
Post a Comment
Read more

10 Distance Vector and Link-State Routing MCQ

  10 multiple-choice questions  on  Distance Vector and Link-State Routing with explanations, useful for  UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Basic Concept of Distance Vector Routing Q1: In a distance vector routing protocol, how do routers share routing information? A) By flooding the entire network with routing updates B) By periodically exchanging routing tables with their immediate neighbors C) By using a link-state database to determine the shortest path D) By dynamically updating paths based on link failure reports Answer: B) By periodically exchanging routing tables with their immediate neighbors Explanation: In Distance Vector Routing, routers share their routing tables with neighbors at regular intervals, leading to a simple but slow convergence mechanism. Question 2: Example of Distance Vector Routing Protocol Q2: Which of the following is an example of a Distance Vector routing protocol? A) OSPF ...
Post a Comment
Read more

10 Routing Protocol MCQ

10 multiple-choice questions on Routing protocol s  with explanations, useful for UGC NET, SET, GATE, ISRO, and other competitive exams . Question 1: Purpose of Routing Protocols Q1: What is the primary purpose of a routing protocol? A) To assign IP addresses to devices B) To determine the best path for data packets to reach their destination C) To encrypt data during transmission D) To physically connect different networks Answer: B) To determine the best path for data packets to reach their destination Explanation: Routing protocols help routers determine the most efficient path for data transmission across a network, ensuring fast and reliable communication. Question 2: Classification of Routing Protocols Q2: Routing protocols can be broadly classified into which two main categories? A) TCP and UDP B) Distance Vector and Link-State C) IPv4 and IPv6 D) Static and Dynamic Answer: B) Distance Vector and Link-State Explanation: Routing prot...
Post a Comment
Read more