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 is the most commonly used operation in relational algebra for projecting a collection of records from a relation?
[A] Join
[B] Union
[C] Select
[D] All of the Above
Show Answer
Correct Answer: C [Select]
Notes:
Select is used to view the tuples of the relation with or without some constraints. This operation is used to select rows from a table that specifies a given logic, which is called as a predicate. The predicate is a user defined condition to select rows of user’s choice.
22. What is the name given to the special type of stored procedure that automatically executes when an event occurs in the database server?
[A] Deadlock
[B] Trigger
[C] Instance
[D] Rollback
Show Answer
Correct Answer: B [Trigger]
Notes:
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.
23. Which of the following are examples of Access network?
[A] ADSL
[B] ISP
[C] Mobile Network
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
An access network is a type of network which physically connects an end system to the immediate router on a path from the end system to any other distant end system. Examples of access networks are ISP, home networks, enterprise networks, ADSL, mobile network, FTTH etc.
24. 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.
25. 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.
26. What is the time needed by each device on a network, to hold the message before processing, called as?
[A] Propagation time
[B] Queuing time
[C] Transmission time
[D] Jitter
Show Answer
Correct Answer: B [Queuing time]
Notes:
The time needed for each intermediate or end device to hold the message before it can be processed. The queuing time is not constant as it changes with the load imposed on the network.
27. Who invented the Twister pair cables?
[A] James Macmillan
[B] Henry Ford
[C] Alexander Graham Bell
[D] Ron Cable
Show Answer
Correct Answer: C [Alexander Graham Bell]
Notes:
Twisted-pair cabling was invented by Alexander Graham Bell in 1881. It is a type of wiring in which two conductors of a single circuit are twisted together for the purposes of improving electromagnetic compatibility.
28. What is the full form of Wi-Fi?
[A] Wireless Fidelity
[B] Wireless Find
[C] Wireless Function
[D] Wireless Fiber
Show Answer
Correct Answer: A [Wireless Fidelity]
Notes:
WI-Fi stands for Wireless Fidelity. It is a local area wireless technology. It allows an electronic device to transfer data or connect to the internet using radio waves.
29. Which of these is a connection-oriented network protocol?
[A] TCP
[B] IP
[C] UDP
[D] All of the above
Show Answer
Correct Answer: A [TCP]
Notes:
TCP stands for Transmission Control Protocol. It is a connection oriented protocol and offers end-to-end packet delivery. TCP acts as a backbone for connections.
30. Which of these protocols is used by network components to find other devices in the same broadcast domain?
[A] LPR
[B] LADP
[C] NTP
[D] ARP
Show Answer
Correct Answer: D [ARP]
Notes:
The Address Resolution Protocol (ARP) is an Internet layer protocol that helps the network components find other devices in the same broadcast domain.
