This section contains carefully selected MCQs and Previous Year Questions with explanations to help students understand concepts and prepare effectively for examinations, interviews, and competitive tests.
Q: 1Which type of database consists of only one table?
Option C
A Flat-File database stores data in a single table or file, usually in a simple format such as a text file or spreadsheet. It does not support relationships between multiple tables. For example, a CSV (Comma Separated Values) file containing student records is a flat-file database.
Q: 2Which of the following describes a major advantage of using a database for storing data?
Option A
One of the major advantages of using a database for storing data is that it ensures accuracy, consistency, and integrity of data. A database system uses integrity constraints, controlled access, and centralized management to maintain data in a reliable form.
Q: 3DBMS stands for?
Option B
A Database Management System (DBMS) is software that allows users to create, manage, and access databases efficiently. It helps in storing, organizing, and retrieving data in a structured way.
Q: 4Which database design is independent of both software and hardware?
Option B
At the Conceptual Level, the focus is on the overall structure, entities, relationships, and constraints, without considering how the database will be implemented in any specific DBMS or on any particular hardware.
Q: 5The level of data abstraction that describes what data is stored and the relationships among the data is called the:
Option C
The Conceptual Level of data abstraction describes what data is stored in the database and what relationships exist among that data.
At this level, the focus is on the overall logical structure of the database, such as entities, attributes, and relationships, without worrying about how the data is physically stored on disk.
The conceptual level is also called the logical level in a database management system.
Q: 6The set of permitted values for each attribute in a database is called the:
Option C
In DBMS, a domain defines the allowed set of values that an attribute can take. It specifies the data type, size, format, and possible range of values for an attribute.
E.g.:
Q: 7Which of the following is NOT an element of Database?
Option A
A database is an organized collection of related data. Different elements are used in a database to define its structure, rules, and relationships.
However, Frontend is not a database element. Frontend refers to the user interface or application part through which users interact with the system.
Q: 8Which of the following is not a valid category of database management system?
Option B
A Database Management System (DBMS) is software used to create, store, retrieve, update, and manage data efficiently. Based on the way data is organized and related, DBMSs are classified into different categories or database models.
Common DBMS:
A Sequential organization refers to a file organization or file access method, where records are stored one after another in sequence. It is not a category of DBMS.
Q: 9Which of the following places the common data elements in order from smallest to largest?
Option C
| DATA ELEMENT | DESCRIPTION |
|---|---|
| Bit | The smallest unit of data. It can store only one value either 0 or 1. |
| Byte / Character | A group of 8 bits that represents a single character such as A, 9, or %. |
| Field | A collection of characters that represents one attribute, for example, Name or DOB. |
| Record | A collection of related fields that stores complete information about one entity. |
| Table | A collection of related records organized in rows and columns. |
| Database | A structured collection of related tables stored and managed together. |
| Data Warehouse | A very large storage system that collects data from multiple databases for analysis and decision-making. |
HIERARCHY ORDER:
Bit < Byte (Character) < Field < Record < Table < Database < Data Warehouse
Q: 10Correct order of database abstraction levels, from the highest level of abstraction to the lowest level of abstraction is:
Option B
In a database management system, the three levels of data abstraction are organized to simplify data management and improve security.
| ABSTRACTION LEVEL | DESCRIPTION | PURPOSE |
|---|---|---|
| View Level | Highest level of abstraction. It shows how users interact with data through customized views that hide complexity. | Used by end users and application programs to access only relevant data. |
| Logical Level | Describes what data is stored in the database and relationships among them. Defines schema, tables, fields, and constraints. | Used by database designers and DBAs to design overall database structure. |
| Physical Level | Lowest level of abstraction. It describes how data is physically stored on disk (files, blocks, indexes). | Used by system administrators and DBMS software to optimize performance and storage. |
Thank you so much for taking the time to read my Computer Science MCQs section carefully. Your support and interest mean a lot, and I truly appreciate you being part of this journey. Stay connected for more insights and updates! If you'd like to explore more tutorials and insights, check out my YouTube channel.
Don’t forget to subscribe and stay connected for future updates.
| Student Name | |
|---|---|
| College |
| What's Say |
|---|