With SQL, how do you select all the columns from a table named "Persons"?

A table column can have null values

How can you delete the records where the 'FirstName' is 'Peter' in the Persons Table?

Which SQL statement is used to insert new data in a database?

It is possible to add a constraint after a table is created

A datatype can be changed after a table has been created.

The left and right joins are also known as _.

Which option modifier tells a program not to exit with an error if it does not recognize the option, but instead to issue a warning?

Why would you use a common table expression (CTE)?

When a new student is added to a new database, you want new records to be created in the related tables such as Exam, Score and Attendance. How would you accomplish this?

A stored routine is a set of SQL statements stored on the server and takes form as either a procedure or a function. Which statement cannot be used inside stored routines?