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. Which of the following are found in abundance in a relational database?
[A] Keys
[B] Tables
[C] Records
[D] Sets
Show Answer
Correct Answer: B [Tables]
Notes:
In Relational model, data is stored in tables and is represented in form of tuples. RDBMS is used to manage Relational database. Relational database is a collection of organized set of tables related to each other, and from which data can be accessed easily.
23. Which of the following are the primary ways to enable LAN connections?
[A] Ethernet
[B] Wi-Fi
[C] Both a and b
[D] None of the Above
Show Answer
Correct Answer: C [Both a and b]
Notes:
Ethernet and Wi-Fi are the two primary ways to enable LAN connections. Ethernet is a specification that enables computers to communicate with each other. Wi-Fi uses radio waves to connect computers to the LAN.
24. What is the bandwidth limit for CAT5e cable?
[A] upto 1 Mbps
[B] upto 2 Mbps
[C] upto 10 Mbps
[D] upto 1 Gbps
Show Answer
Correct Answer: D [upto 1 Gbps]
Notes:
CAT5e can support upto 1 Gbps speeds. It was made as an improvement over CAT5 cables which can support data transmission upto 100Mbps.
25. Which of these is not an unguided mode of transmission?
[A] Infrared
[B] Radiowaves
[C] Optical Fiber
[D] Microwaves
Show Answer
Correct Answer: C [Optical Fiber]
Notes:
In unguided transmission, no physical medium is required for the transmission of electromagnetic signals. There are 3 major types of unguided mode of transmission – Infrared, Radiowaves and Microwaves.
26. 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.
27. In which year the Computer Science Network started functioning?
[A] 1978
[B] 1982
[C] 1981
[D] 1975
Show Answer
Correct Answer: C [1981]
Notes:
The Computer Science Network (CSNET) was a computer network that began operation in 1981 in the United States. The CSNET project was funded by the National Science Foundation for an initial three-year period from 1981 to 1984.
28. Which of these devices are used to send the data to a particular destination?
[A] Repeater
[B] Switch
[C] Modem
[D] None of the above
Show Answer
Correct Answer: B [Switch]
Notes:
A switch learns about MAC address connected to each port and will only send data on that port that is addressed to those MAC addresses.
29. Which of the following is correct about Digital Subscriber Line?
[A] It is always on
[B] It is faster than Dial-up
[C] Internet and phone can be used in the same time
[D] All of the above
Show Answer
Correct Answer: D [All of the above]
Notes:
A Digital Subscriber Line is always on and is faster than Dial-up. In DSL, Internet and phone can be used in the same time.
30. Which of these softwares is necessary to view web pages on the internet?
[A] Web mail
[B] Web Browser
[C] MS Office
[D] Flash Player
Show Answer
Correct Answer: B [Web Browser]
Notes:
It is important to have a web browser installed on the computer to access the internet. This is a software program that allows viewing of web pages and navigating the Internet.
