Deck 9: Working With Xml and Databases

Question 1

In an XQuery variable declaration, text strings need to be enclosed within single or double quotes .

Answer 1

True

Question 2

XQuery provides several tools to create formatted output.

Answer 2

False

Question 3

In an XQuery file, namespaces need to be declared in the query body .

Answer 3

False

Question 4

A path expression is usually more compact and easier to apply for simple queries compared to a FLWOR structure.

Question 5

You cannot sort the results of a query created using a path expression.

Question 6

XQuery comments can be nested within one another to provide more information to the user.

Question 7

In an XQuery file, the query body consists of a single expression that retrieves data from a source document based on criteria provided in the query expression.

Question 8

In an XQuery document, all string values and file references need to be enclosed within matching curly braces.

Question 9

The XSLT doc() function is not supported in XQuery.

Question 10

XQuery is a subset of XPath 2.0.

Question 11

In a FLWOR query, only one where clause is allowed per query, and it must be placed before all of the for and let clauses.

Question 12

With XQuery, the user can summarize data with aggregate functions.

Question 13

You cannot use XQuery in place of XSLT to transform a source document.

Question 14

Element values are enclosed within a set of square brackets .

Question 15

In general, a processor can run a where clause faster than it can run a predicate expression.

Question 16

When you import a library module, the module URI in the import statement must match the URI in the library module file.

Question 17

A(n) query function contains a collection of statements that can be referenced throughout the query document.

Question 18

In a FLWOR query, variables defined in a for or let clause act as local variables.

Question 19

Variables declared in a library module must be assigned to the module namespace.

Question 20

In the order by clause of a FLWOR query, the default is to sort items in descending order.

Question 21

One option to format query results is to add the declaration _____ to the XQuery prolog, which preserves all of the white space characters from the XQuery file and writes them to the result document.

A) declare boundary-space indent;
B) declare boundary-space preserve;
C) !indent=yes;
D) declare indent-space=yes;

Question 22

The prolog of an XQuery document contains a series of declarations with each declaration terminated with a _____.

A) colon
B) comma
C) semi-colon
D) backslash

Question 23

In the FLWOR query shown in the accompanying figure, the box labeled _____ indicates the root element.

A) A
B) B
C) D
D) E

Question 24

If you do not specify a data type, XQuery applies the _____ data type, allowing the variable to contain any type of data.

A) xs:anyType
B) xs:blank
C) xs:xsType
D) xs:anyData

Question 25

The path expression _____ uses a predicate to select only those store elements from the gjc_stores.xml file that operate in the state of Colorado.

A) document() 'gjc_stores.xml') //store[state='CO']
B) doc('gjc_stores.xml') //state[store='CO']
C) doc('gjc_stores.xml') //store[state='CO']
D) document() 'gjc_stores.xml') //state[store='CO']

Question 26

XQuery files are usually saved with the file extension _____.

A) )xq
B) )xqy
C) )xquery
D) All of these are correct.

Question 27

In a FLWOR query structure, the _____ clause declares a variable and gives it an initial value.

A) for
B) let
C) where
D) order by

Question 28

XQuery is a _____ programming language like XSLT.

A) procedural
B) declarative
C) object-oriented
D) second-generation

Question 29

In the FLWOR query shown in the accompanying figure, the box labeled _____ indicates the clause that sorts the query.

A) A
B) B
C) C
D) F

Question 30

You can automatically generate comments for your query through the use of _____ comments, which are a standard method for creating structured documentation.

A) XQuery
B) xqdoc
C) XML
D) xhtml

Question 31

You can add an element to a query through a(n) _____, which uses XML-like syntax to insert the element markup tags directly into the query expression.

A) indirect element constructor
B) root element constructor
C) direct element constructor
D) literal element constructor

Question 32

In XQuery, the _____ namespace is used for creating user-defined functions.

A) local
B) fn
C) xsi
D) xs

Question 33

The XQuery prolog declaration _____ specifies whether empty elements should appear last in any node ordering or first.

