OMIS 452 Ch 3 Questions with Correct Answers (Grade A+)

OMIS 452 Ch 3 Questions with Correct Answers (Grade A+)

Question 1: In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
T/F?

Answer: False


Question 2: The ON DELETE CASCADE referential integrity constraint does not apply when rows
are deleted using the SQL DELETE command. T/F?

Answer: False


Question 3: When using SQL to create a table, specifying the NULL property for a column indicates
that only null values may be stored in that column. T/F?

Answer: False


Question 4: Microsoft Access can run QBE queries, but not SQL queries. T/F?

Answer: False


Question 5: Which of the following is not one of the five SQL built-in functions? a. AVG b. SUM c.
MAX d. COUNT e. MODE

Answer: MODE


Question 6: In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT
LIKE condition for selecting values. T/F?

Answer: True


Question 7: Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance) what is the
standard SQL query phrase to retrieve the Name and Phone Number of customers? a.) SELECT
(CUSTOMER-Name AND CUSTOMER-PhoneNum) b.) SELECT CUSTOMER-Name AND
CUSTOMER-PhoneNum c.) SELECT Name, PhoneNum d.) SELECT* e.) SELECT
(Name,PhoneNum)

Answer: SELECT Name, PhoneNum


Question 8: The TOP built-in function in SQL is used to find the maximum value in a numeric
column. T/F?

Answer: False

Page 1