A Java Virtual Machine must be installed on a computer before running the NetBeans
IDE.
The cardinalities of an attribute operate only between the attribute and the container of
the attribute.
In market basket analysis, lift is confidence divided by support.
Problematic data are called dirty data.
Domain/key normal form requires that every constraint be a logical consequence of the
definition of domains and keys.
A complex network cannot be decomposed into trees or simple networks.
In Microsoft Visio 2013, both data models and database designs are created using the
Database Model Diagram template.
The largest databases in e-commerce are the order entry databases.
In general, the best type of ODBC data source to define for a Web application is a
system data source.
In a linked list, the sequence field holds the address of the next record in the logical
sequence.
Microsoft Windows users should install MySQL Community Edition using the MySQL
Installer for Windows.
To display an existing SQL script, click the “Open an SQL script file (in new query
tab)” button.
XSLT is a robust and powerful transformation language that can be used to materialize
XML documents into HTML.
An applet is a Java bytecode program that executes on the Web server.
SQL Server bulk-logged recovery differs from other log-based recovery methods
because it does not include log entries for changes that cause large log entries.
JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the
compiled version of the page.
Locks with large granularity are easy for the DBMS to administer but frequently cause
conflicts.
An entity instance of an entity class is the representation of a particular entity and is
described by the values of the attributes of the entity.
JSON stands for Jason Script Object Notation.
SQL views are constructed from SELECT statements.
In RFM analysis, M stands for “how much money.”
A weak entity is an entity that cannot exist in the database without (and is logically
dependent upon) another type of entity also existing in the database.
Schema is the MySQL synonym for database.
In Microsoft Access, relationships between tables are created in the Relationships
window.
OLE DB can be used to access ODBC data sources.
Structured storage column families are indistinguishable from relational database
tables.
In market basket analysis, confidence is the probability that one particular product will
be purchased.
Table column characteristics can be edited in the MySQL Table Editor.
A simple network can be represented using linked lists and indexes.
A candidate key is one of a group of keys that may serve as the primary key in a
relation.
When examining data values as a part of assessing table structure, you should try to
determine functional dependencies.
Graph databases are composed of three elements, one of which is the node.
Data mining uses sophisticated statistical and mathematical techniques to perform
what-if analyses, to make predictions, and to facilitate decision making.
In today’s E-R models, attributes of relationships are still used.
Data is facts and numbers.
A star schema resembles a star, with a dimension table at the center and fact tables
radiating out from the center.
A table that meets the definition of a relation is in ________.
A) First Normal Form
B) Second Normal Form
C) Third Normal Form
D) Boyce-Codd Normal Form
The problem of misspelled data entries is really the same as ________.
A) the multivalue, multicolumn problem
B) the inconsistent values problem
C) the missing values problem
D) the general-purpose remarks column problem
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate),
which of the following is not a valid ANSI SQL command?
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE ‘Ja%’;
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
C) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;
D) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
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 Relationship connector objects
D) There are no separate objects to create supertype/subtype, so we use standard
objects.
Virtualization is an attempt to do a better job of using which hardware resources in a
computer?
A) Memory and monitors
B) CPU and memory
C) Operating system
D) Database tables
Which of the following is not a good reason for designing a data model?
A) It’s easier to change things in the data model than it is in the actual DBMS.
B) The data model provides a simplified view of the database that can be shown to
people who don’t need to see all the details.
C) Creating a data model will help you understand the application area better.
D) The data model can be discarded after the database is operational.
An important property of B-Trees is that they are balanced to maintain efficient and
predictable performance. “Balanced” here means that ________.
A) every pointers allows access to the same number of data records
B) the numbers at every level of the B-Tree have the same average value
C) the key field values are the same at every level
D) every data record is the same distance from the top entry of the B-Tree
The task of diagnosing errors due to changes in the database structure is eased by
________.
A) formal policies for requesting changes
B) database structure change documentation
C) rollback analysis
D) configuration control
The industry standard supported by all major DBMSs that allows tables to be joined
together is called ________.
A) Sequential Query Language (SQL)
B) Structured Question Language (SQL)
C) Structured Query Language (SQL)
D) Standard Question Language (SQL)
The Oracle Database PL/SQL block structure begins with ________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) LOOP
One remedy for the inconsistencies caused by concurrent processing is ________.
A) concurrency
B) checkpointing
C) rollback
D) resource locking
One Business Intelligence (BI) reporting system that uses extensions to SQL is
________.
A) cluster analysis
B) OLAP
C) regression analysis
D) RFM analysis
The default Web page for the IIS Web server is ________.
A) startup.html
B) startup.htm
C) index.htm
D) iisstart.htm
In Microsoft Visio 2013, when the Entity object is placed in a diagram, it is labeled as
a(n) ________.
A) entity
B) table
C) relationship
D) dynamic connector
In an SQL query, which built-in function is used to compute the number of rows in a
table?
A) AVG
B) COUNT
C) MAX
D) SUM
The column(s) that is/are the primary key in an SQL table are indicated by ________
when viewed graphically in Enterprise Manager.
A) the black arrow symbol
B) the outline arrow symbol
C) the key symbol
D) being underlined
Microsoft Access SQL commands are run in ________.
A) the SQL window
B) the QBE window
C) the SQL View of a Query window
D) the Design View of a Query window
The SQL keyword IS NULL can be used to help ________.
A) count the number of columns in a table
B) count the number of rows in a table
C) count the number of null values in a column
D) count the number of values in a column
The Microsoft Access application generator is not responsible for ________.
A) creating forms
B) creating reports
C) creating queries
D) creating tables
A simple object is a semantic object that contains only ________.
A) single-value, simple or group attributes
B) single-value, object attributes
C) single-value, simple attributes
D) multi-value, simple or group attributes
Which of the following illustrates the authors’ preferred style of defining a primary key?
A) CREATE TABLE CUSTOMER (
CustomerID Integer Primary Key
LastName Char(35) Not Null
First Name Char(25) Null
);
B) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35) Not Null
First Name Char(25) Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
);
C) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35) Not Null
First Name Char(25) Null
);
ALTER TABLE CUSTOMER
ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);
D) Both B and C are correct
With SQL Server, a nonclustered index does not contain data but has pointers to the
data.
When transforming an ID-dependent E-R data model relationship into a relational
database design and the parent entity has a surrogate primary key and the child entity
has a data identifier, then the primary key of the child table should be ________.
A) the parent’s surrogate key + the child’s data key
B) the parent’s surrogate key + a surrogate key in the child
C) either A or B will work, but method A is preferable
D) either A or B will work, but method B is preferable
SQL Server user variables and parameters start with the symbol ________.
A) @@
B) #
C) ##
D) @
This database component can be used as part of applications and for administration
tasks.
A) Tables
B) Metadata
C) Triggers
D) Stored procedures
What type of JDBC driver translates JDBC calls into DBMS-independent network
protocols?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
To change a table name, we ________.
A) use the SQL RENAME TABLE command
B) use the SQL ALTER TABLENAME command
C) use the SQL MODIFY TABLENAME command
D) create a new table, move the data, and drop the old table
One advantage of using the CONSTRAINT phrase to define a primary key is that the
database designer controls the ________.
A) name of the table
B) name of the foreign key field
C) name of the constraint
D) name of the primary key field
For a Web server running the Windows operating system, the Web server typically used
is ________.
A) the IIS Web server
B) the Apache Web server
C) the Tomcat Web server
D) the ASP.NET Web server
Which SQL keyword is used to change the structure, properties or constraints of a
table?
A) SET
B) CREATE
C) SELECT
D) ALTER
Linked lists can be used to keep records in ________.
A) logical order
B) physical order
C) sequential order
D) pseudo order
Stored procedures have all these advantages except ________.
A) greater security
B) faster development
C) SQL optimized by the DBMS compiler
D) code sharing