Competitive Exams : Computer Awareness - Mix (Set 2) | Concept of Maths

Question 1

1. In Computer Architecture, if a processor uses an $n$-bit address bus, what is the maximum number of unique memory locations it can address?

A) $n^2$

B) $2 \times n$

C) $2^n$

D) $n^n$

Answer

Correct Answer: C

Solution: The number of addressable locations is determined by the total number of unique combinations possible with $n$ bits. $$\text{Locations} = 2^n$$ For example, if $n = 3$, locations = $2^3 = 8$ (from $000$ to $111$).

Question 2

2. Which component of the CPU is responsible for coordinating the flow of data and instructions between the CPU, memory, and I/O devices?

A) Arithmetic Logic Unit (ALU)

B) Control Unit (CU)

C) Registers

D) Secondary Storage

Answer

Correct Answer: B

Solution: The Control Unit (CU) acts as the manager of the CPU. It fetches instructions, decodes them, and directs the ALU and other components on how to respond.

Question 3

3. What does the Program Counter (PC) register store?

A) Address of the next instruction to be executed

B) The result of the last arithmetic operation

C) A copy of the current instruction

D) The total number of programs currently running

Answer

Correct Answer: A

Solution: The Program Counter keeps track of the execution sequence by holding the memory address of the next instruction to be processed in the fetch-decode-execute cycle.

Question 4

4. Von Neumann architecture is characterized by:

A) Separate memory for data and instructions

B) No use of a Central Processing Unit

C) Multiple parallel processors only

D) Storing both data and instructions in the same memory

Answer

Correct Answer: D

Solution: The Von Neumann Architecture (Stored Program Concept) uses a single memory space and a single bus for both data and instructions, leading to the "Von Neumann Bottleneck".

Question 5

5. If a CPU cache has a hit ratio of $90\%$ and a miss penalty of $100$ ns, while the cache access time is $10$ ns, what is the effective access time?

A) $10$ ns

B) $20$ ns

C) $19$ ns

D) $100$ ns

Answer

Correct Answer: B

Solution: $$EAT = T_{cache} + (\text{Miss Rate} \times \text{Miss Penalty})$$ $$EAT = 10\text{ ns} + (0.10 \times 100\text{ ns})$$ $$EAT = 10\text{ ns} + 10\text{ ns} = 20\text{ ns}$$

Question 6

6. Which of the following is true about a Compiler?

A) It translates code line-by-line during execution

B) It is a type of Application Software

C) It translates the entire source code into object code at once

D) It is not needed for High-Level Languages

Answer

Correct Answer: C

Solution: A Compiler scans the entire program and translates it into machine code before execution. An Interpreter translates line-by-line.

Question 7

7. Which type of memory is non-volatile and can be erased electronically and rewritten?

A) EEPROM

B) SRAM

C) DRAM

D) PROM

Answer

Correct Answer: A

Solution: EEPROM (Electrically Erasable Programmable Read-Only Memory) allows individual bytes to be erased and reprogrammed.

Question 8

8. A 'Device Driver' is categorized as:

A) Application Software

B) Firmware only

C) Hardware component

D) System Software

Answer

Correct Answer: D

Solution: System Software includes the Operating System and utility programs like Device Drivers, which allow the OS to communicate with hardware.

Question 9

9. What is 'Warm Booting'?

A) Starting a computer from a powered-off state

B) Restarting a computer that is already powered on

C) Using a hair dryer to heat the CPU

D) Installing a new Operating System

Answer

Correct Answer: B

Solution: Warm Booting (Soft Boot) is restarting a computer via the OS interface or Ctrl+Alt+Del, without cutting the physical power. Cold Booting starts from zero power.

Question 10

10. Which logic gate is known as a 'Universal Gate'?

A) AND

B) OR

C) NAND

D) XOR

Answer

Correct Answer: C

Solution: NAND and NOR gates are universal because any other Boolean function (AND, OR, NOT) can be implemented using only these gates.

Question 11

11. In MS Excel, what does the formula $=SUM(\$A\$1:A5)$ represent when dragged down one cell to the next row?

A) $=SUM(\$A\$1:A5)$

B) $=SUM(\$A\$1:A6)$

C) $=SUM(\$A\$2:A6)$

D) $=SUM(A1:A6)$

Answer

Correct Answer: B

Solution: The $ symbol denotes Absolute Referencing. $\$A\$1$ is fixed, while $A5$ is relative. When dragged down, $A5$ becomes $A6$, but $\$A\$1$ remains unchanged.

Question 12

12. In MS Word, which shortcut is used to create a 'Hanging Indent'?

A) Ctrl + T

B) Ctrl + H

C) Ctrl + I

D) Ctrl + K

Answer

Correct Answer: A

Solution: Ctrl + T creates a hanging indent. (Ctrl+H is Replace, Ctrl+I is Italic, Ctrl+K is Hyperlink).

Question 13

13. In MS Access, which field property ensures that no two records have the same value in a specific column?

A) Validation Rule

B) Input Mask

C) Primary Key

D) Foreign Key

Answer

Correct Answer: C

Solution: A Primary Key uniquely identifies each record in a table and cannot contain null or duplicate values.

Question 14

14. In MS PowerPoint, which view allows you to see all slides at once in a grid format to easily rearrange them?

A) Normal View

B) Outline View

C) Reading View

D) Slide Sorter View

Answer

Correct Answer: D

Solution: Slide Sorter View displays thumbnails of all slides, making it the best tool for organizing and reordering slides.

Question 15

15. In MS Excel, the intersection of the 10th row and the 2nd column is:

A) 10B

B) B10

C) J2

D) 2J

Answer

Correct Answer: B

Solution: Column 1 is A, Column 2 is B. The row is 10. Cell address follows the format [Column Letter][Row Number], so it is B10.

Question 16

16. Which feature in MS Word allows you to send the same letter to multiple recipients with different names and addresses?

A) Mail Merge

B) Cross-reference

C) Macro

D) Track Changes

Answer

Correct Answer: A

Solution: Mail Merge is used to create personalized letters, envelopes, or labels for a large mailing list.

Question 17

17. What is the file extension for a PowerPoint Show file (which opens directly in presentation mode)?

A) .pptx

B) .potx

C) .ppsx

D) .thmx

Answer

Correct Answer: C

Solution: .ppsx is the PowerPoint Show format. .pptx is standard, .potx is a template.

Question 18

18. In MS Access, a 'Query' is used to:

A) Store raw data only

B) Retrieve and filter specific data from tables

C) Create a graphical user interface

D) Design the printed output

Answer

Correct Answer: B

Solution: A Query is a request for data results, and for action on data. You use it to answer questions, perform calculations, or combine data from different tables.

Question 19

19. In MS Excel, what is the default alignment for numbers in a cell?

A) Right-aligned

B) Left-aligned

C) Center-aligned

D) Justified

Answer

Correct Answer: A

Solution: In Excel, Numbers are right-aligned by default, while Text is left-aligned.

Question 20

20. Which shortcut key is used to start a PowerPoint presentation from the 'current' slide?

A) F5

B) Ctrl + F5

C) Alt + F5

D) Shift + F5

Answer

Correct Answer: D

Solution: F5 starts from the first slide. Shift + F5 starts from the slide currently selected in the editor.

Competitive Exams : Computer Awareness - Mix (Set 2) | Concept of Maths