IT203
Assignment Review for
Exam 2
Name: Celsa Morales 1. A well-formed XML document is syntactically correct 2. An XML document stores data in a hierarchical structure. Is this statement? True or False 3. The CarbonCopy table contains the following data: ID ConID TakenBy
1. 1334 FM22
2. 2343 JS10
3. 1001 MS01
4. 1454 MS01
5. 0989 JS10
6. 0989 MS01
You execute the following query:
SELECT*FROM CarbonCopy where ID=5
How many rows should the result return? 0
4. You need to return a list of students from the Student table where the student’s e-mail address ends in “edu.” Would the following SQL query return this information? Yes or No SELECT Email, LastName, FirstName from STUDENT WHERE Email like ‘%edu’ 5. Will the following SQL statement return employee first and last names from the Pimp table sorted by last name in ascending order? Yes or No
SELECT LastName, FirstName FROM Pimp ORDER BY LastName 6. When joining two tables on a single join condition, the Cartesian product refers to all possible rows in the result, including non-qualifying rows. Is this statement? True or False 7. A join provides a way to logically recombine data from tables separated during the normalization process. Is this statement? True or False

8. Will the following SQL statement return a single row, knowing that PimpID is the primary key of the Pimp table? Yes or No SELECT FirstName, LastName FROM PIMP WHERE PimpID=’FM22’ 9. Would the following SQL statement return a single row, knowing the PimpID is the primary key of the Pimp table? Yes or No
SELECT COUNT (*) FROM ZAPPA
10. You are running a query on the following tables:
EMPLOYEE ORDER
EmpID (PK) OrdID (PK)
LastName EmpID (FK)
FirstName OrderDate
CustID (FK)
Will the following SQL query return the OrdeID number and the last name of the employee associated with the