Java SQL CRUD Quiz 2 – SQL Online Test | Online Quiz | Mock Exam

What function would you use to return the highest value of a column?

What keyword can you use to search for a string in a column?

What is the keyword you would use in an UPDATE query to modify the existing value?

What type of query removes information from a database?

What type of query can change content in a database?

What keyword can you use to merge two tables based on a matching column?

When sorting your results by a column´s values that are integers, what keyword would you use to sort from greatest to least?

If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?

To sort your results by a column name, what keyword would you use before the column name?

What is the keyword you would use before adding conditions to your query?

If you are only retrieving one column´s values, what keyword can you add before the column name to only return unique values?

What function can you use to compare dates?

What type of query gets information from a database?

What type of query can add new information into the database?

What keyword would you use to group your results by a column´s values?

The USE command?

In a LIKE clause, you can could ask for any value ending in “qpt” by writing

Statement: Primary Key does allow the Null Values. where as in Unique key doesn´t accept the Null values.
True or False?

In a LIKE clause, you can ask for any 6 letter value by writing?

What SQL clause is used to restrict the rows returned by a query?