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 used as an application programming interface with RDBMS?
[A] VB
[B] COBOL
[C] SQL
[D] All of the Above
Show Answer
Correct Answer: C [SQL]
Notes:
With relational DBMSs known as RDBMSs, the Application programming interface is SQL.SQL a standard programming language for defining, protecting and accessing data in a RDBMS.
22. Who among the following is the father of MySQL?
[A] Charles Babbage
[B] Michael Wideneus
[C] Allen Jobs
[D] Madam Kama
Show Answer
Correct Answer: B [Michael Wideneus]
Notes:
Michael Widenius is known as the Father of MySQL. He is the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company.
23. Which among the following are the database languages?
[A] Data Definition Language
[B] Data Manipulation Language
[C] Data Control Language
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
There are many types of Database Languages. A few among them are – Data Definition Language. DDL stands for Data Definition Language, Data Manipulation Language, Data Control Language etc.
24. What is the name given to the undoing of partly completed database changes?
[A] Commit
[B] Edit
[C] Undo
[D] Rollback
Show Answer
Correct Answer: D [Rollback]
Notes:
A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.
25. 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.
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 represents the Transmission time?
[A] Message size/Bandwidth
[B] Message size *Bandwidth
[C] 1/2 (Message size/Bandwidth)
[D] 2 *(Message size/Bandwidth)
Show Answer
Correct Answer: A [Message size/Bandwidth]
Notes:
The transmission time, is the amount of time from the beginning until the end of a message transmission. It depends on the size of the message and the bandwidth of the channel. Transmission time =Message size / Bandwidth
28. What do we call the time required to send one single bit?
[A] Bit interval
[B] Bit lag
[C] Bit rate
[D] Bit frequency
Show Answer
Correct Answer: A [Bit interval]
Notes:
The bit interval is the time required to send one single bit. It, along with bit rate, is used to describe the digital signals.
29. What is the number of bit interval per second known as?
[A] Bit period
[B] Bit lag
[C] Bit capacity
[D] Bit rate
Show Answer
Correct Answer: D [Bit rate]
Notes:
The bit rate is the number of bit interval per second. This mean that the bit rate is the number of bits send in one second, usually expressed in bits per second.
30. 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.
