First normal form requires that a database excludes:

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails
after only 40 rows are deleted.
What is the result in the database?

You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?

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.

HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server
application through Internet Explorer.

Instructions: Use the drop-down menus to select the answer choice that completes each statement.
Each correct selection is worth one point.

You have the database table named Cars as defined below: You have the following Structured Query
Language (SQL) statement:

How many rows are returned by the SQL statement?