Browse All Questions

What does a DEFAULT value on a column do?

SQL FundamentalsEasy

Try Now

What is the purpose of a CHECK constraint?

SQL FundamentalsEasy

Try Now

What does the UNIQUE constraint enforce?

SQL FundamentalsEasy

Try Now

What does the NOT NULL constraint ensure?

SQL FundamentalsEasy

Try Now

What does LENGTH(‘SQL’) return in most SQL databases?

SQL FundamentalsEasy

Try Now

What does UPPER(‘hello’) return?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

What does the CASE WHEN expression do in SQL?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

What is a VIEW in SQL?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

What does a CROSS JOIN produce?

SQL FundamentalsEasy

Try Now

What does a FULL OUTER 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 LEFT JOIN return?

SQL FundamentalsEasy

Try Now

What does ROLLBACK do?

SQL FundamentalsEasy

Try Now

What does COMMIT do in a transaction?

SQL FundamentalsEasy

Try Now

What is the difference between UNION and UNION ALL?

SQL FundamentalsEasy

Try Now