Question Bank
3705 approved questions from the community
What is the benefit of using a WITH statement (CTE) in SQL?
How would you calculate the total cash spent across all customers?
How would you count customers who have items in their cart?
How would you join the Customers table to the Orders table?
How would you display which customer ordered which items?
Why is `purchased_at >= '2017-01-01' AND purchased_at <= '2017-12-31'` better than `YEAR(purchased_at) = '2017'`?
What is SQL?
What is the main difference between SQL and NoSQL databases?
When is it best to use SQL databases?
When is it best to use NoSQL databases?
How would you select all fields from a Customers table?
How would you retrieve a specific customer's cart items using their name?
Which of the following are common SQL aggregate functions? (Select all that apply)
What is PromQL?
How does Prometheus compare to InfluxDB?
What is an Alert in Prometheus?
Prometheus is suitable for per-request billing that requires 100% accuracy.
What is the difference between an Instance and a Job in Prometheus?
Prometheus uses a push-based model where targets push metrics to the server.
Prometheus stores all of its data in a time-series database optimized for read-heavy workloads.