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. Who among the following proposed the R-tree for the first time?
[A] Antonin Guttman
[B] Van Neumann
[C] Steve Jobs
[D] Michael Raschell
Show Answer
Correct Answer: A [Antonin Guttman]
Notes:
R-trees are tree data structures used for spatial access methods. The R-tree was proposed by Antonin Guttman in 1984 and has found significant use in both theoretical and applied contexts.
22. Which of the following is used to represent a Weak entity set?
[A] Line
[B] Diamond
[C] Double Diamond
[D] Double Rectangle
Show Answer
Correct Answer: C [Double Diamond]
Notes:
In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone. It must use a foreign key in conjunction with its attributes to create a primary key.
23. 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.
24. Which of the following is the connectivity range of a Personal Area Network?
[A] 10 meters
[B] 7 meters
[C] 6 meters
[D] 9 meters
Show Answer
Correct Answer: A [10 meters]
Notes:
A Personal Area Network is smallest network which is very personal to a user.PAN has connectivity range up to 10 meters. PAN may include wireless computer keyboard and mouse, Bluetooth enabled headphones, wireless printers and TV remotes.
25. 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.
26. Which of the following are the basic functions of a gateway?
[A] Protocol Translation
[B] DHCP Service
[C] Network Address Translation
[D] All of the Above4
Show Answer
Correct Answer: D [All of the Above4]
Notes:
A gateway performs many function. Some of them are Protocol translation, network address translation and DHCP service. It is used to route the traffic from one network to another and to connect LAN to WAN or VPN.
27. Which of the following represents Latency?
[A] propagation time +transmission time +queuing time + processing delay
[B] propagation time – transmission time +queuing time + processing delay
[C] propagation time +transmission time +queuing time – processing delay
[D] (propagation time +transmission time) – (queuing time + processing delay)
Show Answer
Correct Answer: A [propagation time +transmission time +queuing time + processing delay]
Notes:
It can be said that the Latency is made of four components: propagation time, transmission time, queuing time and processing delay. Latency =propagation time +transmission time +queuing time + processing delay
28. 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.
29. Which of the following is not a disadvantage of a Tree network topology?
[A] It is heavily cabled
[B] Error detection is difficult
[C] High cost
[D] Whole network fails if central hub fails
Show Answer
Correct Answer: B [Error detection is difficult]
Notes:
One of the advantages of TREE network topology is that the error detection is easily done. Also, it is easy to manage and expand.
30. What is the maximum data transfer speed offered by Bluetooth 4.0?
[A] 10 Mbps
[B] 5 Mbps
[C] 24 Mbps
[D] 50 Mbps
Show Answer
Correct Answer: C [24 Mbps]
Notes:
The maximum data transfer speed offered by Bluetooth 4.0 is 24 Mbps. It is same as the speed offered by Bluetooth 3.0.
