Browse All Questions

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

What is a subquery?

SQL FundamentalsEasy

Try Now

Which data type is best for storing a person’s name?

SQL FundamentalsEasy

Try Now

Which data type would you choose to store a person’s age?

SQL FundamentalsEasy

Try Now

Which statement adds a new column to an existing table?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

Which statement creates a new table in a database?

SQL FundamentalsEasy

Try Now

What is a foreign key?

SQL FundamentalsEasy

Try Now

What is a primary key?

SQL FundamentalsEasy

Try Now

Which condition correctly filters out NULL values?

SQL FundamentalsEasy

Try Now