Computer Knowledge - MCQ Practice Questions

What is the main advantage of cloud computing's elasticity?

In SQL, what does the GROUP BY clause do?

Which normalization form eliminates all non-key dependencies?

What is the time complexity of quicksort algorithm in the worst case?

In cloud computing, which service model allows customers to run their own applications but not manage infrastructure?

What is the difference between DELETE and TRUNCATE in SQL?

In graph algorithms, which algorithm finds the shortest path in weighted graphs?

What does normalization in machine learning context primarily aim to achieve?

In cybersecurity, what is SQL injection attack?

What is the primary difference between supervised and unsupervised machine learning?

In distributed systems, what is a consensus algorithm primarily used for?

What is the primary challenge of implementing ACID properties in distributed databases?

In AI/ML, what is the role of activation functions in neural networks?

In a relational database, which normal form eliminates partial dependencies and is considered essential for most practical database designs?

Which of the following is a characteristic of NoSQL databases that makes them suitable for handling big data in cloud environments?

In database indexing, which type of index structure provides the best average-case performance for range queries in modern database systems?

Which of the following SQL query optimization techniques is most effective when dealing with large fact tables in a data warehouse environment?

In the context of distributed databases, which consistency model is used by most cloud-native databases like DynamoDB and offers eventual consistency?

Which of the following represents a vulnerability in SQL query construction that can be exploited through malicious user input, and can be prevented using parameterized queries?

In a sharded database architecture deployed on cloud infrastructure, which of the following represents the most critical challenge that must be addressed?