1012007 and 10312007 an alternative way to write the

#10/1/2007# AND #10/31/2007#) An alternative way to write the SELECT statement is to Selected
Answer: use a Type II nested query with the NOT EXISTS keywords.
Given the following Access SQL SELECT statement:
SELECT eventplan.eventno, eventrequest.datereq, dateauth, planno,
workdate, empname
FROM (EventRequest INNER JOIN EventPlan
ON EventRequest.eventno = EventPlan.eventno)
LEFT JOIN employee ON EventPlan.empno = employee.empno
WHERE eventrequest.datereq BETWEEN #7/1/2007# AND #7/31/2007#
AND dateauth BETWEEN #7/1/2007# AND #7/31/2007# AND status =
"Approved";
The FROM clause of the SELECT statement
uses a one-sided outer join that preserves the result of joining the
EventPlan and EventRequest rows.
Use the following tables to answer the question below
List the event number, customer name, plan number, employee name, facility
name, work date, and activity for event plans. The result should show only event
plans with a work date in October 2007.
How many tables appear in the FROM clause assuming that no nested queries are
used?
5
Given the following query:
SELECT CID FROM Customer
WHERE CID IN(SELECT DISTINCT CID FROM Rentals WHERE Make = ‘FORD’)
The meaning of this query is the following:
Selected
Answer:
List the unique CID of all customers who have
rented a Ford.
The following SQL query is an example of a _____________________ join.
SELECT FacNo, FacFirstName, FacLastName, FacSalary, StdNo
FROM Faculty LEFT JOIN Student
ON Student.StdNo = Faculty.FacNo
Left – Outer
What field is redundant in the Rentals table?

CName
The following SQL query is an example of a _____________________ query.
SELECT StdNo, StdFirstName, StdLastName, StdMajor
FROM Student
WHERE NOT EXISTS (SELECT * FROM Enrollment
WHERE Enrollment.StdNo = Student.StdNo )
Type II nested
Given the following query:
SELECT CID FROM Customer
WHERE CID IN(SELECT DISTINCT CID FROM Rentals WHERE Make = ‘FORD’)
The execution of this query produces the following number of rows:
3
Given the following Access SQL SELECT statement:
SELECT eventrequest.eventno, custname, contact, dateauth
FROM eventrequest, customer
WHERE eventrequest.custno = customer.custno AND status = "Approved"
AND eventno NOT IN
( SELECT eventno FROM eventplan
WHERE workdate BETWEEN #10/1/2007# AND #10/31/2007#)
The SELECT statement retrieves the event number, customer name, contact, and
date authorized of approved event requests that
do not have any related event plans in October 2007.
The following SQL query is an example of a _____________________ query.
SELECT StdNo, StdFirstName, StdLastName, StdMajor
FROM Student
WHERE Student.StdNo IN
(SELECT StdNo FROM Enrollment
WHERE EnrGrade >= 3.5 )
Type I nested
Which of the following statements does not apply to relational databases?
Relational databases have a strong procedural orientation
In a table in 1NF in which the only candidate key is a single attribute:
2NF may not be violated
If the foreign key constraint for the EventPlanLine.LineNo column includes ON DELETE
CASCADE, deleting a row of the EventPlan table