Data warehouses are populated with data prepared by Extract, Transform, and Load
(ETL) systems.
In general, the overall responsibility of the DBA is to facilitate the development and use
of the database system.
To represent an IS-A relationship in a relational database design, the IS-A relationship
must be converted into a HAS-A relationship.
In Microsoft Visio 2013, the Crow’s Foot Database Notation stencil objects include a
Category object.
The developer can direct SQL Server to create indexes on non-key fields.
In SQL Server, the full recovery model creates a log entry for every change to the
database.
The EXISTS keyword will be true if any row in the subquery meets the condition.
With Oracle Database, stored procedures can be invoked remotely.
The values in an SQL view are always changeable through the view itself.
The movement that uses different database methods than the relational model and/or
SQL is called the NoSQL movement.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that
have the same value in a column.
One or more rows can be added to a table by using the SQL INSERT statement.
The supremetype entity contains the attributes that are common to all subtypes.
A doubly nested set of NOT EXISTS SELECT statements can be used to find rows that
meet some specified condition for every row in a table.
A set of SQL statements stored in an application written in a standard programming
language is called embedded SQL.
In representing a 1:N relationship in a relational database design, the key of the table
representing the parent entity is placed as a foreign key in the table representing the
child entity.
ADO was (and still is) frequently used for database applications.
When transforming an ID-dependent E-R data model relationship into a relational
database design where the child entity is designed to use a surrogate key, the
relationship changes to a weak but not ID-dependent relationship.
Whether or not an attribute is required is determined during the database modeling
phase.
The DBA is responsible for managing changes to the database structure, but is rarely
involved in the original design of the structure.
A data mart is a collection of data that addresses a particular component of a functional
area of a business.
The multivalued dependency noted as A → → B, means that the value of A determines
a set of values of B.
The presence of one or more foreign keys in a relation means that we cannot eliminate
duplicated data in that table.
MySQL users are created on the Users and Privileges page in the MySQL Workbench.
A surrogate key is an artificial column that is added to a relation to be its primary key.
Relations are sometimes left unnormalized to improve performance.
Data warehouses often include data purchased from outside vendors.
The type of failure that occurs when Oracle Database is unable to write to a physical
file is called a media failure.
The SQL command SELECT is used to retrieve view instances.
If the values in an SQL view are not changeable through the view itself, you may still
be able to update the view by using unique application logic. In this case, the specific
logic is placed in an INSTEAD OF trigger.
Saying that two entities are functionally dependent means that ________.
A) the entities are always connected by a mathematical equation
B) for one of the entities, if we are given the value of that entity, we can determine the
value of one other entity
C) for both of the entities, if we are given the value of one entity, we can determine the
value of the other entity
D) the functional dependency will have to be removed through normalization
The second step in assessing table structure includes ________.
A) counting rows
B) examining columns
C) examining data values
D) A and B
Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables. If
you want to find all employees who are also customers, which SQL keyword would you
most likely use?
A) INTERSECT
B) UNION
C) EXCEPT
D) UNION ALL
PDO stands for ________.
A) PHP Data Objects
B) PHP Design Objects
C) Personal Data Objects
D) Personal Design Objects
The SQL Server GUI interface database management program is the ________.
A) Enterprise Manager
B) Query Analyzer
C) Microsoft SQL Server Management Studio
D) Both A and B are correct
The Microsoft Access data type of AutoNumber is used when there is a specific need
for a ________.
A) foreign key
B) primary key
C) surrogate key
D) secondary key
A database is considered self-describing because ________.
A) all the users’ data is in one place
B) it reduces data duplication
C) it contains a description of its own structure
D) it contains a listing of all the programs that use it
Data mining applications are used to accomplish all of the following tasks except
________.
A) perform what-if analysis
B) make predications
C) facilitate decision making
D) update the database
The MySQL statement used to repeat a set of SQL statements as long as some condition
is true is ________.
A) LOOP
B) BEGIN
C) IF…THEN.ELSE…END IF
D) REPEAT
Which of the following cannot be enforced in the DBMS or application programs?
A) Processing rights
B) Security
C) Processing responsibilities
D) Cursors
E) Transaction isolation
One of the goals of an object-relational database is to allow ________ to persist in the
database.
A) data structures
B) objects
C) methods
D) Java variables
Which of the following does a Statement of work (SOW) typically not contain?
A) Non-functional requirements (speed and time, capacity and reliability)
B) An identification of who will do the work
C) The objectives of the work to be done
D) The location of where the work will be done
The default cursor concurrency setting for a static cursor in SQL Server is ________.
A) SCROLL_LOCK
B) Optimistic
C) Serializable
D) Read only
During the second step of assessing table structure, you are trying to determine
________.
A) multivalued dependencies
B) data types
C) missing values
D) subqueries
Which type of lock still allows other transactions to have read-only access to the locked
resource?
A) Exclusive lock
B) Shared lock
C) Explicit lock
D) Implicit lock
Because SQL stored procedures allow and encourage code sharing among developers,
stored procedures give database application developers all these advantages except
________.
A) less work
B) standardized processing
C) specialization among developers
D) faster query response times
When making any change to the database structure, we may need to check for effects of
the change on any of the following except ________.
A) data
B) foreign keys
C) ad-hoc SQL queries
D) triggers
When one SQL query is embedded in another SQL query, this is referred to as a
________.
A) subquery
B) join
C) WHERE Query
D) subset query
Which of the following database systems is not enterprise-class?
A) Microsoft SQL Server
B) Microsoft Access
C) Oracle Database
D) IBM DB2
For a number of reasons, ________ is not often an advantage for a read-only database.
A) updating
B) normalization
C) denormalization
D) Both A and B are correct
Which SQL keyword is used to delete a table’s structure?
A) DELETE
B) DROP
C) DISPOSE
D) ALTER
Which of the following is true about making changes to the database structure?
A) The DBA need not get input from users on the issue because it is a technical
decision.
B) Formal policies and procedures for requesting a change are not used because they
are too limiting.
C) Documentation of when the change was made, how it was made, and why it was
made must be created.
D) Changes do not produce unexpected results because the DBA will have investigated
the change thoroughly before implementing it.
When decreasing cardinalities, there will always be ________.
A) relationship loss
B) foreign key loss
C) data loss
D) default value loss
Which of the following would a DBA typically NOT do in managing the DBMS?
A) Analyze system performance statistics
B) Install new versions of the operating system, as needed
C) Evaluate new DBMS product features
D) Tune DBMS product options to accommodate other software in use
RFM analysis analyzes and ranks customers based on ________.
A) their purchasing patterns
B) their income status
C) their residential location
D) Both A and B are correct
Operational databases store historical data.
The first step in using a JDBC driver is to ________.
A) establish a connection to the database
B) load the driver
C) create a statement
D) call the DriverManager object
________ is a DBMS that provides a full set of object-relational features.
A) Oracle Database
B) Microsoft Access
C) Microsoft SQL Server 2014
D) MySQL
A determinant that determines all the other columns in a relation is a ________.
A) record
B) surrogate key
C) foreign key
D) candidate key
Each physical record is addressed by its ________.
A) relative record number (RRN)
B) sequential record number (SRN)
C) transaction record number (TRN)
D) ultimate record number (URN)
Indexes are data structures that speed searching of database data.
Anytime you want to use an SQL Server reserved word as a user identifier, enclose it in
________.
A) { }
B) [ ]
C) ( )
D) < >
Which of the following is an account name for which you are asked to enter a password
when Oracle Database creates a new database?
A) ORACLE
B) SYS
C) INTERNAL
D) DBA
Referential integrity constraints are implemented in SQL using the ________ syntax.
A) PRIMARY KEY
B) FOREIGN KEY
C) DEFAULT
D) UNIQUE
The authors recommend using which of the following folder structures with the MySQL
Workbench?
A) ..\MyDocuments\MySQL Workbench\EER Models
B) ..\MyDocuments\MySQL Workbench\Schemas
C) ..\MyDocuments\MySQL Workbench\Databases
D) Both A and B are correct.
What is OOP persistence, and how is it indicated in UML-style E-R diagrams?
Explain sequences and their relationship to surrogate keys. Include an example.
What are referential integrity constraints? Give an example.
Distinguish between an entity class and an entity instance.
The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
Explain the use of the of SQL keyword SELECT. Include an example based on the
CUSTOMER table in the General Sales database.
What are general-purpose remarks columns, and why are they a problem?
What is embedded SQL, and what considerations are necessary when using it in an
application?
What is a dependency graph, and what is it used for in database redesign?
Briefly describe the function of an application program in a database system.
Describe the Microsoft Access 2013 Navigation Pane.
Explain the process of using optimistic locking.
What Microsoft Access file format is used by default in Microsoft Access 2013? When
was it introduced, and what was the previous format?
What are SQL Built-in Functions?
What is the CAP theorem, and what does it show?
What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?
What is a slowly changing dimension? Include an example.
Explain the MySQL cursor statements.
Explain the relationships among primary keys and functional dependencies.
The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
What is an SQL view, and what is it used for? Include an example based on the
CUSTOMER table of the General Sales Database.