Create the list of all courses in which Joe Public received an A.

Using the document structure described in Exercise 15.23, formulate the following queries in XQuery:




{
LET $sset := doc("http://xyz.edu/student.xml")
//tuple[Name/@value="Joe Public"]
FOR $c IN doc("http://xyz.edu/course.xml")//tuple,
$s IN $sset
WHERE doc("http://xyz.edu/transcript.xml")
//tuple[StudId/@value=$s/Id/@value
and Grade/@value="A"]
RETURN $c
}

Computer Science & Information Technology

You might also like to view...

The layer functioning as the clipping mask is referred to as the ____.

A. mask layer B. clipped base C. base layer D. clipping layer

Computer Science & Information Technology

With the Rectangular Marquee Tool, select ____ to specify the exact dimensions of a rectangle.

a. Fixed Height/Width b. Fixed Ratio c. Fixed Size d. Fixed Dimensions

Computer Science & Information Technology

On mobile devices, Voice over Internet Protocol (VoIP) uses the voice stream, not the data stream.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

?Case 1-1 Ryan is new to the use of XML, so he has a lot of basic questions about the fundamentals, including some philosophical questions about the language. Ryan asks you about the roots of XML. Which of the following is NOT a characteristic of SGML?

A. ?It is device-independent and system-independent. B. ?It is the chosen vehicle for creating structured documents in businesses and government organizations of all sizes. C. ?It is an easy language to learn and to apply because of its power, scope, and flexibility. D. ?It provides tools to manage enormous projects.

Computer Science & Information Technology