Q&A Hero

Design

Q: Databases based on the CODASYL standard are based on the network data model.
Q: A database system is typically defined as its four components: users, database applications, the DBMS and the databases.
Q: Small databases typically have simple structures.
Q: The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful.
Q: The largest databases in e-commerce are the order entry databases.
Q: Databases are a key component of e-commerce order entry, billing, shipping and customer support.
Q: Enterprise Resource Planning (ERP) is an example of a data mining application.
Q: What are the elements of a graph database?
Q: What is an XML Schema?
Q: What is an XML DTD?
Q: What is XML, and why is it significantly better than HTML?
Q: What is the CAP theorem, and what does it show?
Q: Specify the four categories of NoSQL databases used in the text, and give an example of each.
Q: What does NoSQL stand for, and what does it mean?
Q: 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
Q: 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.
Q: 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
Q: 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
Q: 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) 2B) 4C) 6D) 8
Q: Document databases typically base their data structuring features on ________. A) JSON B) XML C) relations D) Both A and B are correct
Q: 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
Q: 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
Q: 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
Q: 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
Q: 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
Q: 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
Q: 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
Q: 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.
Q: 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
Q: The default cardinality for elements in an XML Schema is ________. A) 0.1 B) 1.1 C) 1.N D) M.N
Q: 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
Q: 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
Q: Which of the following is a type of element in an XML Schema? A) Simple B) Composite C) Compound D) Primitive
Q: XML Schemas consist of ________. A) elements B) attributes C) properties D) Both A and B are correct
Q: The XML Schema statement xmlns:xsd indicates that ________. A) this XML Schema uses a labeled namespace calledxsd 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
Q: 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
Q: XML documents can be ________ against their XML Schema. A) measured B) grown C) validated D) browsed
Q: XML Schema is used to define ________. A) document content and structure B) XQL queries C) DOM-compliant parsers D) DTDs
Q: 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.
Q: XML documents that are not-type-valid can still be ________. A) DTD-valid B) XML-valid C) DTD-compliant D) proper XML documents
Q: XML documents that conform to their DTD are said to be ________. A) type-valid B) XML-valid C) DTD-compliant D) not-type-valid
Q: The document type declaration for an XML document begins with the keyword ________. A) XML B) DTD C) TYPE D) DOCTYPE
Q: 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)
Q: 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.
Q: 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
Q: SOAP originally stood for ________. A) Simple Operational Application Protocol B) Standard Operational Application Protocol C) Simple Object Application Protocol D) Simple Object Access Protocol
Q: XML stands for ________. A) Experimental Markup Language B) Extendable Markup Language C) Extensible Markup Language D) Active X-control Markup Language
Q: An example of a graph database is ________. A) Dynamo B) Couchbase Server C) Bigtable D) Neo4j
Q: An example of a document database is ________. A) Dynamo B) Couchbase Server C) Bigtable D) Neo4j
Q: An example of a key-value database is ________. A) DynamoDB B) Couchbase Server C) Bigtable D) Neo4j
Q: 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
Q: 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
Q: Graph databases are composed of three elements, one of which is the edge.
Q: Graph databases are composed of three elements, one of which is the attribute.
Q: Graph databases are composed of three elements, one of which is the node.
Q: Column family databases that use column families and super column families contain keyspaces.
Q: Column family databases may use columns, super columns, column families, and super column families.
Q: In XML Schema, the default minimum cardinality can be overridden using the minOccurs attributes.
Q: In XML Schema, the default cardinality of elements is 0.1.
Q: For database/XML applications, a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.
Q: A complex element must have more than one simple element.
Q: In XML Schema, there are two types of elements, simple and composite.
Q: XML Schemas consist of elements, attributes, and properties.
Q: An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.
Q: XML documents and XML Schemas are created in different languages.
Q: XML documents that conform to an XML Schema are validated against that schema.
Q: XML Schema is a synonym for Document Type Declaration (DTD).
Q: XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.
Q: XML documents that do not conform to their DTD are said to be non-type-valid XML documents.
Q: XML documents that conform to their DTD are said to be type-valid XML documents.
Q: All type-valid XML documents are required to have a DTD.
Q: DTD stands for Document Type Declaration.
Q: XML designers created a system that allows document structure, data content, and materialization to be mixed.
Q: SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.
Q: Unlike SQL views, XML views are not limited to one multivalued path.
Q: XML provides a standardized, non-customizable way to describe the content of a document.
Q: JSON stands for Jason Script Object Notation.
Q: XML stands for Extensible Markup Language.
Q: A document database may use either XML or JSON as the basis for storing data.
Q: The key-value database uses columns.
1 2 3 … 68

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts