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. What is the name given to the view of database that appears to an application program?
[A] Schema
[B] Metadata
[C] Front end
[D] Subschema
Show Answer
Correct Answer: D [Subschema]
Notes:
The subschema is the logical description of that section of the database which is relevant and available to an application. A subschema is a subset of the schema and inherits the same property that a schema has.
23. 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.
24. Which among the following correctly defines a Wide Area Network?
[A] A Wide Area Network is quite bigger network than the LAN.
[B] The internet is one of the biggest WAN in the world.
[C] In a WAN network, messages are transmitted fast.
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
A Wide Area Network is not limited to a single location, but it spans over a large geographical area through a telephone line, fiber optic cable or satellite links.
25. 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
26. Which of the following represents a sine wave?
[A] Non-periodic analog signal
[B] Periodic analog signal
[C] Periodic digital signal
[D] Non-periodic digital signal
Show Answer
Correct Answer: B [Periodic analog signal]
Notes:
The sine wave is the most fundamental form of a periodic analog signal. A periodic signal completes a pattern within a measurable time frame, called a period, and repeats that pattern over subsequent identical periods.
27. Which of these standards is used to define higher layer LAN protocols?
[A] IEEE 802.15
[B] IEEE 802.11
[C] IEEE 802.7
[D] IEEE 802.1
Show Answer
Correct Answer: D [IEEE 802.1]
Notes:
IEEE 802 standard is a family of IEEE standards dealing with local area networks and metropolitan area networks. IEEE 802.1 deals with higher layer LAN protocols.
28. Which of the following is an advantage of using Ring network topology?
[A] Troubleshooting is easy
[B] Failure of one computer has no effect on others
[C] Network is not affected by high traffic
[D] All of the above
Show Answer
Correct Answer: C [Network is not affected by high traffic]
Notes:
In Ring topology, each computer is connected to another computer, with the last one connected to the first. Exactly two neighbours are there for each device. The advantage of using a Ring network topology is that the network is not affected by high traffic.
29. Which of these networks usually have all the computers connected to a hub?
[A] Ring
[B] Tree
[C] Star
[D] Bus
Show Answer
Correct Answer: C [Star]
Notes:
In Star topology, all the computers are connected to a single hub through a cable. This hub is the central node and all others nodes are connected to the central node.
30. Which of the following transmission medium has categories named as RG-58, RG-59 and RG-11?
[A] Coaxial cables
[B] Twisted pair cables
[C] Fiber Optics
[D] None
Show Answer
Correct Answer: A [Coaxial cables]
Notes:
There are three categories of coax cables namely, RG-59 (Cable TV), RG-58 (Thin Ethernet), and RG-11 (Thick Ethernet). RG stands for Radio Government.
