SQL Fundamentals

Which statement adds a new column to an existing table?

SQL FundamentalsEasy

Try Now

What does UPPER(‘hello’) return?

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

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

SQL FundamentalsEasy

Try Now

What does the NOT NULL constraint ensure?

SQL FundamentalsEasy

Try Now

What is a subquery?

SQL FundamentalsEasy

Try Now

What does the UNIQUE constraint enforce?

SQL FundamentalsEasy

Try Now

How do you check if a column value is NULL in SQL?

SQL FundamentalsEasy

Try Now

What does MAX(score) return?

SQL FundamentalsEasy

Try Now

Which clause is used to filter rows returned by a SELECT statement?

SQL FundamentalsEasy

Try Now

What keyword is used to give a column or table a temporary name in a query?

SQL FundamentalsEasy

Try Now

What does ORDER BY DESC do?

SQL FundamentalsEasy

Try Now

Which wildcard character matches any sequence of characters in a LIKE pattern?

SQL FundamentalsEasy

Try Now

Which clause restricts the number of rows returned by a query?

SQL FundamentalsEasy

Try Now

What does the LIKE ‘_a%’ pattern match?

SQL FundamentalsEasy

Try Now

What does the DISTINCT keyword do in a SELECT statement?

SQL FundamentalsEasy

Try Now

Which operator checks whether a value exists within a list of values?

SQL FundamentalsEasy

Try Now