Chapter 3

Question 1

T||F: When using SQL to create a table, a column is defined by declaring in this order: data type, column name, and optional constraints

Answer 1

False

Question 2

T||F: The TOP built-in function in SQL is used to find the maximum value in a numeric column

Answer 2

False

Question 3

T||F: In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND keyword

Answer 3

True

Question 4

Standard SQL does not allow built-in functions to be used in a WHERE clause

Answer 4

True

Question 5

Built-In SQL functions cannot be applied to data combined using the GROUP BY keyword

Answer 5

False

Question 6

The order of the columns returned by an SQL SELECT statement is determined by the:

Answer 6

order they are listed in following SELECT

Question 7

Which SQL keyword is used to eliminate duplicate in the results of an SQL SELECT query?

Answer 7

DISTINCT

Question 8

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

Answer 8

WHERE Hours BETWEEN 10 AND 50

Question 9

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

Answer 9

A % sign

Question 10

Explain why it is important to learn SQL

Answer 10

SQL is a standard language and are made instead of just using the interface

Question 11

Given the table
CUSTOMER (CustID, Name, PhoneNumber, AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50

Answer 11

SELECT Name, PhoneNumber
FROM CUSTOMER
WHERE AccountBalance > 50;

Question 12

Given the table
CUSTOMER (CustID, Name, PhoneNumber, AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with ‘S’

Answer 12

SELECT Name, PhoneNumber
FROM CUSTOMER
WHERE Name LIKE ‘S%’;