A) declare ordering
B) declare default collation
C) declare default function
D) declare default order

Question 34

Variables defined within the _____ have global scope and can be referenced throughout the query document.

A) root template
B) query body
C) query template
D) prolog

Question 35

If you do not specify an output file, Saxon will display the query result in _____.

A) the command window
B) the default browser
C) a file named readme.xq
D) a file named output.txt

Question 36

To declare an external variable, add the keyword _____ to the variable declaration.

A) global
B) external
C) source
D) imported

Question 37

In a FLWOR query structure, the _____ clause iterates through a sequence of values, calculating an expression for each item in the sequence.

A) for
B) let
C) where
D) order by

Question 38

For larger documents and more complicated search criteria, it is generally easier and more efficient to use _____ to transform a source document.

A) XQuery
B) XSLT 1.0
C) XSLT 2.0
D) XPath

Question 39

In the FLWOR query shown in the accompanying figure, the box labeled _____ indicates the clause that displays the results of the query.

A) B
B) C
C) D
D) F

Question 40

XQuery is written in text format as a collection of _____.

A) declarations
B) expressions
C) sequences
D) templates

Question 41

The last statement in the FLWOR structure is always the _____ clause.

A) for
B) where
C) group by
D) return

Question 42

As with XSLT, many calculations and operations in XQuery can be performed using _____, in which the XQuery function calls itself repeatedly until a stopping condition is met.

A) recursion
B) looping
C) predicates
D) parameters

Question 43

You can use multiple _____ clauses in a FLWOR query structure to create nested sequences.

A) let
B) where
C) for
D) return

Question 44

A(n) _____ module is an external XQuery file that contains only the declarations for namespaces, variables, and user-defined functions.

A) storage
B) library
C) import
D) declaration

Question 45

In the user-defined functions shown in the accompanying figure, the box labeled _____ indicates a function name.

A) A
B) B
C) C
D) D

Question 46

In a FLWOR query structure, variables defined in the for clause update their value at each step in the iteration, but a variable defined in the _____ clause has a single unchanged value.

A) let
B) where
C) group by
D) return

Question 47

Module library files are often saved with the file extension _____.

A) )xq
B) )xql
C) )xqm
D) )xml

Question 48

In a FLWOR query structure, the _____ clause specifies a condition by which the items in the iterated sequence are filtered.

A) for
B) let
C) where
D) order by

Question 49

When a query is based on elements in which there is no predefined set of unique values, you can construct a list of unique values using the XPath 2.0 _____ function.

A) distinct-values()
B) unique-values()
C) defined-values()
D) list-values()

Question 50

A query _____ contains a collection of statements that can be referenced throughout the query document.

A) module
B) function
C) prolog
D) header

Question 51

In XQuery, variables are assigned using the _____ symbol.

A) :=
B) =
C) ==
D) =:

Question 52

In a FLWOR query you can include the _____ keyword within the for clause to track the number of iterations.

A) at
B) count
C) track
D) iteration

Question 53

In the user-defined functions shown in the accompanying figure, the box labeled _____ indicates a function parameter.

A) A
B) B
C) C
D) D

Question 54

The FLWOR structure needs to be enclosed within a set of _____ so that the XQuery processor evaluates the expression before writing the query result into its containing element.

A) square brackets
B) curly braces
C) parentheses
D) double quotes

Question 55

The _____ statement retrieves all of the variables and functions defined in a library module.

A) load
B) import
C) retrieve
D) library

Question 56

When you import a library module, the module _____ in the import statement must match the one in the library module file.

A) namespace
B) prolog
C) template
D) URI

Question 57

One way to query data from several sources is to apply a _____ clause to each document source.

A) let
B) group by
C) for
D) return

Question 58

In a FLWOR query structure, the _____ clause sorts the items in the sequence based on a supplied expression.

A) for
B) let
C) where
D) order by

Question 59

The first expression in a FLWOR query structure is the _____ clause.

A) for
B) let
C) where
D) return

Question 60

In the user-defined functions shown in the accompanying figure, the box labeled _____ indicates the data type returned by the function.

