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. What is the full form of IEC?
[A] International Electrotechnical Commission
[B] International Electrical Council
[C] Internet Embedded Commission
[D] None of the Above
Show Answer
Correct Answer: A [International Electrotechnical Commission]
Notes:
IEC stands for International Electrotechnical Commission. Along with the ISO, the IEC controls the SQL standards and many others as well.
22. Which of the following is true regarding the process of Sharding?
[A] Sharding is a technique for partitioning data.
[B] It is a horizontal partition of data within a database.
[C] Both a and b
[D] It is a relational database locking method.
Show Answer
Correct Answer: C [Both a and b]
Notes:
Sharding is a type of database partitioning that separates very large databases the into smaller, faster, more easily managed parts called data shards. The word shard means a small part of a whole.
23. Which of the following form is based on the concept of functional dependency?
[A] 1NF
[B] 2NF
[C] 3NF
[D] All of the Above
Show Answer
Correct Answer: C [3NF]
Notes:
The table is in 3NF if every non-prime attribute of R is non-transitively dependent or directly dependent on every super key of R.
24. 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.
25. Which of the following is the reference model used for internetworking ?
[A] TCP
[B] Relay
[C] OSI
[D] Intranet
Show Answer
Correct Answer: C [OSI]
Notes:
An interconnection between public, private, commercial, industrial, or government computer networks can also be defined as internetworking. The reference model used for internetworking is Open System Interconnection(OSI).
26. Which one of the following sends data packets to all devices on a network regardless of any MAC addresses?
[A] Host Server
[B] Switch
[C] Hub
[D] Central Server
Show Answer
Correct Answer: C [Hub]
Notes:
A hub is a hardware device that relays communication data. A hub sends data packets to all devices on a network. The hub allow system administrators to monitor data passing through and to configure each port.
27. 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.
28. 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.
29. 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.
30. 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.
