A named group of SQL statements that can be executed in a database is called a:

A view can be used to:

On which database structure does an update statement operate?

You need to list the name and price of each product, sorted by price from highest to lowest. Which
statement should you use?

You delete rows in a table named Order. The corresponding rows in the OrderItem table are
automatically deleted. This process is an example of a/an:

Which statement deletes the rows where the employee’s phone number is not entered?

You need to insert two new products into the Product table. The first product is named Book and has
an ID of 125. The second product is named Movie and has an ID of 126.
Which statement should you use?

You have a table named Employee that includes four columns. You execute the following statement:
SELECT * FROM Employee
Which columns are returned?

Which two elements are required to define a column? (Choose two.)

What defines the amount of storage space that is allocated to a value in a column?