A) A
B) B
C) C
D) D

Question 61

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes has heard that one of the clauses in a FLWOR structure is used to iterate through a sequence of nodes or atomic values. You tell her that she is describing the _____ clause.

A) for
B) let
C) where
D) return

Question 62

The _____ keyword allows the variable value to be set by the processor when the query is run.

Question 63

Essentially any text in the query that is not part of an expression is treated as _____ and displayed as part of the query result without modification.

Question 64

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes is confused by the rules about how many of each type of clause are required in a FLWOR structure. You tell her that in a FLWOR structure, there must be exactly only one _____ clause.

A) where
B) for
C) let
D) return

Question 65

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes is confused by the rules about how many of each type of clause are required in a FLWOR structure. You tell her that in a FLWOR structure, there must be at least one _____ clause.

A) where
B) for
C) order by
D) return

Question 66

Alfonso has been working with XQuery, and would like to create a library module to centralize the global variables and functions he's created. He has encountered some problems in implementing the library module, and comes to you for help. Alfonso has fixed the error in the query prolog, but now is encountering problems when he tries to reference a function he defined and added to the library module. In looking at his library module code, you remind him that he must include the _____ keyword when creating a user-defined function.

A) namespace
B) define
C) declare
D) library

Question 67

Alfonso has been working with XQuery, and would like to create a library module to centralize the global variables and functions he's created. He has encountered some problems in implementing the library module, and comes to you for help. Alfonso has fixed the errors found in the variable references contained in his new query module, but is still encountering errors. In looking at his code, you remind him to add a(n) _____ to the query prolog.

A) declare statement
B) import statement
C) absolute path
D) relative path

Question 68

Alfonso has been working with XQuery, and would like to create a library module to centralize the global variables and functions he's created. He has encountered some problems in implementing the library module, and comes to you for help. Alfonso has placed several global variables in his library module. However, when he references one of these variables in a query main module, an error occurs. In looking at his code, you suggest the problem is happening because he did not include the _____ when referencing the variable.

A) namespace prefix
B) absolute path
C) fully qualified name
D) relative path

Question 69

_____ variables are variables whose values are determined when the query is run by the processor.

Question 70

You can add comments to any part of the XQuery file using the statement _____.

A) (: comment :)
B) ( comment )
C) : comment :
D) :( comment ) :

Question 71

In an XQuery file, the _____ namespace is used for creating user-defined functions.

Question 72

To run a query, you need a(n) _____ that parses, analyzes, and evaluates the query.

Question 73

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes has heard that one of the clauses in a FLWOR structure filters the result of the query and can replace the long and complicated predicates found in path expressions. You tell her that she is describing the _____ clause.

A) for
B) let
C) where
D) order by

Question 74

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes has heard that one of the clauses in a FLWOR structure defines a local variable that holds a single unchanged value. You tell her that she is describing the _____ clause.

A) for
B) let
C) where
D) return

Question 75

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes has heard that one of the clauses in a FLWOR structure can be used to display the results of the query. You tell her that she is describing the _____ clause.

A) for
B) where
C) order by
D) return

Question 76

A query can be written using a(n) _____, which is simply an XPath expression that retrieves element and attribute nodes from a source document based on specified criteria.

Question 77

In the for clause of a FLWOR query, the _____ attribute is optional.

A) expression
B) type
C) as
D) ID

Question 78

In an XQuery file, the _____ is an optional section that is placed at the beginning of the query and is used to set up fundamental properties of the query.

Question 79

Agnes has been using XQuery to design queries using path expressions. Her next project will involve multiple source documents and require more complicated criteria. She has heard that a FLWOR structure could be effective for such cases, and comes to you for assistance in developing a FLWOR structure query. Agnes is confused by the rules about how many of each type of clause are required in a FLWOR structure. You tell her that in a FLWOR structure, the _____ clause is optional.

A) where
B) for
C) let
D) return

Question 80

To calculate a summary statistic like a total, enclose the query expression within the _____ function.