1. 	 Which of the following statements best describes the rules of precedence when using SQL?	 Mark for Review 
(1) Points
					
			
	The order in which the columns are displayed

			
	The order in which the expressions are sorted

			
	The order in which the operators are returned

			
	The order in which the expressions are evaluated and calculated (*)

			
	All of the above

					
				
Correct		Correct

					
		2. 	 Which of the following is earliest in the rules of precedence?	 Mark for Review 
(1) Points
					
			
	Comparison condition

			
	Concatenation operator

			
	Logical condition

			
	Arithmetic operator (*)

					
				
Incorrect		 Incorrect. Refer to Section 17 Lesson 1.

					
		3. 	 Which symbol in the WHERE clause means "Not Equal To"? (Choose Two)	 Mark for Review 
(1) Points
					
			(Choose all correct answers)	
					
			
	<> (*)

			
	=+

			
	NOT IN (...) (*)

			
	><

					
				
Correct		 Correct

					
		4. 	 Which of the following are examples of logical operators that might be used in a WHERE clause. (Choose Two)	 Mark for Review 
(1) Points
					
			(Choose all correct answers)	
					
			
	AND, OR (*)

			
	< >, =, <=, >=, <>

			
	NOT (*)

			
	LIKES

			
	All of the above

					
				
Incorrect		Incorrect. Refer to Section 17 Lesson 1.

					
		5. 	 What will be the results of the following selection?
SELECT * 
FROM employees
WHERE last_name NOT LIKE 'A%' AND last_name NOT LIKE 'B%'

 Mark for Review 
(1) Points
					
			
	No rows will be returned. There is a syntax error

			
	All last names that begin with A or B

			
	All last names that do not begin with A or B (*)

			
	All rows will be returned

					
				
Incorrect		Incorrect. Refer to Section 17 Lesson 1.

					
		6. 	 Find the clause that will give the same results as:
SELECT * 
FROM d_cds 
WHERE cd_id NOT IN(90, 91, 92);

 Mark for Review 
(1) Points
					
			
	WHERE cd_id != 90 and cd_id != 91 and cd_id != 92; (*)

			
	WHERE cd_id NOT LIKE (90, 91, 92);

			
	WHERE cd_id <=90 and cd_id >=92;

			
	WHERE cd_id != 90 or cd_id != 91 or cd_id!= 92;

					
				
Incorrect		 Incorrect. Refer to Section 17 Lesson 1.

					
		7. 	 Which of the following would be returned by this SQL statement:
SELECT First_name, last_name, department_id 
FROM employees 
WHERE department_id IN(50,80) 
AND first_name LIKE ' C% ' 
OR last_name LIKE ' %s% '

 Mark for Review 
(1) Points
					
			
	
FIRST_NAME	LAST_NAME	DEPARTMENT_ID
Shelly	Higgins	110

			
	
FIRST_NAME	LAST_NAME	DEPARTMENT_ID
Curtis	Davies	50

			
	
FIRST_NAME	LAST_NAME	DEPARTMENT_ID
Randall	Matos	50

			
	
FIRST_NAME	LAST_NAME	DEPARTMENT_ID
Michael	Hartstein	20

			
	All of the above (*)

					
				
Incorrect		Incorrect. Refer to Section 17 Lesson 1.