You have the following table definition:CREATE TABLE Product -(ID INTEGER PRIMARY KEY,Name VARCHAR(20),Quantity INTEGER)The Product table contains the following data.You execute the following statement:SELECT Name FROM Product WHERE Quantity IS NOT NULLHow many rows are returned?
You are writing a select statement to find every product whose name contains a specific character.Which keyword should you use in your where clause?
A database contains two tables named Customer and Order.You execute the following statement:DELETE FROM Order -WHERE CustomerID = 209 -What is the result?
You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.You need to change the ProductCategory value for all the spoons in the Product table to 43.Which statement should you use?
You have a table that contains information about all students in your school.Which SQL keyword should you use to change a student's first name in the table?
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
