CPT 231 Midterm Part 1

What does a relational database use to uniquely identify each row in a table?

• indexes

• foreign keys

• non-primary keys

• primary keys

Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?

DELETE FROM OrderOptions

   WHERE OrderOptionsID = 3

• It deletes the OrderOptionsID column from the OrderOptions table

• It deletes the first three rows from the OrderOptions table

• It deletes the row in the OrderOptions table that has an ID of 3

• It deletes all rows except the first three rows from the OrderOptions table

Code example 19-1

SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal

FROM Vendors INNER JOIN Invoices

   ON Vendors.VendorID = Invoices.VendorID

WHERE InvoiceTotal >= 500

ORDER BY VendorName DESC

(Refer to code example 19-1.) How many columns will the result set have?

• 7

• 6

• 5

• 4

To communicate with a DBMS, the application software sends

• command objects

• SQL Queries

• dataset requests

• primary keys

What does the following SQL statement add to the Terms table?

INSERT INTO Terms (TermsDueDays) VALUES (90)

• A row with a value of 90 for the TermsDueDays column

• 90 rows with a column of TermsDueDays

• All rows where the TermsDueDays column has a value of 90

• A TermsDueDays column with a default value of 90

Which of the following can a SELECT statement not do?

• Retrieve data

• Create calculated fields

• Combine data from two tables

• Modify selected data

The data that’s retrieved by a SELECT statement is called a

• check constraint

• SQL query

• data reader

• result set

The result set retrieved by the following SELECT statement contains records that have

SELECT Balance, Number

FROM Accounts

WHERE Balance < 0

• two of the columns and all of the rows from the Account table

• all of the columns and rows from the Accounts table

• two of the columns from the Accounts table where Balance is less than 0

• all of the columns from the Accounts table where Balance is less than 0

What does a relational database use to relate tables in the database to each other?

• indexes

• foreign keys

• non-primary keys

• primary keys

A system that divides the processing between the clients and the server is called

• a server-based system

• an enterprise system

• a mainframe system

• a client/server system