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 terms is used for a software that is built from an existing program?
[A] Brownfield
[B] Greenfield
[C] Pre-existing
[D] None of the Above
Show Answer
Correct Answer: A [Brownfield]
Notes:
Brownfield software development is software that is built from an existing program. It may be contrasted with “Greenfield” development, which involves creating a software program from scratch.
22. Who among the following developed the LISP programming language family?
[A] Ken Thompson
[B] Donald Knuth
[C] John McCarthy
[D] Von Belt
Show Answer
Correct Answer: C [John McCarthy]
Notes:
John McCarthy was an American computer scientist. McCarthy was one of the founders of the discipline of artificial intelligence. He coined the term “artificial intelligence” and developed the LISP programming language family.
23. Which of the following are the two categories of the Low Level Languages?
[A] Machine Level and Assembly Level Language
[B] Algorithms and Assembly Level Language
[C] Assembly and Binary Level Language
[D] Machine Level and Algorithms
Show Answer
Correct Answer: A [Machine Level and Assembly Level Language]
Notes:
In case of Low-level languages, the programmer is able to tune the code to be smaller or more efficient. There are two types of low-level languages. Machine Language which is a language that is directly interpreted into the hardware. Assembly Language is slightly more user-friendly language that directly corresponds to machine language.
24. What is the name given to the view of database that appears to an application program?
[A] Schema
[B] Metadata
[C] Front end
[D] Subschema
Show Answer
Correct Answer: D [Subschema]
Notes:
The subschema is the logical description of that section of the database which is relevant and available to an application. A subschema is a subset of the schema and inherits the same property that a schema has.
25. ACID is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures etc.What is the full form of ACID?
[A] Aquired Consistency In Database
[B] Atomicity, Consistency, Isolation, Durability
[C] Atomicity,Control,Isolation,Dependency
[D] Atomicity,Concurrecny,Isolation,Durability
Show Answer
Correct Answer: B [Atomicity, Consistency, Isolation, Durability]
Notes:
Andreas Reuter and Theo Harder coined the acronym ACID for Atomicity, Consistency, Isolation, and Durability. In the context of databases, a sequence of database operations that satisfies the ACID properties is called a transaction.
26. 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.
27. Which one of the following made up a layer 3 Switch?
[A] Hub
[B] Switch
[C] Router
[D] Both b and c
Show Answer
Correct Answer: D [Both b and c]
Notes:
A layer 3 switch is a switch and a router built together for fast performance. A router is a networking device that forwards data packets between computer networks.
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. Which of the following represents Latency?
[A] propagation time +transmission time +queuing time + processing delay
[B] propagation time – transmission time +queuing time + processing delay
[C] propagation time +transmission time +queuing time – processing delay
[D] (propagation time +transmission time) – (queuing time + processing delay)
Show Answer
Correct Answer: A [propagation time +transmission time +queuing time + processing delay]
Notes:
It can be said that the Latency is made of four components: propagation time, transmission time, queuing time and processing delay. Latency =propagation time +transmission time +queuing time + processing delay
30. Which of the following is a standard for 1G network?
[A] UMTS
[B] GSM
[C] AMPS
[D] All of the above
Show Answer
Correct Answer: C [AMPS]
Notes:
AMPS or the Advanced Mobile Phone System is a standard for 1G mobile network which was in use in North America and Australia.
