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 are the examples of ORDBMS?
[A] PostgreSQL
[B] Greenplum
[C] SQL Server
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Examples of ORDBMSs include PostgreSQL developed by the PostgreSQL Global Development Group,Oracle Database by Oracle Corporation, Informix by IBM,SQL Server by Microsoft and Greenplum Database by Pivotal Software etc.
22. 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.
23. 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.
24. Which of the following is the term used to describe the process of forecasting in data?
[A] Data integrity
[B] Data Mining
[C] Data Encryption
[D] PERT Chart
Show Answer
Correct Answer: B [Data Mining]
Notes:
Data mining is the process of discovering patterns in large data sets. It involves methods at the intersection of machine learning, statistics, and database systems.
25. Which of the following is an advantage of using Ring network topology?
[A] Troubleshooting is easy
[B] Failure of one computer has no effect on others
[C] Network is not affected by high traffic
[D] All of the above
Show Answer
Correct Answer: C [Network is not affected by high traffic]
Notes:
In Ring topology, each computer is connected to another computer, with the last one connected to the first. Exactly two neighbours are there for each device. The advantage of using a Ring network topology is that the network is not affected by high traffic.
26. What role does fibers play in Optical Fiber cables?
[A] Prevent loss of signals
[B] Provide immunity against electromagnetic interference
[C] Both a and b
[D] None
Show Answer
Correct Answer: C [Both a and b]
Notes:
Fibers are used instead of metal wires because signals travel along them with less loss. Also, fibers are immune to electromagnetic interference, a problem from which metal wires suffer excessively. In addition, Fibers are also used for illumination and imaging.
27. 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.
28. UMTS is a standard for which of the following networks?
[A] 2G
[B] 3G
[C] 4G
[D] 5G
Show Answer
Correct Answer: B [3G]
Notes:
UMTS stands for Universal Mobile Telecommunications Service. It is a third-generation (3G) broadband, packet-based transmission of text, digitized voice, video, and multimedia. It transfers data at rates up to 2 megabits per second (Mbps).
29. Which of these factors affect the line of sight communication?
[A] line of sight distance
[B] curvature of the earth
[C] Both a and b
[D] None
Show Answer
Correct Answer: C [Both a and b]
Notes:
The line of sight communication is affected by (a) the line of sight distance (b) the curvature of the earth. The space waves are used for line of sight communication such as television broadcast, microwave link and satellite communication.
30. Which university was connected for the first time with the Stanford Research Institute under ARPANET?
[A] University of California
[B] University of Michigan
[C] Harvard University
[D] University of New York
Show Answer
Correct Answer: A [University of California]
Notes:
The first ARPANET link was established between the University of California, Los Angeles (UCLA) and the Stanford Research Institute.
