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 statements in SQL are considered as Data manipulation language?
[A] Update
[B] Insert
[C] Delete
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
In SQL, such statements as UPDATE, INSERT and DELETE are considered DML. Some people also lump the SELECT statement in the DML classification.
22. The CAP Theorem concludes that it is not possible for a distributed computer system to provide three guarantees at the same time. Which of the following are among these three guarantees?
[A] Consistency
[B] Availability
[C] Partition Tolerance
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
The CAP Theorem consists three following terms: Consistency states that each computer node contain all of the same data at the same time. Availability states that each database request is responded to as either successful or failure. Partition tolerance states that the database system continues operating even when not all nodes are connected to one another and suffer communication issues.
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 networking is used when centralized management is desired or if there is little room for cabling?
[A] Local Area Networking
[B] Wide Area Networking
[C] Passive Optical Local Area Networking
[D] Optical Area Networking
Show Answer
Correct Answer: C [Passive Optical Local Area Networking]
Notes:
Passive optical LANs or POLANs are adapted to indoor network architectures, and can decrease the amount of cable and equipment required to deploy a network. POLANs are ideal if there is little room for cabling.
25. 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.
26. Which of the following networking hardware can operate at anyone of the seven layers of the open systems interconnection model?
[A] Router
[B] Gateway
[C] Switch
[D] Modem
Show Answer
Correct Answer: B [Gateway]
Notes:
Gateways are distinct from routers or switches in that they communicate using more than one protocolh6k and can operate at any of the seven layers of the open systems interconnection model .
27. Which of the following is a disadvantage of using twisted paired cables for transmitting data?
[A] High cost
[B] Installation is difficult
[C] Delay Skew
[D] All of the above
Show Answer
Correct Answer: C [Delay Skew]
Notes:
Twisted paired cables are cost-effective and easy to install. But different pairs within the cable have different delays, due to different twist rates that are used to minimize crosstalk between the pairs.
28. Which of the following network protocol are described by GSM?
[A] 2G
[B] 3G
[C] 4G
[D] 5G
Show Answer
Correct Answer: A [2G]
Notes:
GSM is a standard developed to describe the protocols for second-generation (2G) digital cellular networks used by mobile devices such as mobile phones and tablets.
29. Where does the bending of EM waves occurs in the atmosphere?
[A] Troposphere
[B] Mesosphere
[C] Stratosphere
[D] Ionosphere
Show Answer
Correct Answer: D [Ionosphere]
Notes:
The phenomenon of bending of electromagnetic waves occurs in Ionosphere and they are diverted towards the earth. This is helpful in skywave propagation.
30. Which of the following switching methods was used by ARPANET?
[A] Message-switching
[B] Packet-switching
[C] Circuit-switching
[D] None of the above
Show Answer
Correct Answer: B [Packet-switching]
Notes:
The Advanced Research Projects Agency Network or as it is called as ARPANET was an early packet-switching network and the first network to implement the TCP/IP protocol suite.
