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 languages was first conceived by Alain Colmerauer?
[A] Prolog
[B] FORTRAN
[C] Java
[D] COBOL
Show Answer
Correct Answer: A [Prolog]
Notes:
The most characteristic features of the programming language Prolog are its built-in support for unification and backtracking. It was developed by Alain Colmerauer.
22. Which of the following DBMS is well-suited for data warehouses that have a large number of similar data items?
[A] Columnar database management system
[B] In-memory database management system
[C] RDBMS
[D] NoSQL DBMS
Show Answer
Correct Answer: A [Columnar database management system]
Notes:
CDBMS stands for Columnar database management system. It well-suited for data warehouses that have a large number of similar data items.
23. ACID is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures etc.What is the full form of ACID?
[A] Aquired Consistency In Database
[B] Atomicity, Consistency, Isolation, Durability
[C] Atomicity,Control,Isolation,Dependency
[D] Atomicity,Concurrecny,Isolation,Durability
Show Answer
Correct Answer: B [Atomicity, Consistency, Isolation, Durability]
Notes:
Andreas Reuter and Theo Harder coined the acronym ACID for Atomicity, Consistency, Isolation, and Durability. In the context of databases, a sequence of database operations that satisfies the ACID properties is called a transaction.
24. What is the name given to the undoing of partly completed database changes?
[A] Commit
[B] Edit
[C] Undo
[D] Rollback
Show Answer
Correct Answer: D [Rollback]
Notes:
A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.
25. 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.
26. System Area Network is used to provide high-speed connection in which of the following environments?
[A] Server-to-server application
[B] Storage Area Network
[C] Processor-to-Processor application
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
System Area Network is used to explain a relatively local network that is designed to provide high-speed connection in server-to-server applications, storage area network and processor-to-processor applications. The computers connected on a SAN operate as a single system at very high speeds.
27. Which of the following is true about Fiber Distributed Data Interface?
[A] It is a set of ANSI and ISO standards for data transmission on fiber optic lines in a local area network.
[B] It is based on the token ring protocol.
[C] It can extend in range up to 200 km.
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Fiber Distributed Data Interface is a set of ANSI and ISO standards for data transmission on fiber optic lines in a local area network that can extend in range up to 200 km. The FDDI protocol is based on the token ring protocol. An FDDI local area network can support thousands of users.
28. Which type of bridge is used on token ring networks?
[A] Transparent Bridge
[B] Translational Bridge
[C] Source Route Bridge
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Source route bridge is used on token ring networks. Bridge derives the entire path of the frame embedded in the header of the frame and decides how to forward the frame through out the network till it reaches its destination.
29. Which of the following represents the Transmission time?
[A] Message size/Bandwidth
[B] Message size *Bandwidth
[C] 1/2 (Message size/Bandwidth)
[D] 2 *(Message size/Bandwidth)
Show Answer
Correct Answer: A [Message size/Bandwidth]
Notes:
The transmission time, is the amount of time from the beginning until the end of a message transmission. It depends on the size of the message and the bandwidth of the channel. Transmission time =Message size / Bandwidth
30. Which of the following represents a nibble data?
[A] 2 bits
[B] 4 bits
[C] 6 bits
[D] 8 bits
Show Answer
Correct Answer: B [4 bits]
Notes:
Nibble refers to the half of an eight-bit byte or four binary digits. Byte is a group of bits (8 bits) used to represent a character. A byte is considered as the basic unit of measuring memory size in computer.
