Your database contains a table named Customer.You need to delete the record from the Customer table that has a CusromerID of 12345.Which statement should you use?
On which database structure does an insert statement operate?
You have a table of products with fields for ProductID, Name, and Price.You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.Which clause should you use in your update statement?
You have the following table definition:CREATE TABLE Product -(ProductID INTEGER,Name VARCHAR(20))You need to insert a new product. The product's name is Plate and the product's ID is 12345.Which statement should you use?
HOTSPOT -Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.Hot Area:
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
