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 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.
22. Which of the following are being managed by a database management systems
[A] Data
[B] Database Engine
[C] Database Schema
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
The DBMS manages three important things: the data, the database engine and the database schema. The database schema defines the database’s logical structure.
23. Which of the following is the final step when it has determined that a transaction has been completed successfully?
[A] Rollback
[B] Commit
[C] Transit
[D] None of the Above
Show Answer
Correct Answer: B [Commit]
Notes:
A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.
24. Which of the following is the name given to the computers on a network?
[A] Point
[B] Server
[C] Nodes
[D] Connection
Show Answer
Correct Answer: C [Nodes]
Notes:
A computer network is a set of connected computers. Computers on a network are called nodes. The connection between computers can be done via cabling, most commonly the Ethernet cable, or wirelessly through radio waves.
25. Which one of the following is not an example of WAN?
[A] Ethernet
[B] ISDN
[C] Frame Relay
[D] ATM
Show Answer
Correct Answer: A [Ethernet]
Notes:
In MAN, various LANs are connected to each other through a telephone exchange line. The most widely used protocols in MAN are RS- 232, Frame Relay, ATM, ISDN, OC-3, ADSL, etc.
26. Which of the following networking devices forwards data packets between computer networks?
[A] Router
[B] Gateway
[C] Switch
[D] Hub
Show Answer
Correct Answer: A [Router]
Notes:
A router is a networking device that forwards data packets between computer networks. Routers perform the traffic directing functions on the Internet.
27. Which of the following device distributes network traffic across a number of servers?
[A] IDS
[B] Load Balancer
[C] Switch
[D] Hub
Show Answer
Correct Answer: B [Load Balancer]
Notes:
A load balancer is a device that acts as a reverse proxy and distributes network or application traffic across a number of servers. Load balancers are used to increase capacity and reliability of applications
28. Which one of the following made up a layer 3 Switch?
[A] Hub
[B] Switch
[C] Router
[D] Both b and c
Show Answer
Correct Answer: D [Both b and c]
Notes:
A layer 3 switch is a switch and a router built together for fast performance. A router is a networking device that forwards data packets between computer networks.
29. Which one of the following routers sits on the periphery of the network?
[A] Core Router
[B] Access Router
[C] Edge Router
[D] Both b and c
Show Answer
Correct Answer: D [Both b and c]
Notes:
An access router is a router that sits at the periphery of a network. It is also known as edge router. It Contrast with “core router,” which is a router that resides in the middle of the network.
30. What role does fibers play in Optical Fiber cables?
[A] Prevent loss of signals
[B] Provide immunity against electromagnetic interference
[C] Both a and b
[D] None
Show Answer
Correct Answer: C [Both a and b]
Notes:
Fibers are used instead of metal wires because signals travel along them with less loss. Also, fibers are immune to electromagnetic interference, a problem from which metal wires suffer excessively. In addition, Fibers are also used for illumination and imaging.
