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.7Medium

Which data structure is best suited for implementing a priority queue?

Q.8Medium

In SQL, what is the difference between INNER JOIN and LEFT JOIN?

Q.9Medium

Which cloud service model provides virtualized computing resources over the internet?

Q.10Medium

What is the primary purpose of database indexing?

Q.11Medium

In cybersecurity, what does encryption primarily protect against?

Q.12Medium

Which sorting algorithm has the best average-case time complexity?

Q.13Medium

What is the primary function of a query optimizer in a DBMS?

Q.14Medium

In machine learning basics, what is the purpose of training data in AI models?

Q.15Hard

What is a deadlock in database management?

Q.16Hard

Which of the following best describes eventual consistency in distributed databases?

Q.17Hard

In network protocols, which layer does TCP/IP operate at?

Q.18Hard

What is the primary vulnerability addressed by SQL injection prevention techniques like parameterized queries?

Q.19Hard

In the context of graph databases, what is the primary advantage over relational databases for relationship-heavy queries?

Q.20Easy

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