Browse All Questions

Which of the following describes an index scan versus an index seek?

SQL FundamentalsMedium

Try Now

What does the SQL TRIM function do?

SQL FundamentalsMedium

Try Now

What is a composite primary key?

SQL FundamentalsMedium

Try Now

What does the SQL ROUND(3.14159, 2) function return?

SQL FundamentalsMedium

Try Now

What does the SQL EXCEPT operator return?

SQL FundamentalsMedium

Try Now

Which SQL clause is required when using an aggregate function to also display non-aggregated columns?

SQL FundamentalsMedium

Try Now

What does the NULLIF(expr1, expr2) function return when expr1 equals expr2?

SQL FundamentalsMedium

Try Now

What does the REPLACE function do in SQL?

SQL FundamentalsMedium

Try Now

What is the output of: SELECT 5 / 2 in most SQL databases using integer division?

SQL FundamentalsMedium

Try Now

What is the purpose of the SQL CHECK constraint?

SQL FundamentalsMedium

Try Now

What does the following query do? SELECT dept_id, AVG(salary) FROM employees GROUP BY dept_id HAVING AVG(salary) > 60000

SQL FundamentalsMedium

Try Now

What does the CONCAT function do in SQL?

SQL FundamentalsMedium

Try Now

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

SQL FundamentalsMedium

Try Now

What does the SQL INTERSECT operator return?

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 happens when you DELETE rows without a WHERE clause?

SQL FundamentalsMedium

Try Now

What does the NOT NULL constraint enforce on a column?

SQL FundamentalsMedium

Try Now