ITD 256 (4)

Which special boolean operator is used in a subquery to check for the instance of an event? IN IS NULL EXISTS BETWEEN

EXISTS

The --------- operator is a more logical use of the OR operator. IN OUT BETWEEN EXISTS

IN

Which SQL statement is used to enter data into a database? Update Insert Enter Rollback

Insert

Which SQL command will undo the last update? Commit Rollback Update Alter

Rollback

Which one of the following queries will list all attributes and all rows from the PRODUCT table? SELECT ALL FROM PRODUCT; SELECT WHERE FROM PRODUCT; SELECT * FROM PRODUCT; SELECT % FROM PRODUCT;

SELECT * FROM PRODUCT;

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"? SELECT * FROM Persons WHERE FirstName LIKE 'a%' SELECT * FROM Persons WHERE FirstName LIKE '%a' SELECT * FROM Persons WHERE FirstName='%a%' SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

What does SQL stand for? Strong Question Language Structured Question Language Structured Query Language Selective Query Language

Structured Query Language

Which command is entered to choose the current working database? SELECT GO USE ALTER ISN'T IT

USE

Which constraint must be applied to the primary key of a table? Null Varchar 10 Unique Integer

Unique

What two characters are used at the start of a line informing the SQL compiler to ignore the statement? /. !> /* ?&

/*

What would the result be using the between operator as shown in the query below? SELECT * FROM PRODUCT WHERE P_PRICE BETWEEN 50.00 AND 100.00 50.00 - 100.00 50.01 - 99.99 All values equal to 50.00 and 100.00 All values equal to 50.00 or 100.00

50.00 - 100.00

What result would the MAX function return given the following values: 22, 99, 77, 18?

99

Which character indicates the end of a statement in SQL? ! ; . #

;

Which of the following are boolean operators? AND OR NOT All of these

All of these

Which of the following are comparison operators? > < = All of these

All of these

Which of the following is considered a wild card character in SQL? * % _ All of these

All of these

The SQL aggregate function that gives the number of instances that a particular event occurs is? SUM MAX COUNT MIN

COUNT

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? SELECT * FROM Persons WHERE FirstName<>'Peter' SELECT * FROM Persons WHERE FirstName='Peter' SELECT [all] FROM Persons Where FirstName Like 'Peter' SELECT [all] FROM Persons Where FirstName = 'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is...... SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST EMP_LNAME, EMP_FNAME, EMP_INITIAL;

SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

The SQL command that allows a user to list the contents of a table is? Select Update Insert Where

Select