Final Quiz (Introduction to SQL)

Which data type is used to create text columns in a database table?

Which statement is used to add a column with unique integer values?

While inserting records, if column names are not specified in the INSERT INTO clause, the order of the values in the VALUES clause and table columns must be:

How many records can be inserted at a time using INSERT INTO query?

How to select all records from a table \”Cars\” with columns \”Name\”, \”Id\” and \”Price\”?

How to select all records from a table \”Cars\” with columns \”Name\”, \”Id\” and \”Price\” where \”Price\” is greater than 5000?

To modify an existing record, the following query is used:

The following query deletes all the records from a \”Cars\” table.

Which function can be used to select unique values from a column?

Which clause is used to filter data when GROUP BY statement is used?