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