Which keyword can be used in a create table statement?
Which keyword can be used in a create table statement?
Which data type should you use?
You need to store product quantities, and you want to minimize the amount of storage space that is
used. Which data type should you use?
Which statement will result in the creation of an index?
What is the result?
Which data type should you use?
You need to store product names that vary from three to 30 characters. You also need to minimize
the amount of storage space that is used.
Which data type should you use?
One reason to create a stored procedure is to:
One reason to create a stored procedure is to:
Which permission does a user need in order to run a stored procedure?
Which permission does a user need in order to run a stored procedure?
After you execute the statement, the result set of the view is:
You have a table named Product. You create a view that includes all the products from the Product
table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
In SQL, an insert statement is used to add a:
In SQL, an insert statement is used to add a:
How many rows will be included in the Cartesian product of these two tables?
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?