SQL Fundamentals

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

What does COMMIT do in a transaction?

SQL FundamentalsEasy

Try Now

What does a DEFAULT value on a column do?

SQL FundamentalsEasy

Try Now

What does ROLLBACK do?

SQL FundamentalsEasy

Try Now

In what order does SQL evaluate the major clauses of a SELECT statement?

SQL FundamentalsEasy

Try Now

What does a LEFT JOIN return?

SQL FundamentalsEasy

Try Now

Which JOIN type returns all rows from the right table and matched rows from the left table?

SQL FundamentalsEasy

Try Now

What does a FULL OUTER JOIN return?

SQL FundamentalsEasy

Try Now

What does a CROSS JOIN produce?

SQL FundamentalsEasy

Try Now

What is the purpose of the ON clause in a JOIN?

SQL FundamentalsEasy

Try Now

What is a VIEW in SQL?

SQL FundamentalsEasy

Try Now

What is a foreign key?

SQL FundamentalsEasy

Try Now

What is the primary benefit of an index on a table column?

SQL FundamentalsEasy

Try Now

Which statement creates a new table in a database?

SQL FundamentalsEasy

Try Now

What does the CASE WHEN expression do in SQL?

SQL FundamentalsEasy

Try Now

Which statement permanently removes a table and all its data from the database?

SQL FundamentalsEasy

Try Now

What does COALESCE(a, b, c) return?

SQL FundamentalsEasy

Try Now