Computer Science MCQS

Computer Science MCQ with detailed explanations for students & freshers preparing for entrance exams, various tests, interviews, competitive exams like GATE exam, interview, competitive examination and entrance exam.

📚 Table of Content

What is DBMS?

A. a) DBMS is a collection of queries
B. b) DBMS is a high-level language
C. c) DBMS is a programming language
D. d) DBMS stores, modifies and retrieves data
Correct answer is: D. d) DBMS stores, modifies and retrieves data
DBMS stores, modifies, and retrieves data is the correct answer!

A Database Management System (DBMS) is essentially a software application that acts as an intermediary between the user and the database. Its primary functions are:

Storing data: Organizing and saving information in a structured format.

Modifying data: Allowing users to update, change, or delete existing data.

Retrieving data: Enabling users to access and extract specific information from the database.

What is a database?

A. a) Organized collection of information that cannot be accessed, updated, and managed
B. b) Collection of data or information without organizing
C. c) Organized collection of data or information that can be accessed, updated, and managed
D. d) Organized collection of data that cannot be updated
Correct answer is: C. c) Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data or information that can be accessed, updated, and managed is the correct definition of a data.

Organized: Data is structured in a specific way (e.g., tables, records, fields) for efficient retrieval.

Collection: It contains multiple pieces of related information.

Accessed, updated, and managed: The database system allows users to retrieve, modify, and control the data within it.

A database is essentially a digital repository designed to store, organize, and manage information effectively. It's a fundamental component in modern computing, used in everything from small-scale applications to large enterprise systems.

What is the full form of DBMS?

A. a) Data of Binary Management System
B. b) Database Management System
C. c) Database Management Service
D. d) Data Backup Management System
Correct answer is: B. b) Database Management System
A DBMS is a software application that interacts with end-users, applications, and the database itself to capture and analyze data. It serves as an intermediary between the database and its end-users.

Key functions of a DBMS include:

Creating, storing, and managing databases

Providing access to data for various users and applications

Ensuring data integrity, consistency, and security

Optimizing database performance

Popular examples of DBMS software:

MySQL

Oracle Database

SQL Server

PostgreSQL

MongoDB (NoSQL database)

Would you like to learn more about DBMS or its components?

The two steps the operating system takes to use a disk to hold its files are and _

A. a) caching & logical formatting
B. b) logical formatting & swap space creation
C. c) swap space creation & caching
D. d) partitioning & logical formatting
Correct answer is: D. d) partitioning & logical formatting
partitioning & logical formatting

Partitioning: This involves dividing the disk into separate sections called partitions. Each partition can be used independently to store different types of data or operating systems.

Logical formatting: This process creates a file system structure on a partition, defining how data is organized and stored on the disk. It creates directories, files, and other metadata necessary for file management.

These two steps are essential to prepare a disk for storing and managing files effectively.

The _ program initializes all aspects of the system, from CPU registers to device controllers and the contents of main memory, and then starts the operating system.

A. a) bootstrap
B. b) main
C. c) bootloader
D. d) rom
Correct answer is: A. a) bootstrap
bootstrap

The bootstrap program is the initial software that runs when a computer is powered on or restarted. It performs essential tasks like:

Initializing hardware components

Loading the operating system into memory

Transferring control to the operating system

Essentially, it bridges the gap between hardware and software, setting the stage for the operating system to take over.

Network operating system runs on _

A. a) every system in the network
B. b) server
C. c) both server and every system in the network
D. d) none of the mentioned
Correct answer is: B. b) server
server

A network operating system (NOS) primarily runs on a server. It manages network resources, security, and file sharing for clients connected to the network. While individual client systems have their own operating systems to manage local resources, the NOS is centralized on the server to coordinate network-wide operations.

What are the types of distributed operating systems?

A. a) Zone based Operating system
B. b) Level based Operating system
C. c) Network Operating system
D. d) All of the mentioned
Correct answer is: C. c) Network Operating system
Types of Distributed Operating Systems

c) Network Operating System is the correct answer.

While there are various architectural models within distributed systems (like client-server, peer-to-peer, etc.), the overarching term for an operating system that manages a network of computers is a Network Operating System (NOS).

Incorrect options:

Zone-based Operating System: This term doesn't have a standard definition in the context of operating systems.

Level-based Operating System: This term also doesn't have a standard definition in the context of operating systems.

Therefore, Network Operating System is the most accurate and widely recognized term for an operating system that manages a distributed system.

In Unix, which system call creates the new process?

A. a) create
B. b) fork
C. c) new
D. d) none of the mentioned
Correct answer is: B. b) fork
fork

The fork() system call is used in Unix-like operating systems to create a new process. It creates a copy of the current process, called a child process, which runs concurrently with the parent process.

Whenever a process needs I/O to or from a disk it issues a __

A. a) system call to the operating system
B. b) a special procedure
C. c) system call to the CPU
D. d) all of the mentioned
Correct answer is: A. a) system call to the operating system
system call to the operating system

Whenever a process requires input or output operations involving a disk, it initiates a system call to the operating system. This system call informs the OS about the specific I/O request, such as reading or writing data to a particular location on the disk. The OS then handles the request, interacts with the disk controller, and eventually returns control to the process when the operation is complete.

On systems where there are multiple operating system, the decision to load a particular one is done by _

A. a) process control block
B. b) file control block
C. c) boot loader
D. d) bootstrap
Correct answer is: C. c) boot loader
boot loader

The boot loader is responsible for loading the operating system when a computer is turned on. In systems with multiple operating systems, the boot loader provides a menu or options to select the desired operating system to load.

Join Our WhatsApp Channel! ×
Scroll to Top