With SQL, 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.

Which is not a valid aggregate function?

With SQL, how can you insert a new record into the 'Persons' table?

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?

Which choice is not an available string type for a column?

How would you retrieve data on all the customers where no phone number is stored?