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 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: 9Correct 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. |
Q: 10An organized collection of logically related data is called—
Option C
An organized collection of logically related data is called a Database. A database is designed to efficiently store, manage, and retrieve large amounts of data.
A Student database stores data like name, roll number, class, fees, marks, percentage, all related to Students.
Q: 11The view of the total database content is
Option A
In DBMS, data is represented using the three-level architecture, which includes External View, Conceptual View, and Internal (Physical) View. Each level provides a different perspective of the database.
The Conceptual View represents the entire database as a whole, including all entities, relationships, and constraints. It provides a global view of the complete database content, independent of how data is physically stored or how users access it.
| VIEW TYPE | DESCRIPTION |
|---|---|
| External View | Shows only user-specific part of the database. |
| Conceptual View | Represents complete logical structure of entire database. |
| Internal / Physical View | Describes how data is actually stored in memory. |
Q: 12Data about data is consider as:
Option A
Metadata means data that describes other data. It provides information such as data type, size, format, constraints, and meaning of the actual data stored in a database.
Q: 13A _________ consists of linked tables that form one overall data structure.
Option A
A Database System is a collection of interrelated or linked tables that together form a single, integrated data structure. These tables are connected through relationships such as primary keys and foreign keys, allowing data to be stored efficiently and accessed easily.
Q: 14In context of the major disadvantages of file processing system over database system, consider the following statements :
I. The same information may be duplicated in several files; and this problem is known redundancy.
II. The various copies of the same data may no longer agree; and this problem is known as data inconsistency.
Which of the above statement(s) is/are true?
Option C
In a traditional File Processing system, data is stored in separate files for different applications. Since there is no central control or integration like in a Database Management System (DBMS), several problems can occur.
| DISADVANTAGE | DESCRIPTION | EXAMPLE |
|---|---|---|
| Data Redundancy | Same data is stored in multiple files, leading to unnecessary duplication. | Student’s name and address stored in both Student and Fee files. |
| Data Inconsistency | Different copies of the same data may not match if one is updated and others are not. | One file shows old mobile number, another shows new. |
| Data Isolation | Data is scattered in separate files and formats, making it hard to access and combine. | The marks data in one file and attendance data in another cannot be easily linked. |
| Lack of Data Security | No centralized control, any user can access or modify files without restrictions. | Unauthorized user changes salary details in an employee file. |
| Difficulty in Data Access | Retrieving specific information often requires writing complex programs. | To find top 3 students, separate programs must be written for each file. |
| Integrity Problems | Rules or constraints are difficult to enforce across files. | Two students may accidentally get the same roll number. |
| Concurrency Issues | Multiple users accessing the same file simultaneously can cause data conflicts. | Two clerks update the same record at the same time, leading to errors. |
| Poor Backup and Recovery | No automatic system for restoring data after crashes or failures. | If a file is deleted, recovery is difficult or impossible. |
Q: 15What is the primary difference between a schema and an instance in a database?
Option C
The Schema refers to the overall design or structure of the database, defining how data is organized, such as the tables, fields, and relationships among them. It acts as a blueprint and usually remains unchanged over time.
An Instance represents the actual data stored in the database at a particular point in time. Since data is constantly being inserted, updated, or deleted, instances change frequently.
Therefore, the primary difference is that the schema defines the structure, while the instance represents the data.
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 |
|---|