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

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

Q.222Medium

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

Q.223Medium

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

Q.224Hard

What is a deadlock in database management?

Q.225Hard

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

Q.226Hard

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

Q.227Hard

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

Q.228Hard

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

Q.229Easy

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

Q.230Easy

What does ACID stand for in database transactions?

Q.231Easy

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

Q.232Medium

Which data structure is best suited for implementing a LRU (Least Recently Used) cache?

Q.233Easy

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

Q.234Easy

In cloud computing, what does IaaS stand for?

Q.235Medium

Which normalization form eliminates transitive dependencies?

Q.236Medium

What is the primary purpose of database replication in distributed systems?

Q.237Easy

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

Q.238Medium

Which algorithm is commonly used for sorting in most programming language standard libraries?

Q.239Hard

What does CAP theorem state in distributed systems?

Q.240Medium

In machine learning basics, what is overfitting?