Locks placed by a command issued to the DBMS from the application program are
called explicit locks.
Sequenced Query Language (SQL) is an internationally recognized standard language
that is understood by all commercial database management system products.
A passive data repository is preferred over an active repository because it requires less
human intervention.
The prefix :old is used to make previous values of columns available to update and
delete triggers.
Arithmetic in SQL statements is limited to the operations provided by the built-in
functions.
The prefix :new is used to make final values of columns available to insert and update
triggers.
In order to minimize the need to change table names, some organizations have a policy
that no user or application should ever employ the true name of a table, but use views as
table aliases instead.
The problem with a general-purpose remarks column is that the data it contains are
likely to be verbal, inconsistent, and stored in a verbose manner.
One example of a database design using a strong relationship is the multivalued
attribute pattern.
E-R modeling recognizes both relationship classes and relationship instances.
With SQL Server, only one clustered index is allowed per table.
The authors refer to the data model produced by reverse engineering as the RE data
model.
Every subquery can be alternatively expressed by a join.
Data can be entered directly into a table in Enterprise Manager or via SQL INSERT
statements submitted through the Microsoft SQL Server Management Studio.
A transaction is a group of alternative database actions, from which the database can
choose to perform only one of them.
The NetBeans IDE supports PHP directly without any plugins.
The SQL built-in function MOST obtains the largest value in a numeric column.
The Oracle Database GUI tool used for application development is the Oracle SQL
Developer.
If the parent is required, then a new child row must be created with a valid foreign key
value.
In a snowflake table, each dimension table is normalized.
The SQL keyword DELETE is used to delete a table’s structure.
Users should create a folder to hold EER models created with the MySQL Workbench.
A relation is in Boyce-Codd Normal Form (BCNF) if and only if it is in 3NF and every
determinant is a candidate key.
In the Microsoft SQL Server Management Studio, the starting value for a field that has
been set as an IDENTITY in SQL Server is set in the seed (StartingValue) property.
An entity class is described by the structure of the entities in that class.
A relation that is in domain/key normal form is assured to be free from all anomalies.
The SQL DELETE TABLE statement can be used to remove unneeded tables after the
normalized tables are created and populated.
Group attributes are composites of other attributes.
The first step in assessing table structure is to count rows and examine columns.
The essence of normalization is taking a relation that is not in BCNF and breaking it
into multiple relations such that each one is in BCNF.
INSTEAD OF triggers are placed on views.
The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.
A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined
by the entire primary key.
To represent a tree structure using indexes, store each 1:N relationship as an index.
User interviews are conducted during the requirements analysis step.
The problem of misspelled data entries is an entirely different problem than the
inconsistent values problem.
Most Microsoft Access 2013 commands and tools are available on the tabbed Ribbon.
A relation is in second normal form (2NF) if and only if it is in 1NF and ________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every candidate key is a determinant
In the UML-style entity class ORDERS shown above, “GetOrderNo( )” is a ________.
A) private method
B) protected method
C) public constraint
D) public method
A Customer Resource Management (CRM) system is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) digital dashboard
When reviewing a table in the SQL Server GUI tools, which property should be set to
“Yes” to indicate that the column is a surrogate key for which SQL Server should
automatically supply values?
A) Identity
B) Surrogate
C) AutoIncrement
D) AutoNumber
SQL views are not used ________.
A) to hide columns
B) to show results of computed columns
C) to hide complicated SQL statements
D) to enforce primary key constraints
For database development, a challenge to the relational model and the use of SQL is
known as ________.
A) the Web services movement
B) the NoSQL movement
C) the SOAP movement
D) the XML movement
When two transactions are being processed against the database at the same time
________.
A) they are called concurrent transactions
B) they are usually interleaved
C) they always result in a lost update problem
D) Both A and B are correct
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
The MySQL statement to store a stored procedure in the database is ________.
A) CREATE PROCEDURE
B) ALTER PROCEDURE
C) DROP PROCEDURE
D) CLOSE PROCEDURE
When running an SQL query that uses EXISTS, the EXISTS keyword will be true if
________.
A) any row in the subquery meets the condition
B) all rows in the subquery meet the condition
C) no row in the subquery meets the condition
D) any row in the subquery fails to meet the condition
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown
above. What does the symbol next to the CUSTOMER 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”
Which of the following is not a step in the database design process?
A) Create tables and columns from entities and attributes
B) Select primary keys
C) Represent relationships
D) Create constraints and triggers
In an SQL query, which SQL keyword actually begins the query?
A) EXISTS
B) FROM
C) SELECT
D) WHERE
If the values in an SQL view are changeable through the view itself, which SQL
statement is used to change the values?
A) CREATE
B) DELETE
C) INSERT
D) UPDATE
In general, for Web applications it is best to create what type of data source on the Web
server?
A) File
B) User
C) Shared
D) System
Which of the following is not true of data repositories?
A) They are usually created after the database has been implemented and optimized for
performance.
B) They may be virtual.
C) They may contain metadata about database applications.
D) They may contain metadata about users.
Slowly changing dimensions are handled by a(n) ________.
A) operational database
B) dimensional database
C) structured storage
D) object-relational data model
To place a table in a MySQL database design, start by clicking the ________.
A) Table button
B) Entity button
C) Place a New Table button
D) Place a New Entity button
Which of the following is a task performed by the driver according to the ODBC
standard?
A) Determines the appropriate DBMS
B) Validates the format of the ODBC command received from the application
C) Converts data source error codes into ODBC standard error codes
D) Converts the data source into an SQL-compliant data structure
Database designs are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
Given the functional dependency A → B, then it is necessarily true that B → A.
Microsoft Access is a personal database system, and a personal database system is
characterized by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application
generator
C) the DBMS not supporting indexes
D) the DBMS product being limited to a maximum of ten tables in any given database
The SQL query data results are displayed ________.
A) in the Navigator window
B) in a tabbed Result Grid
C) in a Messages window
D) in a tabbed Action Output window
The SQL Server default when creating a new database is to create ________ for each
database.
A) one data file and one log file
B) one data file and two log files
C) two data files and one log file
D) There is no defaultthe database creator must specify how many data files and log
files will be created.
In a three-tier or n-tier architecture, which type of JDBC driver can be used if the
DBMS and the Web server are running on the same computer?
A) Only Type 1 and Type 2
B) All four Types
C) Only Type 3 and Type 4
D) Only Type 2 and Type 3
To create an OLAP report for an SQL Server 2014 database, we can build a PivotTable
in ________.
A) Microsoft Access 2013
B) Microsoft Word 2013
C) Microsoft Visio 2013
D) Microsoft Excel 2013
Each of the following is an example of a cloud computing platform except ________.
A) SQL Server 2014 Express
B) Amazon Web Services
C) Google Business Solutions
D) Windows Azure
The actions that an object can perform are called ________.
A) procedures
B) collections
C) methods
D) properties
To open a new Microsoft Access Query window ________.
A) click the New button on the Home command tab
B) click the New Query button on the Home command tab
C) click the Create Query button on the Create command tab
D) click the Query Design button on the Command tab
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
Which of the following is a type of recovery model supported in SQL Server in which
all database changes are logged?
A) Bulk logged
B) Full
C) Simple
D) Complete
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate),
which of the following would find all employees whose name begins with the letter “S”
using standard SQL?
A) SELECT *
FROM EMPLOYEE
WHERE Name IN [‘S’];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE ‘S’;
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE ‘S*’;
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE ‘S%’;
What cardinality format is used in UML-style E-R diagrams?
What does NoSQL stand for, and what does it mean?
What is an XML DTD?
When assessing table structure, how do you determine the number and types of
columns in a table?
Briefly describe how a developer defines the type of locking behavior to be used with
SQL Server.
What is a set?
Describe the MySQL Connector/ODBC and how to install it.
Briefly describe the process of converting an extended E-R model into a relational
database design.
Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance),
write the standard SQL query to retrieve the Name and PhoneNumber of customers
whose name begins with ‘S’.
Explain denormalization, and why it may be appropriate to denormalize a set of tables.
Briefly describe the components of the ODBC architecture.
What are the advantages and disadvantages of normalization?
What are Business Intelligence (BI) systems?
Briefly describe PHP.
When using Microsoft Visio 2013, how do we create a blank diagram for use with a
data model?
How are one-to-one recursive relationships addressed using the relational model?