97. The_____ constraint defines a condition that each row must satisfy CHEK
98.Which of the following SQL statements will generate an error?Select e.last_name, d.department_name
From employees e JOIN departments d ON (department_id)
99.Comparison conditions fall into two classes: single-row operators(>,=,>=,<,<>,<=) and multiple –row operators(in, any,all)
100.The HR department needs a list of countries that have no departments located in them.
Display the country ID and the name of the countries
SELECT country_id, country_name
FROM countries
MINUS
SELECT country_id, country_name
FROM countries
NATURAL JOIN locations
NATURAL JOIN departments;
101.which of the following statements will not generate an error?
SELECT e.employee_id,d.department_name,l.city
FROM employees e JOIN departments d ON (e.department_id= d.department_id)
JOIN location l ON (d.location_id=l.location_id)
102.Consider the EMPLOYEES table. Which condition on the WHERE clause limit the employees to those who do not work in the departments 90 and 60
WHERE department_id NOT IN (90,60)
103.You cannot selectively delete rows from a table. NEVERNO
104.Considerthe EMPLOYEES table. Which of the following statement displays the hire date in the format ‘Nineteenth of Januray, 1998’
