Which statement is required to add a column to an existing table?

With SQL, how do you select all the records from a table named 'Persons' where the value of the column 'FirstName' starts with an 'a'?

What is a surrogate Key ?

How can you do an UPDATE?

HAVING clause is used in combination with _____.

The correct way to average all of the values from a column 'values' from table 'foo' is

MySQL option files provide a way to specify commonly used options so that they need not be entered on the command line each time you run a program. What is another name for the option files?

In an efficiently designed relational database, what does every table have?

How do you select every row in a given table named "inventory"?

What is the difference between DROP and TRUNCATE?

How can you filter duplicate data while retrieving records from a table?