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.41Easy

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

Q.42Easy

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

Q.43Easy

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

Q.44Easy

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

Q.45Easy

What is the primary purpose of indexing in databases?

Q.46Easy

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

Q.47Medium

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

Q.48Medium

What does CAP theorem state about distributed database systems?

Q.49Medium

In SQL, what is the difference between HAVING and WHERE clauses?

Q.50Medium

Which data structure is most efficient for implementing a LRU (Least Recently Used) cache?

Q.51Medium

In cloud computing, what does the term 'eventual consistency' refer to?

Q.52Medium

What is the primary benefit of containerization technology like Docker in modern application deployment?

Q.53Medium

In machine learning, what is a confusion matrix primarily used for?

Q.54Medium

Which encryption standard is currently recommended for securing data in transit over networks?

Q.55Medium

What is the time complexity of searching an element in a balanced Binary Search Tree?

Q.56Hard

In database replication, what is the primary difference between synchronous and asynchronous replication?

Q.57Hard

Which of the following best describes a distributed transaction and its challenges in microservices architecture?

Q.58Hard

In cybersecurity, what is SQL injection and why is it a critical vulnerability in 2024?

Q.59Hard

What is the primary advantage of using GraphQL over traditional REST APIs in modern application architecture?

Q.60Medium

What is the normal form that ensures no partial dependencies exist in a relation?