GK Wide Logo

Computer Awareness Questions & Answers [With PDF]

Computer Awareness has become an essential part of almost every competitive exam, especially in banking, SSC, and government recruitment tests. This section tests candidates’ knowledge of computer fundamentals, software, hardware,...
1.

What is the maximum theoretical data transfer rate of USB 3.2 Gen 2x2?

2.

In database normalization, which normal form eliminates transitive dependencies?

3.

What is the time complexity of the QuickSort algorithm in the worst-case scenario?

4.

Which layer of the OSI model is responsible for end-to-end error detection and correction?

5.

In which type of CPU cache is the Write-Through policy most commonly implemented?

6.

What is the default port number for HTTPS protocol?

7.

Which SQL command is used to remove duplicate rows from a result set?

8.

In object-oriented programming, what does the 'protected' access modifier allow?

9.

What is the maximum number of primary keys that a database table can have?

10.

Which protocol is used for automatic IP address assignment in networks?

11.

In the context of Big Data, what do the '4 Vs' typically refer to?

12.

Which data structure follows the Last In, First Out (LIFO) principle?

13.

What is the primary difference between IPv4 and IPv6?

14.

In cloud computing, what does 'SaaS' stand for?

15.

Which algorithm is commonly used for encrypting data in HTTPS connections?

16.

What is the maximum cable length for a standard Ethernet Cat 6 connection?

17.

In database systems, what is a 'deadlock'?

18.

Which CPU instruction set architecture is used by Apple's M1 and M2 processors?

19.

What is the purpose of the 'finally' block in exception handling?

20.

Which NoSQL database type is best suited for storing hierarchical data like family trees or organizational charts?

21.

What is the main advantage of using a Content Delivery Network (CDN)?

22.

In computer memory hierarchy, which has the fastest access time?