MySQL uses MySQL OLD transition variables with triggers to access old data updated
or deleted from a table row.
In Microsoft Visio 2013, a group of template objects is called a stencil.
The IDEF1X default cardinality of a nonidentifying connection relationship is indicated
by a dashed line with a filled-in circle by the child and no other notation.
In the MapReduce process, the Reduce step is followed by the Map step.
Report delivery is more important for data mining than it is for reporting systems.
If a DEFAULT constraint is included when a new column is added to a table, the default
value is only applied to new rows and not to the existing rows at the time the new
column is added.
The Oracle Database FORMAT_DATE function can be used to make sure that Oracle
Database interprets date data correctly.
Most DBMS products will let you define a primary key on a column that contains null
values.
In a 1:N relationship, the term parent refers to the table on the “many” side of the
relationship.
The first attribute of a subtype object is the childID attribute.
The MySQL Command Line Client is the MySQL command line utility.
Semantic objects represent distinct identities.
The 1977 edition of this text contained a chapter on the relational model, and that
chapter was reviewed by E. F. Codd.
Small databases typically have simple structures.
Business Intelligence (BI) systems support operational activities.
A deletion anomaly exists when deleting data about one entity results in the loss of data
about another entity.
The CAP theorem defines the three properties, one of which is authorization.
In an SQL query, a join operation is achieved by specifying the equality of the
respective column names as a condition in the WHERE clause.
Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.
Microsoft Access uses the AutoNumber data type to create surrogate keys.
Recursive M:N relationships are represented with an intersection table that shows pairs
of related rows from a single table.
The SQL wildcard character “#” indicates a single, unspecified character in a specific
location in an SQL query.
The DBMS creates physical records, also called blocks, on its direct access fields.
SQL contains an SQL command RENAME TABLENAME that can be used to change
table names.
Given the functional dependency (A, B) → C, then it is true that A → C and B → C.
The columns of a relation are sometimes called tuples.
Once an ADO.NET dataset is constructed, its contents can be formatted as an XML
document with a single command.
UML is intended for modeling and designing object-oriented programs and
applications.
To open a new Microsoft Access Query window, click the Query Design button on the
Create command.
One of the four categories of NoSQL databases used in the text is the Column Family
database.
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown
above. What does the symbol next to the ORDER entity indicate?
A) A maximum cardinality of “zero”
B) A maximum cardinality of “one”
C) A minimum cardinality of “optional”
D) A minimum cardinality of “required”
When the correct SQL command is used to delete a table’s structure, what happens to
the data in the table?
A) If the deleted table was a parent table, the data is added to the appropriate rows of
the child table.
B) If the deleted table was a child table, the data is added to the appropriate rows of the
parent table.
C) The data in the table is also deleted.
D) Nothing because there was no data in the table since only an empty table can be
deleted.
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
The MySQL keyword to close and exit a cursor is ________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FINISH {CursorName}
D) CLOSE {CursorName}
A deliverable from the requirements analysis step is a ________.
A) user requirements document (URD)
B) user requirements statement (URS)
C) statement of work (SOW)
D) A and sometimes C
We have obtained access to the company’s operational data. In one record, we find that
a customer’s age has been recorded as “337”. This is an example of ________.
A) dirty data
B) inconsistent data
C) non-integrated data
D) a “wrong format” problem
To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT
________.
A) Disable AUTO_INCREMENT
B) Temporarily remove AUTO_INCREMENT
C) Use the AUTO_INCREMENT_INSERT command
D) Both A and C are correct
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) Recursive relationships can be 1:1, 1:N, or M:N relationships.
D) When the relationship is 1:N, a new table must be defined to represent the
relationship.
Data is recorded facts and figures; information is knowledge derived from data.
Recovering a database via rollback involves ________.
A) restoring the database from the save and reprocessing all the transactions since the
save
B) restoring the database from the save and reapplying all the changes made by
transactions since the save
C) undoing the changes made by erroneous or partially processed transactions and
restarting the valid transactions that were in process at the time of the failure
D) re-creating the database by re-entering all of the data from the beginning and, then
reprocessing all of the transactions
Given the functional dependency A → (B, C), A is a(n) ________.
A) independent variable
B) dependent variable
C) determinant
D) composite determinant
In UML, an attribute that is accessible only by methods of its entity class is said to be
________.
A) private
B) exclusive
C) protected
D) public
In the MySQL Table Editor, the abbreviation for Primary Key is ________.
A) PK
B) NN
C) UQ
D) AI
Tables are created in Microsoft Access using the ________ button.
A) Table Design
B) Table Wizard
C) Create Table
D) Create Relation
Computing and storage services offered by various companies over the internet, with
either storage or processing performed remotely, are collectively known as ________.
A) NoSQL databases
B) remote databases
C) cloud computing
D) distributed computing
RFM analysis can be done using SQL ________.
A) user-defined functions
B) stored procedures
C) triggers
D) union queries
Which of the following is a type of OLE DB data provider?
A) Relational data provider
B) Method provider
C) Sequential data provider
D) Tabular data provider
In IDEF1X, a type domain allows ________.
A) different data types
B) different values
C) greater specificity of values
D) default values
The only reason(s) for having relations is to ________.
A) store instances of functional dependencies
B) store equation components
C) store equation results
D) Both B and C are correct
Which SQL statement is used to retrieve view instances?
A) CREATE
B) DELETE
C) INSERT
D) SELECT
The Microsoft Access 2013 Ribbon contains all of the following command tabs except
________.
A) HOME
B) SQL
C) EXTERNAL DATA
D) DATABASE TOOLS
A(n) ________ is a Java program that is interpreted and executed by a bytecode
interpreter on the Web server.
A) applet
B) Java virtual machine
C) servlet
D) JDBC translator
________ is the process of joining two or more tables and storing the result as a single
table.
A) Querying
B) Normalization
C) Denormalization
D) Updating
In Microsoft Visio 2013, we can create database designs using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) We cannot create database designs in Microsoft Visio 2013.
In IDEF1X, extended E-R model weak, but non-ID-dependent relationships are called
________.
A) identifying connection relationships
B) nonspecific relationships
C) category clusters
D) There is no equivalent IDEF1X term.
In Microsoft Access, any relationship between two tables is created ________.
A) by entering the name of the foreign key in the appropriate table in Design View
B) by dragging the primary key column of one table onto the primary key column of the
other table in the Relationships window
C) by dragging the primary key column of one table onto the foreign key column of the
other table in the Relationships window
D) by dragging the foreign key column of one table onto the primary key column of the
other table in the Relationships window
Which of the following is NOT true about the functional dependency A → (X, Y)?
A) X is functionally dependent on A.
B) A determines Y.
C) X and Y together determine A.
D) X and Y are functionally dependent on A.
Discriminators can be ________.
A) attributes
B) entities
C) relationships
D) subtypes
Which SQL keyword is used to add one or more rows of data to a table?
A) DELETE
B) INSERT
C) SELECT
D) UPDATE
One limitation of the Oracle Data Import Wizard is that it ________.
A) does not allow addition of a new primary key column
B) does not allow data to be imported into an existing table
C) does not allow import of “date” type data
D) only allows import of data from Microsoft Excel, no other formats
Keys may include all of the following except ________.
A) primary keys
B) unique secondary keys
C) nonunique secondary keys
D) nonunique primary keys
What is XML, and why is it significantly better than HTML?
What is an XML Schema?
Explain the essence of normalization that is implemented through the use of normal
forms.
Briefly describe how Oracle Database implements serializable transaction isolation.
Include an example.
What is reverse engineering and how well does it work?
Briefly describe NetBeans.
What is the Microsoft Office Fluent User Interface?
What is the process and what are the considerations when changing a table name?
Distinguish between the four cursor types.
What are IDEF1X domains?
Explain why it is important to learn SQL.
What is a Microsoft Excel PivotTable?
Distinguish between entity identifiers and keys.
Explain how to run an SQL query in Microsoft Access.
Why do databases need redesigning?
Discuss SQL data types.
What are SQL triggers and how are they used?
What are Business Intelligence (BI) systems?
The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
Explain the use of the SQL statement CREATE TABLE. Do NOT discuss the ALTER
statement in your answer, but DO include an example based on the SALESREP table in
the General Sales database.
What is the Oracle Enterprise Manager Database Express?