Deck 25: Big Data

Question 1

SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

Answer 1

True

Question 2

JSON stands for Jason Script Object Notation.

Answer 2

False

Question 3

DTD stands for Document Type Declaration.

Answer 3

True

Question 4

XML designers created a system that allows document structure,data content,and materialization to be mixed.

Question 5

One of the four categories of NoSQL databases used in the text is the Column Family database.

Question 6

XML provides a standardized,non-customizable way to describe the content of a document.

Question 7

All type-valid XML documents are required to have a DTD.

Question 8

One of the four categories of NoSQL databases used in the text is the Word Processing database.

Question 9

The CAP theorem defines the three properties,one of which is partition tolerance.

Question 10

A document database may use either XML or JSON as the basis for storing data.

Question 11

The key-value database uses columns.

Question 12

One of the four categories of NoSQL databases used in the text is the Graphical database.

Question 13

The CAP theorem defines the three properties,one of which is consistency.

Question 14

NoSQL really stands for "Not only SQL."

Question 15

The CAP theorem defines the three properties,one of which is authorization.

Question 16

XML documents that do not conform to their DTD are said to be non-type-valid XML documents.

Question 17

One of the four categories of NoSQL databases used in the text is the Key-Value database.

Question 18

XML stands for Extensible Markup Language.

Question 19

XML documents that conform to their DTD are said to be type-valid XML documents.

Question 20

Unlike SQL views,XML views are not limited to one multivalued path.

Question 21

A complex element must have more than one simple element.

Question 22

Graph databases are composed of three elements,one of which is the edge.

Question 23

XML documents and XML Schemas are created in different languages.

Question 24

Graph databases are composed of three elements,one of which is the attribute.

Question 25

XML documents that conform to an XML Schema are validated against that schema.

Question 26

The CAP Theorem defines three properties of distributed database systems,which are ________.

A)consistency,always-on,properties
B)competency,always-on,properties
C)consistency,availability,partition tolerance
D)competency,availability,partition tolerance

Question 27

In XML Schema,the default cardinality of elements is 0.1.

Question 28

Graph databases are composed of three elements,one of which is the node.

Question 29

An example of a key-value database is ________.

A)DynamoDB
B)Couchbase Server
C)Bigtable
D)Neo4j

Question 30

DBMSs associated with the NoSQL movement use all of the following kinds of database management systems except ________.

A)Key-Value
B)Document
C)Relational
D)Graph

Question 31

In XML Schema,the default minimum cardinality can be overridden using the minOccurs attributes.

Question 32

For database/XML applications,a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.

Question 33

XML Schemas consist of elements,attributes,and properties.

Question 34

Column family databases that use column families and super column families contain keyspaces.

Question 35

XML Schema is a synonym for Document Type Declaration (DTD).

Question 36

An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.

Question 37

In XML Schema,there are two types of elements,simple and composite.

Question 38

An example of a document database is ________.

A)Dynamo
B)Couchbase Server
C)Bigtable
D)Neo4j

Question 39

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Question 40

Column family databases may use columns,super columns,column families,and super column families.

Question 41

Which of the following is a type of element in an XML Schema?

A)Simple
B)Composite
C)Compound
D)Primitive

Question 42

XML stands for ________.

A)Experimental Markup Language
B)Extendable Markup Language
C)Extensible Markup Language
D)Active X-control Markup Language

Question 43

Which of the following is true about XML?

A)It allows the confounding of document structure,content,and format.
B)It is non-standardized to allow for extension by developers.
C)The structure of documents is formally defined.
D)XML tags,like some HTML tags,are vague and arbitrary.

Question 44

XML Schema is used to define ________.

A)document content and structure
B)XQL queries
C)DOM-compliant parsers
D)DTDs

Question 45

An important improvement of XML Schema over DTDs is that ________.

A)XML Schema can be stored external to the document
B)XML Schema support XQL queries
C)XML Schema are XML documents
D)XML Schema are not required

Question 46

SOAP originally stood for ________.

A)Simple Operational Application Protocol
B)Standard Operational Application Protocol
C)Simple Object Application Protocol
D)Simple Object Access Protocol

Question 47

XML documents that conform to their DTD are said to be ________.

A)type-valid
B)XML-valid
C)DTD-compliant
D)not-type-valid

Question 48

XML documents can be ________ against their XML Schema.

A)measured
B)grown
C)validated
D)browsed

Question 49

An example of a graph database is ________.

A)Dynamo
B)Couchbase Server
C)Bigtable
D)Neo4j

Question 50

The document type declaration for an XML document begins with the keyword ________.

A)XML
B)DTD
C)TYPE
D)DOCTYPE

Question 51

XML documents that are not-type-valid can still be ________.

A)DTD-valid
B)XML-valid
C)DTD-compliant
D)proper XML documents

Question 52

The first section of an XML document might be a ________.

A)Document Definition Section (DDS)
B)Document Type Declaration (DTD)
C)Data Type (DTYPE)
D)Document Type (DOCTYPE)

Question 53

SOAP has become ________.

A)just a name,not an acronym
B)a standard protocol for sending any type of message
C)an old technology replaced by XML
D)Both A and B are correct

Question 54

Which of the following is not true about document type declarations for XML documents?

