0PP
Explore questions covering topics from sql, normalization, transactions, indexing and more .
Explain the concept of OLTP vs OLAP.
What are triggers in a database?
What is a database?
What is a functional dependency?
What is the purpose of the 'GROUP BY' clause in SQL?
What are aggregate functions in SQL? Name three.
Explain the ACID properties.
What is data integrity?
What is a self-join?
What is a database view?
What is the role of a query optimizer?
What are the different types of relationships in a database? (One-to-One, One-to-Many, etc.)
What is the difference between DELETE, TRUNCATE, and DROP commands?
Given an 'Orders' table (order_id, customer_id, order_date), write a query to find the total number of orders for each customer.
What is the difference between SQL and NoSQL databases?
Explain the concept of OLTP vs OLAP.
What are triggers in a database?
What is a database?
What is a functional dependency?
What is the purpose of the 'GROUP BY' clause in SQL?
What are aggregate functions in SQL? Name three.
Explain the ACID properties.
What is data integrity?
What is a self-join?
What is a database view?
What is the role of a query optimizer?
What are the different types of relationships in a database? (One-to-One, One-to-Many, etc.)
What is the difference between DELETE, TRUNCATE, and DROP commands?
Given an 'Orders' table (order_id, customer_id, order_date), write a query to find the total number of orders for each customer.
What is the difference between SQL and NoSQL databases?