Computers and IT MCQs
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2024-2025. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
21. Which of the following has the shell as an exclusive feature?
[A] DOS
[B] UNIX
[C] System Software
[D] Linux
Show Answer
Correct Answer: B [UNIX]
Notes:
Unix is a family of multitasking, multiuser computer operating systems. The main features of UNIX include multitasking and portability capabilities.
22. What is the name given to the Automatic Speech Recognition on Apple Iphone?
[A] Julie
[B] Siri
[C] Kewta
[D] Barbie
Show Answer
Correct Answer: B [Siri]
Notes:
Siri is a virtual assistant that is part of Apple Inc.’s iOS. The assistant uses voice queries and a natural-language user interface to answer questions.
23. Which of the following are the features of a Spreadsheet?
[A] Layers and Lines
[B] Rows and Columns
[C] Layers and Planes
[D] Height and Width
Show Answer
Correct Answer: B [Rows and Columns]
Notes:
A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. The program operates on data entered in cells of a table.
24. What is the full form of IMDBMS?
[A] In-Memory database management system
[B] In-Module database management system
[C] Indian Memory database management system
[D] None of the Above
Show Answer
Correct Answer: A [In-Memory database management system]
Notes:
IMDBMS stands for In-memory database management system. It provides faster response times and better performance. It is a database management system that predominantly relies on main memory for data storage, management and manipulation.
25. Which among the following are the basic components of a relational database model?
[A] Table
[B] Record
[C] Field
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
In the relational database model, data is stored in relations, more commonly known as tables. Tables, records (sometimes known as tuples), and fields (sometimes known as attributes) are the basic components of a RDBMS.
26. Which language is used to make changes made by the DML statement?
[A] Data Definition Language
[B] Data Control Language
[C] Transaction Control Language
[D] Structured Query Language
Show Answer
Correct Answer: C [Transaction Control Language]
Notes:
Transaction Control Language is used to run the changes made by the DML statement.(TCL) commands are used to manage transactions in the database.
27. The CAP Theorem concludes that it is not possible for a distributed computer system to provide three guarantees at the same time. Which of the following are among these three guarantees?
[A] Consistency
[B] Availability
[C] Partition Tolerance
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
The CAP Theorem consists three following terms: Consistency states that each computer node contain all of the same data at the same time. Availability states that each database request is responded to as either successful or failure. Partition tolerance states that the database system continues operating even when not all nodes are connected to one another and suffer communication issues.
28. Which of the following is the term used to describe the process of forecasting in data?
[A] Data integrity
[B] Data Mining
[C] Data Encryption
[D] PERT Chart
Show Answer
Correct Answer: B [Data Mining]
Notes:
Data mining is the process of discovering patterns in large data sets. It involves methods at the intersection of machine learning, statistics, and database systems.
29. Which of the following form is based on the concept of functional dependency?
[A] 1NF
[B] 2NF
[C] 3NF
[D] All of the Above
Show Answer
Correct Answer: C [3NF]
Notes:
The table is in 3NF if every non-prime attribute of R is non-transitively dependent or directly dependent on every super key of R.
30. Which of the following devices has high bandwidth?
[A] Switch
[B] Router
[C] Modem
[D] Bridge
Show Answer
Correct Answer: A [Switch]
Notes:
A network switch is a computer networking device that connects devices on a computer network by using packet switching to receive, process, and forward data to the destination device.