A)They are not required.
B)They are required for type-valid documents.
C)They cannot be contained inside the XML document.
D)Storing the DTD externally allows many documents to be validated against the same DTD.

Question 55

In database/ XML applications,it is a recommended practice that ________.

A)elements carry data,and attributes carry metadata
B)elements carry metadata,and attributes carry data
C)elements and attributes carry data,and the XML Schema carry metadata
D)elements and attributes carry metadata,and the XML Schema carry data

Question 56

The XML Schema statement xmlns:xsd indicates that ________.

A)this XML Schema uses a labeled namespace called xsd
B)this XML Schema is validated at www.xsd.com
C)this XML Schema is validated at www.xmlns.com using the xsd XML Schema located there
D)this XML Schema is using a non-standard looping procedure,where xsd is the variable name of the loop increment

Question 57

XML Schemas consist of ________.

A)elements
B)attributes
C)properties
D)Both A and B are correct

Question 58

The default cardinality for elements in an XML Schema is ________.

A)0)1
B)1)1
C)1)N
D)M)N

Question 59

The use of the XML Schema expression minOccurs="0" ________.

A)is an XML Schema default
B)is required as there are no defaults in an XML Schema
C)is similar to the SQL schema NULL constraint
D)indicates that no value can be placed there

Question 60

XML Schema elements of the complexType may contain ________.

A)one primitive element
B)at most one complexType element
C)any number of simple elements but no complex elements
D)any combination of simple and complex elements

Question 61

Which of the following is true about XSLT?

A)It can be used to materialize XML documents into HTML.
B)XSLT processors are context oriented.
C)It is a non-declarative transformation language.
D)Both A and B are correct

Question 62

Specify the four categories of NoSQL databases used in the text,and give an example of each.

Question 63

In a column family database,the unit of data that most closely corresponds to a relation is the ________.

A)column
B)timestamp
C)column family
D)keyspace

Question 64

Which of the following is not true about XSLT?

A)It requires the use of CSS.
B)It is a transformation language.
C)It can materialize XML documents into HTML.
D)It is a declarative language.

Question 65

In the following sample document data (presented in MongoDB syntax),how many documents are there? {
_id: "Advisor1",
Name: "Shire,Robert",
Dept: "History",
YearHired: 1975
}
{
_id: 555667777,
Name: "Tierney,Doris",
Majors: ["Music","Spanish"],
Addresses: [
{
Street: "14510 NE 4th Street",
City: "Bellevue",
State: "WA",
Zip: "98005"
},
{
Street: "335 Aloha Street",
City: "Seattle",
State: "WA",
Zip: "98109"
}
],
AdvisorID: "Advisor1"
}

A)2
B)4
C)6
D)8

Question 66

What does NoSQL stand for,and what does it mean?

Question 67

Graph databases are composed of ________.

A)Nodes,Properties,and Edges
B)Properties,Columns,and SuperColumns
C)Edges,Nodes,and Tables
D)Nodes,Columns,and Properties

Question 68

In a key value database,the basic "get" operation ________.

A)retrieves all values in the database
B)retrieves all keys with a specified value
C)retrieves all values associated with a key
D)retrieves the value associated with a key

Question 69

The "value" in a key value database can be ________.

A)any string value only
B)any numeric value only
C)any value of any size or type
D)any list of values only

Question 70

In the following sample JSON data (presented in MongoDB syntax),the word "addesses" is a ________. {
_id: 555667777,
Name: "Tierney,Doris",
Majors: ["Music","Spanish"],
Addresses: [
{
Street: "14510 NE 4th Street",
City: "Bellevue",
State: "WA",
Zip: "98005"
},
{
Street: "335 Aloha Street",
City: "Seattle",
State: "WA",
Zip: "98109"
}
],
AdvisorID: "Advisor1"
}

A)value list
B)object identifier
C)field name
D)value

Question 71

What is the CAP theorem,and what does it show?

Question 72

The SQL Server statement SELECT *
FROM Table01
FOR XML RAW
Tells SQL Server to place the data values from the columns in the table into XML ________.

A)elements
B)attributes
C)either elements or attributes,as chosen by SQL Server
D)either elements or attributes,as designated by the developer

Question 73

The SQL Server statement SELECT *
FROM Table01
FOR XML EXPLICIT
Tells SQL Server to place the data values from the columns in the table into XML ________.

A)elements
B)attributes
C)either elements or attributes,as chosen by SQL Server
D)either elements or attributes,as designated by the developer

Question 74

One important difference between a relation and a column family is that ________.

A)the rows in a column family can have different numbers of columns
B)the columns in a column family are unnamed
C)all values in a column family must have the same timestamp
D)values in a column family must be strings

Question 75

What is an XML Schema?

Question 76

The SQL Server XML SELECT statements can be applied to ________.

A)single table SELECT statements
B)multiple table SELECT statements
C)XML Schema statements
D)Both A and B are correct

Question 77

What is an XML DTD?

Question 78

What is XML,and why is it significantly better than HTML?

Question 79

JSON has sophisticated data structuring capabilities.Which of the following statements is not true about JSON?

A)A value can be a simple value such as a string or number.
B)A value can be an object (a set of [field,value] pairs).
C)A value can be an array of objects.
D)A value can be a relational table.

Question 80

Document databases typically base their data structuring features on ________.

A)JSON
B)XML
C)relations
D)Both A and B are correct