iGET

Computer Knowledge - MCQ Practice Questions

Practice free Computer Knowledge multiple-choice questions with detailed answers and explanations. Perfect for competitive exam preparation.

309 questions | 100% Free

Q.1Easy

Which normal form eliminates transitive dependencies in a database table?

Q.2Easy

What is the time complexity of a binary search algorithm on a sorted array?

Q.3Easy

Which SQL command is used to remove a table structure along with its data?

Q.4Easy

In a hash table, what is the primary cause of collision?

Q.5Easy

Which of the following is NOT a characteristic of a relational database?

Q.6Easy

What does the acronym ACID stand for in database transactions?

Q.7Easy

Which of the following is a non-relational database designed for handling unstructured data at scale?

Q.8Easy

What does ACID stand for in database transactions?

Q.9Easy

In SQL, which JOIN returns only matching records from both tables?

Q.10Easy

What is the time complexity of searching in a balanced binary search tree?

Q.11Easy

In cloud computing, what does IaaS stand for?

Q.12Easy

In cybersecurity, what is the primary purpose of a firewall?

Q.13Easy

Which of the following is a ACID property that ensures all or nothing transaction execution?

Q.14Easy

What is the primary advantage of using INNER JOIN over OUTER JOIN in SQL?

Q.15Easy

In a relational database, what does normalization primarily aim to eliminate?

Q.16Easy

Which algorithm has O(n log n) time complexity and is preferred for large datasets in modern databases?

Q.17Easy

What is the primary purpose of indexing in databases?

Q.18Easy

In the OSI model, which layer is responsible for routing and logical addressing?

Q.19Easy

What is the main disadvantage of using a linked list compared to arrays?

Q.20Easy

In AWS, what does the term 'Auto Scaling' primarily ensure?