SQL Quiz

The SQL select statement is used to select data from tables. Which of the following is the correct syntax of retrieving all records from all columns in a table called employees?

If I am concerned about the particular order in which the results from a select statement are returned, which keywords should I use to achieve this?

I need to retrieve related data from more than one table. Which of these would be required to link the tables when I perform a select operation?

I have the data and now I need to make a table to store my data. What SQL statement would I use for this?

How can you populate a database table with data using SQL?

I just discovered my table needs an additional column, what should I do to make this change?

Now that my data is corrupted I want to remove it all from the table. What should I do?

How about if I just want to delete the table, what should I do?

How do I set a certain criteria when selecting data from my table?

Sometimes it may be difficult to test whether a column is void of data or has some non printable data. Visually they look the same, how can I verify this using SQL?

Retrieving data from my table using a SELECT statement is extremely slow, how can I solve this problem?

I have noticed on occasion that I need to place a selection criteria in one statement based on indefinite information stored in another table. Is there an efficient way to go about it? If yes, what should I do?

How do I use SQL to perform math calculations?

While we are still thinking about calculations, how would I find the average of values in a certain column in SQL?

What if I need to make changes to the data in a database without affecting the table structure, what would I use?