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
Management
Q:
The incremental design process:
A) is very useful in creating simple databases
B) uses a strategy of adding tags and templates one at a time
C) begins with creating an initial entry in the database
D) all of the above
Q:
A template for a video source:
A) for one video will generally work for all other video sources
B) containing an attribute without an equal sign and some value in quotes does not require modification
C) replaces the URL copied from the iframe text with the "{@url}" reference
D) all of the above
Q:
In the XSL specification, the <xsl:apply-templates/> tag:
A) is required in all templates
B) requests processing of the items within the template tags
C) requires a closing tag
D) all of the above
Q:
Templates:
A) describe how the information is to look without actually having the information
B) are part of the XML database file
C) use JavaScript in describing how the information is to be displayed
D) must be included for every tag used in the XML database file
Q:
A transformer:
A) converts all tags in the XML file to HTML
B) is part of the browser software
C) matches the XML tag to its template in the XSL file
D) all of the above
Q:
Which statement is incorrect?
A) Relational databases can record irregular data that XML databases cannot.
B) Relational databases use queries to display information we want to see.
C) Relational databases are much more structured than XML databases.
D) All statements are correct.
Q:
An XSL file includes:
A) the standard XML tag at the end of the file
B) XML tags throughout the file
C) XHTML tags
D) all of the above
Q:
Style information:
A) tells the browser how to display a markup language like XML
B) in HTML can be included in an external file with a .css extension
C) in XML can be included in an external file with .xsl as the file extension
D) all of the above
Q:
An XML stylesheet is specified for an XML file using the tag:A) <$stylesheet…>B) <?xml-stylesheet…>C) <##style…>D) <xml-stylesheet…>
Q:
The apply tag is what kind of tag?
A) paired
B) singleton
C) special
D) closed
Q:
If the transformer encounters a tag in the XML file that does not have a matching template in the XSL file, the information will not be displayed on the page.
Q:
In the XSL file, the <pic> tag is a stand-alone tag that requires the <xsl:apply-templates/> tag.
Q:
In the XSL file, the @ symbol is the XSL reference to the tag attribute of the XML tag.
Q:
When considering the design of the XML, we must specify different data for each type of content.
Q:
In creating an XML database using an incremental approach, the first step would be developing tags and templates.
Q:
As the transformer is processing an XML file, anything that it finds that is not a tag"that is, the actual data"it puts directly into the HTML definition.
Q:
An <html> tag with no attributes is correct when used in XSL templates.
Q:
The XSL file includes at least two templates for each tag in the XML tree.
Q:
An XML file uses XHTML to describe how the information in the XSL file is to be displayed.
Q:
When writing XML, a word processing program, e.g., Microsoft Word, should be used so that color coding will be added automatically to help verify the structure.
Q:
The root element is the Collective tag enclosing all items in an XML file.
Q:
In an XSL file, the <xsl:stylesheet...> tag is the root element and must be closed with the </xsl:stylesheet> tag at the end of the file.
Q:
An SQL ________ query can perform any or all of the operations on tables.
Q:
The ________ rule states that you should group data referencing an entity together.
Q:
The ________ rule states that you should label data with tags consistently.
Q:
A(n) ________ is a database command defining a table expressed using the five database operators.
Q:
Database ________ allow us to ask questions of a database in a way that lets the software find the answer for us.
Q:
The ________ defines the form of the information that can be stored in a field.
Q:
The attributes of an entity in a database should satisfy the _______ rule in XML design.
Q:
XML stands for the ________ Language.
Q:
The ________ operation is used to remove from one table the rows that are also listed in a second table.
Q:
________ are the operations that transform a physical database into a logical one.
Q:
The design of a(n) ________ database is guided by technical considerations, while the design of a(n) ________ database is guided by personal considerations of the users.
Q:
A technique called ________, is available to us in the Microsoft Access system. The user fills in a template, and the software generates the SQL.
Q:
The ________ operation combines two tables.
Q:
The ________, or view of the database, is the form of the database the users see and is created on demand from existing information.
Q:
The physical database is designed by ________.
Q:
A(n) ________ is a correspondence between two tables of a database.
Q:
The ________ operation builds a new table from the columns of an existing table.
Q:
The ________ is a collection of table definitions that gives the name of the table, lists the attributes and their data types, and identifies the primary key.
Q:
XML tags cannot contain:
A) spaces
B) uppercase letters
C) lowercase letters
D) numbers
Q:
XML must be written using a:
A) word processor
B) text editor
C) Web browser
D) spreadsheet program
Q:
An attribute or set of attributes that could potentially be chosen as the table's key is a:
A) primary key
B) secondary key
C) candidate key
D) provisional key
Q:
Rules for writing XML include:
A) a required first line that identifies an XML file
B) tags and attributes not case sensitive
C) element names can contain letters, numbers, and special symbols
D) all of the above
Q:
Relationships in a database schema show how:
A) data types of all attributes within each table relate to each other
B) queries are related to one another
C) information in a table is related to information in another table
D) fields are related to one another in a table
Q:
The Select operation on tables is often combined with the ________ operation to"trim" base tables.
A) Join
B) Project
C) Union
D) Add
Q:
Relationships:
A) are not relevant in building the logical database
B) establish a correspondence between the columns within a table
C) should be given meaningful names to assist those who work with the database
D) all of the above
Q:
The encoding rules of XML include the:
A) Affinity Rule: Group Related Data
B) Identification Rule: Label Data with Tags Consistently
C) Collection Rule: Group Related Instances
D) all of the above
Q:
Logical tables are created from a:
A) view
B) query
C) relationship
D) key
Q:
Assume that you will use the Product operation on table A (five attributes) table B (three attributes). The resulting supertable will have:
A) fifteen attributes
B) ten attributes
C) eight attributes
D) two attributes
Q:
What operation takes rows from one table to create a new table?
A) Project
B) Union
C) Select
D) Difference
Q:
What operation combines two tables based on matching fields?
A) Join operation
B) Bind operation
C) Combine operation
D) Unite operation
Q:
A logical database:
A) is created from existing information
B) is created fresh each time it is needed
C) may combine information from multiple tables
D) all of the above
Q:
Which is true about a row in a table?
A) A technical term for a row is a tuple.
B) A row is often called a record.
C) A row is an entity instance, defining one particular object.
D) All of the above
Q:
The key field for the student database on a campus is probably the student:
A) address
B) ID
C) phone
D) last name
Q:
A database table is technically called a relation.
Q:
A database table may not contain multiple identical rows; all its rows must differ.
Q:
An XML file is just an alternative notation for a database schema.
Q:
A table is defined with a specific set of attributes; among the instances of any table is the "empty instance."
Q:
Every relational database can be described by XML; likewise, anything described by XML is a relational database.
Q:
XML is easy and intuitive because it is a self-describing language.
Q:
A root element is the tag that encloses all of the content of the XML file.
Q:
In relational databases, think of an attribute as a "column of a table," where the "attribute names" are column headings and "attribute values" are the entries.
Q:
To successfully use a database, a user must be able to write SQL.
Q:
A logical table can be created with information from no more than two physical tables.
Q:
Queries are used to create views.
Q:
The logical database shows users the view of the information that they need and want.
Q:
The logical database is the permanent repository of the data.
Q:
Relationships are specified by the user of a database.
Q:
Relationships are part of the metadata of a database.
Q:
Relationships connect rows of one table with rows of another table.
Q:
Inconsistency is the main reason to avoid redundancy of information in a database.
Q:
The Advanced Filtering facility allows multiple ________.
Q:
Use ________ to select only certain rows from a list.
Q:
A(n) ________ is a named alternative to a spreadsheet based on different inputs.
Q:
________ formulas can make the entire computation of a cell contingent on the outcome of a condition.
Q:
________ formatting controls the display of the contents in spreadsheet cells based on the values stored in the cell.
Q:
What method is used to access subsets of information?
A) logging
B) conditional formatting
C) sorting
D) filtering
Q:
The Scenario Manager window is accessed via the:
A) Tools menu
B) File menu
C) Edit menu
D) Formulas menu
Q:
A word or a phrase assigned to a cell or range of cells is called its:
A) value
B) name
C) literal
D) range id