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. The smallest unit in which data can be stored is known by which of the following names?
[A] Bit
[B] Byte
[C] Kilobyte
[D] Megabyte
Show Answer
Correct Answer: A [Bit]
Notes:
The bit is a basic unit of information. The words bit and binary digit are used interchangeably. The binary digit can have only one of two values. It may be physically represented with a two-state device.
22. A storage device type that stores computer data after it is turned off. It is added to a computer beyond the immediately usable main storage. What is the name given to this device?
[A] Floppy disk
[B] Hard disk
[C] Backing store
[D] Punched card
Show Answer
Correct Answer: C [Backing store]
Notes:
The term backing storage refers to non-volatile data storage. Common types of backing storage devices are hard drives, SSD, external hard disk drives, optical media such as CD or DVD, and flash media such as thumb drives and memory sticks.
23. Which of the following is the first layer of software loaded into computer memory when it starts up?
[A] Device Driver
[B] Operating System
[C] Language Translator
[D] System Utilities
Show Answer
Correct Answer: B [Operating System]
Notes:
An operating system is a system software that manages computer hardware and software resources and provides common services for computer programs.
24. What is the name given to a person who designs the programs in a software package?
[A] User
[B] Software Instructor
[C] Software Designer
[D] System Programmer
Show Answer
Correct Answer: D [System Programmer]
Notes:
The programs included in a system software package are called system programs. The programmers who design them and prepare them are called system programmers.
25. Which of the following are the software analysis and design tools?
[A] Data Flow Diagrams
[B] ER Diagrams
[C] HIPO Diagrams
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Various system design and analysis tools are DFDs (Data Flow Diagrams), Structured Charts, Structured English, Data Dictionary, HIPO (Hierarchical Input Process Output) diagrams, ER (Entity Relationship) Diagrams and Decision tables.
26. There is a system software which performs the task of resolution of externally defined symbols. What is the name of such a system software?
[A] Loader
[B] Linker
[C] Compiler
[D] Assembler
Show Answer
Correct Answer: B [Linker]
Notes:
A linker is a computer program that takes one or more object files generated by a compiler and combines them into one, executable program. The compiler automatically invokes the linker as the last step in compiling a program.
27. Which of the following Microsoft applications is used to create a budget?
[A] Microsoft Excel
[B] Microsoft Access
[C] Microsoft PowerPoint
[D] Microsoft Word
Show Answer
Correct Answer: A [Microsoft Excel]
Notes:
Microsoft Excel is a spreadsheet developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
28. What is full form of the YAGNI principle used in software system designing?
[A] You are not gonna need it.
[B] You are going not into it.
[C] You are gonna need it.
[D] You aint get to know it.
Show Answer
Correct Answer: A [You are not gonna need it.]
Notes:
You aren’t gonna need it or YAGNI is a principle of extreme programming that states a programmer should not add functionality until deemed necessary.
29. 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.
30. 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.
