Computer Knowledge - MCQ Practice Questions

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?