The SQL Server DBMS supports the SQL BEFORE trigger.
The default Web page for the IIS Web server is index.html.
In Microsoft Visio 2013, a group of template objects is called a stencil.
Column family databases that use column families and super column families contain
keyspaces.
To force the DBMS to remove duplicate rows from the results of an SQL SELECT
query, the keyword DISTINCT must be used.
In Microsoft Visio 2013, we can create database designs using Entity and Dynamic
connector objects.
A stored program that is attached to a table or view is called a stored procedure.
In Microsoft Visio 2013, Relationship connector objects can be formatted with the line
end symbols needed to create IE Crow’s Foot notation.
By separating data into tables containing data on only one theme each, making changes
to the data is simplified.
For a workstation running the Windows operating system, all the necessary user file
system permissions to the Web page area are already granted.
Most data mining techniques are simple and easy to use.
All actions in an atomic transaction are completed successfully or none of the actions
are completed at all.
Microsoft Access 2013 switchboards are built in a report window in Microsoft Access
2013.
Every DBMS product uses the same API.
Microsoft Visio 2013 can be used to create data models, but not database designs.
A report that is sent to users only upon the users’ request is called an on-demand report.
In XML Schema, there are two types of elements, simple and composite.
Data Mining uses sophisticated statistical and mathematical techniques to perform
what-if analyses, to make predictions, and to facilitate decision making.
An SQL virtual table is called a view.
In SQL, the order of the rows that result from a SELECT statement can be set using the
SORT BY phrase.
Column family databases are indistinguishable from relational database tables.
SQL views are constructed from SELECT statements.
Business Intelligence (BI) systems support operational activities.
All recursive relationships are 1:1.
Report modes include dynamic and static.
In SQL, the LIKE keyword can be used to select on partial values.
SQL views can be used to hide rows.
With Oracle Database, using a sequence does not guarantee valid surrogate key values.
With ODBC, a file data source is available only to the user that created it.
The SQL statement DROP VIEW ViewName is used to delete a view from a database.
To be considered a composite key, a key must contain at least two attributes.
Data models are created during the component design step.
SQL triggers are used for providing default values, validity checking, updating views,
and performing referential integrity actions.
To create a new MySQL Workbench EER model, you can use the New Model link on
the Home page.
Business Intelligence (BI) systems are information systems that help users analyze and
use data.
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.
E) None of the above
When using Microsoft Access and IIS, a basic Web home page name that we should use
even if we need to change IIS settings is:
A) AWebPage.htm.
B) index.html.
C) MyWebPage.htm.
D) MyWeb.htm.
E) MyPage.htm.
A candidate key is:
A) required to be unique.
B) used to represent rows in relationships.
C) a candidate to be the primary key.
D) Both A and B
E) All of the above
A(n) ________ is an information system that helps users analyze and use data.
In Microsoft Visio 2013, we can create supertype/subtype relationships in data models
using:
A) Entity and Dynamic connector objects.
B) Table and Relationship connector objects.
C) Category and Dynamic connector objects.
D) Category and Relationship connector objects.
E) There are no separate objects to create supertype/subtype, so we use standard
objects.
Business Intelligence (BI) reporting systems are used to filter data, sort data, group data
and make simple calculations based on the data.
In many-to-many relationships in a relational database design, ________.
A) the key of the child is placed as a foreign key into the parent
B) the key of the parent is placed as a foreign key into the child
C) the keys of both tables are placed in a third table
D) the keys of both tables are joined into a composite key
E) C and D
Business Intelligence (BI) ________ are used to filter data, sort data, group data and
make simple calculations based on the data.
A stored program that is attached to the database is called ________.
A) a CHECK constraint
B) a view
C) embedded SQL
D) a trigger
E) a stored procedure
Problematic data include so-called “dirty data.”
Preventing multiple applications from obtaining copies of the same record when the
record is about to be changed is called:
A) serialized reading.
B) lost updating.
C) concurrent processing.
D) resource locking.
E) block factoring.
The default file format for Microsoft Access 2013 database files is the:
A) Access 2007 format.
B) Access 2003 format.
C) Access XP format.
D) SQL Server format.
E) XBD format.
Based on the tables below, which of the following SQL commands would create an
SQL view named CustomerSalesRep that could be used to display CustNo, CustName,
RepName?
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
A) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER;
B) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
C) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
D) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
E) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
Which of the following is not included in Michael Porter’s list of primary or operational
activities?
A) Procurement
B) Inbound logistics
C) Manufacturing operations
D) Outbound logistics
E) All of above are considered primary or operational activities.
When an SQL SELECT statement is used to retrieve data from a view instance, the
maximum number of columns that can be specified in the SELECT is the same as the
number of columns:
A) in the table underlying the view.
B) in the VIEW specification.
C) in the ORDER BY clause.
D) in the HAVING clause.
E) that have aliases.
One of the important properties of a column is whether or not it is ________.
A) found in more than one entity
B) required
C) character or numeric
D) subject to normalization
E) subject to denormalization
One important relational design principle is that:
A) every determinant must be a candidate key.
B) every candidate key must not be a determinant.
C) every primary key must be a surrogate key.
D) every determinant must be functionally dependent on the primary key.
E) every primary key must be functionally dependent on every determinant.
Logging into the MySQL Community Server 5.6 DBMS is done using:
A) the Connect to Server command.
B) the Connect to Server dialog box.
C) the Connect to MySQL Server command.
D) the Connect to MySQL Server dialog box.
E) None of the above is correct.
We have obtained access to the company’s operational data. We have been asked to
produce a report with an item by item analysis of sales, but the only sales figure
available is the total sale value for each order. This is an example of:
A) dirty data.
B) inconsistent data.
C) nonintegrated data.
D) a “wrong format” problem.
E) a “too much data” problem.
Information can be defined as:
A) data presented in a meaningful context.
B) knowledge derived from data.
C) data processed by summing, ordering, averaging, grouping, comparing or other
similar operations.
D) A and B
E) A, B and C
Which of the following is a reason that operational data are difficult to read?
A) Dirty data
B) Missing values
C) Non-integrated data
D) Both A and B
E) All of the above
Which of the following is not true of recursive relationships?
A) When the recursive relationship is M:N, an intersection table is created.
B) The rows of a single table can play two different roles.
C) The techniques for representing the tables are the same as for non-recursive
relationships except the rows are in the same table.
D) Recursive relationships can be 1:1, 1:N, or M:N relationships.
E) Even when the relationship is 1:N, a new table must be defined to represent the
relationship.
To format a PivotTable in Excel 2013, we use the:
A) Design command tab in the PivotTable Tools contextual command tab.
B) Format command tab in the PivotTable Tools contextual command tab.
C) Design command tab in the Report Tools contextual command tab.
D) Format command tab in the Report Tools contextual command tab.
E) Report Tools command tab.
When Oracle Database Express Edition 11g Release 2 is installed, the Oracle Database
ODBC client is:
A) installed automatically as part of the installation.
B) installed manually as a separate part of the installation process.
C) not installed and must be downloaded and installed manually.
D) not installed because there is no ODBC client for Oracle Database 11g Release 2
Express Edition.
E) Either A or B
When Microsoft Access 2013 compiles VBA code in a database, the database file will
be a(n):
A) *.accdb file.
B) *.accdc file.
C) *.accde file.
D) *.mdb file.
E) *.mdw file.
Which of the following is true when representing a 1:1 binary relationship using the
relational model?
A) The key of the entity with the highest minimum cardinality must be placed in the
other entity as a foreign key.
B) The key of each entity must be placed in the other as a foreign key.
C) The key of either entity is placed in the other as a foreign key.
D) The key of the entity with the most attributes must be placed in the other entity as a
foreign key.
E) Both entities must have the same primary key.
An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
The name of the SQL Server 2014 ODBC client as it appears in the ODBC Data Source
Administrator is:
A) SQL Server ODBC Client 2014.
B) ODBC Driver 11 for SQL Server.
C) SQL Server Native Client 2008.
D) SQL Server Native Client 2008 R2.
E) SQL Server Native Client 11.0.
Business Intelligence (BI) systems do which of the following?
A) Analyze current and past activities
B) Predict future events
C) Record and process transactions
D) Both A and B
E) All of the above
Which of the following is not a stage in the development of a database system?
A) Requirements analysis
B) Validation
C) Component design
D) Implementation
E) All of the above are stages in the development of a database system.
Which of the following would not be an example of database metadata?
A) Names of tables in a database
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
E) Queries against records in the database tables
Which of the following is not an SQL trigger?
A) BEFORE UPDATE
B) INSTEAD OF UPDATE
C) BEFORE INSERT
D) INSTEAD OF CONSTRAINT
E) AFTER DELETE
When a transaction functions in such a way that either all of the transaction actions are
completed or none of them will be, the transaction is said to be:
A) consistent.
B) isolated.
C) atomic.
D) locked.
E) logical.
The Microsoft Access 2013 form editor is a(n):
A) banded form editor.
B) wizard-based form editor.
C) ASCII form editor.
D) WYSIWYG form editor.
E) Web-based form editor.
To create a relationship in Microsoft Access, we drag and drop the ________ of a table.
What requirements must a two-dimensional table satisfy in order to be a relation?
BI ________ are intended to create meaningful information from disparate data sources
and to deliver that information to the proper users on a timely basis.
The DBMS controls ________ by ensuring that one user’s work does not
inappropriately interfere with another user’s work.
What is a slowly changing dimension?
SQL query results are displayed in a tabbed ________ window.
Describe how to use Microsoft Access and IIS in Web database processing applications.
A variant of the star schema is the ________.
Explain the concept of a foreign key.
Explain the pragmatic reason for using surrogate keys.
An important reason for using SQL Server 2014 Express is that it has ________.
Market basket analysis, as described in the text, uses the statistical technique of
________.
Data warehouses are populated with data prepared by ________ programs.
The SQL statement ________ is used to modify a view.
To run an SQL query, click the ________ button.
The values of existing data can be modified using the SQL ________ command, which
can be used to change several column values at once.
Microsoft Access 2013 ________ allow easy mock-ups of forms and reports for
prototyping.