MC Consider the following table which maps an XML document to a relational database:
CREATE TABLE NODE(
ID CHAR(6) NOT NULL PRIMARY KEY,
PARENT_ID CHAR(6),
TYPE VARCHAR(9),
LABEL VARCHAR(20),
VALUE CLOB,
FOREIGN KEY (PARENT_ID) REFERENCES NODE (ID)
CONSTRAINT CC1 CHECK(TYPE IN ("element", "attribute"))
);
Which statement is CORRECT? The table is not entirely normalized and still contains redundant information. incorrect Using the above table, every XPath expression can be translated to a corresponding SQL query. incorrect The above table assumes the presence of a DTD or XSD before the mapping can take place. incorrect The table will require extensive querying resources since every single (e.g. XPath) navigation step requires a self-join on this table. correct
MC Which statement is NOT CORRECT? XPath is a simple, declarative language. incorrect Every navigation step in XPath results in a node or list of nodes which can then be used to continue the navigation. incorrect XPath uses path expressions to refer to parts of an XML document. incorrect XPath considers an XML document as a set of XML elements. correct
MC Which statement is NOT CORRECT? RDF allows to use database specific primary keys to identify resources. correct RDF Schema enriches RDF by extending its vocabulary with classes and sub classes, properties and sub properties, and typing of properties. incorrect An RDF data model consists of statements which are in subject-predicate-object format. incorrect An RDF data model can be visualized as a directed, labeled graph. incorrect
MC XML focusses on the... content of documents. correct representation of documents. incorrect
MC Consider the following table which maps an XML document to a relational database:
CREATE TABLE NODE(
ID CHAR(6) NOT NULL PRIMARY KEY,
PARENT_ID CHAR(6),
TYPE VARCHAR(9),
LABEL VARCHAR(20),
VALUE CLOB,
FOREIGN KEY (PARENT_ID) REFERENCES NODE (ID)
CONSTRAINT CC1 CHECK(TYPE IN ("element", "attribute"))
);
Which statement is CORRECT? The table will require extensive querying resources since every single (e.g. XPath) navigation step requires a self-join on this table. correct Using the above table, every XPath expression can be translated to a corresponding SQL query. incorrect The above table assumes the presence of a DTD or XSD before the mapping can take place. incorrect The table is not entirely normalized and still contains redundant information. incorrect
MC Which statement is NOT CORRECT? XML Schema allows to specify minimum and maximum cardinalities. incorrect XML Schema is more verbose than DTD. incorrect XML Schema is not defined using XML syntax. correct Various data types are supported in XML Schema such as xs:string, xs:short, xs:byte, etc. incorrect
MC A key difference between XML data and relational data is that... relational data can be multivalued whereas XML data cannot be multivalued. incorrect relational data is ordered whereas XML data is not ordered. incorrect relational data assumes atomic data types whereas XML data can consist of aggregated types. correct relational data can be nested whereas XML data cannot be nested. incorrect
MC Which statement is NOT CORRECT? XQuery uses XPath path expressions to navigate through the document. incorrect XQuery allows to make use of both the document structure and its content. incorrect The end results of XQuery can be sorted. incorrect XQuery does not allow to join information from different XML documents. correct
MC Consider the following table which maps an XML document to a relational database:
CREATE TABLE NODE(
ID CHAR(6) NOT NULL PRIMARY KEY,
PARENT_ID CHAR(6),
TYPE VARCHAR(9),
LABEL VARCHAR(20),
VALUE CLOB,
FOREIGN KEY (PARENT_ID) REFERENCES NODE (ID)
CONSTRAINT CC1 CHECK(TYPE IN ("element", "attribute"))
);
Which statement is CORRECT? The above table assumes the presence of a DTD or XSD before the mapping can take place. incorrect Using the above table, every XPath expression can be translated to a corresponding SQL query. incorrect The table will require extensive querying resources since every single (e.g. XPath) navigation step requires a self-join on this table. correct The table is not entirely normalized and still contains redundant information. incorrect
MC In an Enterprise Application Integration (EAI) context, asynchronous communication between objects and/or applications can be achieved by means of... Message Oriented Middleware (MOM) correct Remote Procedure Call (RPC) incorrect