To use an SQL Server reserved word as a user identifier, it must be enclosed in square
brackets [ ].
The values of a surrogate key have no meaning to the users.
The termset refers to all records having the same nonunique secondary key.
In the MySQL Table Editor, the abbreviation AI stands for AUTO_INCREMENT.
The SQL keyword MODIFY is used to change a column value.
The process of reading an actual database schema and producing a data model from that
schema is called reverse engineering.
dBase was the first PC-based DBMS to implement true relational algebra on a PC.
In RFM analysis, R stands for “how recently”, F stands for “how frequently” and M
stands for “how many months.”
Design guidelines and priorities are the same whether you’re working with an updatable
database or a read-only database.
Java programs are compiled into machine-independent bytecode.
For a workstation running the Windows operating system, all the necessary user file
system permissions to the Web page area are already granted.
Changing table names is complicated by the fact that constraints and triggers are often
associated with the table and will also need to be changed.
When the child entity is required (M) in a relationship, there needs to be at least one
child row for each parent row at all times.
BI reporting systems summarize the current status of business activities and compare
that status with past events but not with predicted future activities.
The design transformation for all IS-A relationships can be summarized by the phrase
“place the key of the parent table in the child table.”
A relation can have only one candidate key.
The MySQL Workbench EER models are data models.
With ODBC, a database and the DBMS that processes it are identified by the data
source.
The MySQL block structure defines variables with the BEGIN keyword.
PL/SQL is a programming language for SQL Server that adds programming constructs
to the SQL language.
ODBC has not had practical success, but has shown great potential for future
development.
The NOT EXISTS keyword will be true if any row in the subquery fails to meet the
condition.
An object identifier is one or more attributes that the users employ to identify object
instances.
An intersection record is a record that is created when a complex network is
decomposed into a simple network.
SOONER and LATER triggers are placed on tables.
The MySQL END statement is used to complete the basic SQL block structure.
The Oracle Enterprise Manager Database Express 12c is a Web-based Oracle Database
administration utility.
Cluster analysis is a commonly used technique in supervised data mining.
The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.
The relational model was first proposed in 1970 by E. F. Codd at IBM.
If the SQL statement
SELECT C1, C2, C3
FROM T4
WHERE C2 = ‘Smith’;
is frequently executed, which column(s) should be considered for indexing based only
on the statement itself?
A) C1 only
B) C2 only
C) C3 only
D) C1 and C2
To use an SQL Server 2014 database in an Microsoft Excel 2013 PivotTable, it is
generally useful to ________.
A) create a view in SQL Server 2014 to organize the data
B) store the needed data in an Excel worksheet
C) store the needed data in a Word document
D) store the needed data in a Visio diagram
To create a MySQL index using SQL, the correct SQL statement is ________.
A) ALTER TABLE {TableName} ADD INDEX {IndexName}
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}
C) CREATE INDEX {IndexName} ON TABLE {TableName}
D) Both A and C are correct
The data model produced by reverse engineering is a true conceptual schema.
The predecessor(s) of database processing was (were) ________.
A) file managers
B) hierarchical models
C) network models
D) the relational data model
To add a NULL column to a table, we ________.
A) use the REVISE TABLE command
B) use the ALTER TABLE command
C) use the MODIFY TABLE command
D) create a new table with the NULL column, move the other data, and drop the old
table
Which of the following Oracle Database ReDo files are stored on disk and contain the
rollback segments from recent database changes?
A) OnLine ReDo files
B) Active ReDo files
C) OffLine ReDo files
D) Archive ReDo files
OLAP stands for ________.
A) Online Analytical Processing
B) Offline Analytical Processing
C) Online Analysis Process
D) Offline Analytical Process
E) Lazy, Old And Particular
DBMS products represent trees using all of the following except ________.
A) indexes
B) linked lists
C) sequential lists
D) secondary lists
An example of a key-value database is ________.
A) DynamoDB
B) Couchbase Server
C) Bigtable
D) Neo4j
Which of the following is true about the SQL Server Import and Export Wizard?
A) The spreadsheet data must already be normalized in order to be imported.
B) There may be problems importing Excel 2013 data and we may need to install Excel
2007 compatibility software.
C) The Import and Export Wizard sometimes creates blank rows at the end of the
imported table.
D) Both B and C are correct.
A compound object is a semantic object that contains at least one ________.
A) single-value, group attribute
B) multi-value, simple or group attribute
C) object attribute
D) multi-value attribute
An entity whose identifier includes the identifier of another entity is a(n) ________.
A) strong entity
B) weak entity
C) optional entity
D) required entity
Which of the following different copies of the database schema is typically not used in
the database redesign process?
A) Small test database
B) Data warehouse database
C) Operational database
D) Large test database
When representing a 1:1 relationship in a relational database design, ________.
A) the key of each table must be placed as foreign keys into the other
B) the key of either table may be placed as a foreign key into the other
C) the key of both tables must be the same
D) the intersection table gets the key from both relations
In the MySQL Workbench, a 1:N non-identifying relationship between two tables that
do not contain the needed primary and foreign keys is created using ________.
A) the 1:N Identifying Relationship button
B) the 1:N Non-identifying Relationship button
C) the N:M Identifying Relationship button
D) the Place a Relationship Using Existing Columns button
In a column family database, the unit of data that most closely corresponds to a relation
is the ________.
A) column
B) timestamp
C) column family
D) keyspace
How does an application determine the level of ODBC conformance available from a
driver?
A) The application makes a call to the driver manager.
B) The application makes a call to the data source.
C) The application makes a call to the driver.
D) The developer must determine the level of conformance before the application is
written.
Which of the following is an SQL trigger Microsoft SQL Server supports?
A) BEFORE
B) INSTEAD OF
C) AFTER
D) Both B and C are correct
The coding for Java Server Pages must be written in ________.
A) Java
B) JavaScript
C) C++
D) Both A and B are correct
Business Intelligence (BI) reporting systems are used to filter data, sort data, group
data, and make simple calculations based on the data.
Which of the following is the default transaction isolation level offered by Oracle
Database?
A) Read Committed
B) Serializable
C) Repeatable Read
D) Read Only
Database redesign is fairly easy when ________.
A) information systems and organizations influence each other
B) the design was done correctly the first time
C) there is no data in the database
D) good backups of the database are available
In Microsoft Visio 2013, we can create data models using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) We cannot create data models in Microsoft Visio 2013.
To start Microsoft Access 2013 in Windows 8, use the command ________.
A) Start | Microsoft Access 2013
B) Start | Microsoft Office | Microsoft Access 2013
C) Start | All Programs | Microsoft Access 2013
D) No commanduse the Microsoft Access 2013 app tile
Each of the following is an example of a data structure except ________.
A) binary relationship
B) sequential list
C) linked list
D) index
XML documents can be ________ against their XML Schema.
A) measured
B) grown
C) validated
D) browsed
To represent an archetype/instance pattern in an E-R model, ________.
A) create a new ID-dependent entity with a 1:N relationship
B) create a new weak, but not ID-dependent entity with a 1:N relationship
C) create a new strong entity with a 1:1 relationship
D) create a new ID-dependent entity with a 1:1 relationship
Read-only databases seldom use more than one copy of a set of the same data.
SQL Server system function names start with the symbol ________.
A) @@
B) #
C) ##
D) @
In an SQL query, which of the following symbols is used by ANSI SQL to represent a
single unspecified character?
A) _ (underscore)
B) ? (question mark)
C) * (asterisk)
D) % (percent)
In the database redesign process, before proceeding with the redesign it is often useful
to ________.
A) check whether certain conditions or assumptions about the data are valid
B) find out why the design was not done properly the first time
C) stop information systems and users from influencing each other
D) set standards for user behavior
The SQL Server statement
SELECT *
FROM Table01
FOR XML RAW
tells SQL Server to place the data values from the columns in the table into XML
________.
A) elements
B) attributes
C) elements or attributes, as chosen by SQL Server
D) elements or attributes, as designated by the XML Schema
Explain the terms relation, tuple, and attribute.
Explain the MySQL Block Structure.
What is data mining application?
In Microsoft Visio 2013, how do we create data models?
Describe how to add a table object to a MySQL Workbench database design.
What activities take place during the component design step of the systems
development life cycle (SDLC)?
Explain the SQL Server IDENTITY constraint.
What is the purpose of a database, and how does the database accomplish this purpose?
What are inconsistent values, and why are they a problem?
What is the MySQL Table Editor?
When redesigning a database, how can we check assumptions about functional
dependencies?
What is the MySQL Workbench?
What is MySQL?
How does Michael Porter define primary or operational business activities? What do
they include?
Explain how to create a relationship in Microsoft Access. Include an example.
When accessing table structure, how do you determine how many rows are in a table?
Explain the MySQL control-of-flow statements.
What is the SQL CLR?
The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
CUSTOMER
Explain the use of the SQL keyword LIKE. Include an example based on the
CUSTOMER table from the General Sales database; use at least one wildcard.
Describe the requirements that a table must meet to qualify as a relation.