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. |
Q: 11An 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: 12The 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: 13Data 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: 14A _________ 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: 15In 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. |
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 |
|---|