INT306 - Database Management System | MCQ SETS | Unit-Wise | 120 Questions

Our specialized question paper database gives you access to a sizable selection of multiple-choice questions (MCQs) on the Database Management System (Course Code: INT306). With the help of this extensive resource, you may better your grasp of the fundamental ideas, guidelines, and methods used in database administration. We have carefully chosen the topics for our database, which include data modeling, normalization, indexing, query optimization, transaction management, and more. Utilize this useful tool to efficiently prepare for examinations, assignments, and evaluations.



1.       What is the purpose of a database system?

a) To store and organize data

b) To perform calculations

c) To create user interfaces

d) To analyze data

Answer: a) To store and organize data

 

2.       Which of the following is a component of a Database Management System (DBMS)?

a) Data modeling

b) Data encryption

c) Data analysis

d) Data visualization

Answer: a) Data modeling

 

3.       Which of the following is an application of a DBMS?

a) Web development

b) Word processing

c) Spreadsheet calculations

d) Customer relationship management

Answer: d) Customer relationship management

 

4.       What does the three-tier architecture in a DBMS refer to?

a) Physical, logical, and conceptual layers

b) User interface, application logic, and database

c) Data modeling, data storage, and data retrieval

d) Relational, hierarchical, and network databases

Answer: b) User interface, application logic, and database

 

5.       What is data independence in the context of databases?

a) The ability to modify data without affecting the database schema

b) The ability to access data remotely over a network

c) The ability to secure data from unauthorized access

d) The ability to recover data after a system failure

Answer: a) The ability to modify data without affecting the database schema

 

6.       What is a database schema?

a) A diagram that represents the structure of a database

b) A set of rules that govern data manipulation in a database

c) A collection of tables in a database

d) A script that creates a database

Answer: a) A diagram that represents the structure of a database

 

7.       What is an instance in the context of databases?

a) A single occurrence of a database schema

b) A backup copy of a database

c) A transaction that modifies data in a database

d) A user account with access to a database

Answer: a) A single occurrence of a database schema

 

8.       What is data modeling in the context of databases?

a) The process of creating a database schema

b) The process of generating random data for testing

c) The process of optimizing database performance

d) The process of representing real-world objects and their relationships in a database

Answer: d) The process of representing real-world objects and their relationships in a database

 

9.       What is the Entity-Relationship (ER) model used for?

a) Representing data in a tabular format

b) Defining the structure of a database schema

c) Describing the relationship between entities in a database

d) Performing complex calculations on database tables

Answer: c) Describing the relationship between entities in a database

 

10.   What is the Relational Model?

a) A model for representing data in a hierarchical structure

b) A model for representing data as a network of interconnected nodes

c) A model for representing data as a collection of tables with relationships

d) A model for representing data as a set of objects and their properties

Answer: c) A model for representing data as a collection of tables with relationships

 

11.   Which of the following is not a component of a Database Management System (DBMS)?

a) Query Language

b) Data Dictionary

c) Data Storage

d) Data Processor

Answer: d) Data Processor

 

12.   What is the purpose of a Data Dictionary in a DBMS?

a) It stores the actual data values in the database.

b) It provides information about the structure and organization of the database.

c) It executes queries and retrieves data from the database.

d) It manages user access and permissions for the database.

Answer: b) It provides information about the structure and organization of the database.

 

13.   Which of the following is an example of a non-relational database model?

a) Hierarchical model

b) Relational model

c) Entity-Relationship model

d) Object-oriented model

Answer: a) Hierarchical model

 

14.   What is the primary key in a database table?

a) A unique identifier for a table

b) A field that stores numeric data

c) A field that stores character data

d) A field that stores date and time values

Answer: a) A unique identifier for a table

 

15.   What is the purpose of referential integrity in a database?

a) To ensure that data is stored in a consistent and valid state

b) To provide secure access control to the database

c) To improve the performance of data retrieval operations

d) To enforce data encryption and decryption in the database

Answer: a) To ensure that data is stored in a consistent and valid state

 

16.   Which of the following is an example of a database management system?

a) MySQL

b) Microsoft Excel

c) Adobe Photoshop

d) Windows Operating System

Answer: a) MySQL

 

17.   What is a primary difference between a database schema and a database instance?

a) The schema defines the structure, while the instance contains actual data.

b) The instance defines the structure, while the schema contains actual data.

c) The schema is used for backup purposes, while the instance is used for data modeling.

d) The instance is specific to a particular user, while the schema is shared among multiple users.

Answer: a) The schema defines the structure, while the instance contains actual data.

 

18.   What does ACID stand for in the context of database transactions?

a) Atomicity, Consistency, Isolation, Durability

b) Association, Categorization, Integration, Documentation

c) Authentication, Confidentiality, Integrity, Disclosure

d) Aggregation, Calculation, Indexing, Deletion

Answer: a) Atomicity, Consistency, Isolation, Durability

 

19.   What is a foreign key in a database table?

a) A key used for encrypting sensitive data

b) A key used to establish relationships between tables

c) A key that uniquely identifies a record in a table

d) A key that determines the sorting order of records in a table

Answer: b) A key used to establish relationships between tables

 

20.   What is data normalization in the context of databases?

a) The process of converting data into a different format

b) The process of removing redundant data and organizing it efficiently

c) The process of backing up data to prevent loss or corruption

d) The process of encrypting data to ensure security and privacy

Answer: b) The process of removing redundant data and organizing it efficiently

إرسال تعليق (0)
أحدث أقدم