SQL Fundamentals

What does the CONCAT function do in SQL?

SQL FundamentalsMedium

Try Now

What does the SQL INTERSECT operator return?

SQL FundamentalsMedium

Try Now

Which aggregate function should you use to find the total revenue per product category?

SQL FundamentalsMedium

Try Now

What is the difference between CHAR and VARCHAR data types?

SQL FundamentalsMedium

Try Now

What does the UNIQUE constraint guarantee?

SQL FundamentalsMedium

Try Now

What does the NOT NULL constraint enforce on a column?

SQL FundamentalsMedium

Try Now

What happens when you DELETE rows without a WHERE clause?

SQL FundamentalsMedium

Try Now

What is the purpose of the OFFSET clause when used with LIMIT?

SQL FundamentalsMedium

Try Now

What does the CASE expression return when no WHEN condition matches and no ELSE is provided?

SQL FundamentalsMedium

Try Now

Which of the following correctly describes a CROSS JOIN?

SQL FundamentalsMedium

Try Now

What is a self-join?

SQL FundamentalsMedium

Try Now

Which SQL statement is used to modify existing records in a table?

SQL FundamentalsMedium

Try Now

What does the DISTINCT keyword do when used with COUNT?

SQL FundamentalsMedium

Try Now

What is the result of a FULL OUTER JOIN?

SQL FundamentalsMedium

Try Now

What does the COALESCE function return?

SQL FundamentalsMedium

Try Now

What is the difference between WHERE and HAVING in SQL?

SQL FundamentalsMedium

Try Now

What is the difference between UNION and UNION ALL?

SQL FundamentalsEasy

Try Now

What is the purpose of a CHECK constraint?

SQL FundamentalsEasy

Try Now