MySQL concurrency options include four transaction isolation levels: READ
UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and
SERIALIZABLE.
The names of tables to be joined in an SQL query are listed in the FROM clause.
Candidate keys are called interlocking candidate keys when they share one or more
attributes.
A relation is a table that has special restrictions on it.
Business Intelligence (BI) reporting systems summarize the current status of business
activities and compare that status with past events, but not with predicted future
activities.
To drop a foreign key column from a table, no preliminary steps are needed and we can
simply use the ALTER TABLE DROP COLUMN statement.
Reports that do not change once prepared are called static reports.
One means of processing an SQL Server database is to save groups of SQL Server
DBMS commands in a text file and then process this file in the Microsoft SQL Server
Management Studio.
With ODBC, the driver manager serves as an intermediary between the application and
the DBMS drivers.
The name TRANSACTION is so special to SQL Server that no stored procedures will
work on a table with that name.
The first step in the database design process is to create tables and columns from
entities and attributes.
In Oracle Database recovery facilities, OnLine ReDo files are maintained on disk and
contain the rollback segments from recent database changes.
Like a database table, a spreadsheet has rows and columns.
All weak entities must have a minimum cardinality of 1 on the entity on which it
depends.
To sort the rows of the result table, the ORDER BY clause is specified.
Association tables sometimes connect more than two entities.
Business Intelligence (BI) systems obtain data in three different ways.
When transforming an extended E-R model into a relational database design, recursive
relationships are treated fundamentally the same as other HAS-A relationships.
In RFM analysis, R stands for “how recently.”
When you are given a set of tables and asked to create a database to store their data, the
first step is to assess the tables’ structure and content.
Business Intelligence (BI) systems typically store their data in data warehouses.
The most widely used Web server for all operating systems is Internet Information
Services (IIS).
When transforming a data model into a relational design, relationships of all degrees are
treated as combinations of binary relationships.
A subtype inherits all the attributes of its parent.
In XML Schema, there are two types of elements, simple and composite.
It is possible to have a relation that does not have a key.
A constraint that requires an instance of an entity to exist in one relation before it can be
referenced in another relation is called an insertion anomaly.
In a real sense, information systems and organizations do not just influence each other,
but rather they create each other.
If the values in an SQL view are changeable through the view itself, the SQL command
UPDATE is used to change the values.
In a 1:N relationship, the term parent refers to the N side of the relationship.
The data model produced by reverse engineering may include some entities that should
not appear in the data model.
The MySQL IF statement is used to test for a condition and then direct which blocks of
code should be run depending on the outcome of the test.
Applications usually write data directly to the database.
In UML notation, the relationship line in a relationship with an ID-dependent weak
entity is labeled as <id-dependent>.
Rollforward and reprocessing are two different names for the same technique.
A database stores ________.
A) data
B) relationships
C) applications
D) Both A and B are correct
A table with columns PhoneNumber01, PhoneNumber02, and PhoneNumber03 is likely
to have ________.
A) the multivalue, multicolumn problem
B) the inconsistent values problem
C) the missing values problem
D) the general-purpose remarks column problem
SQL triggers can be used when the DBMS receives a(n) ________ request.
A) INSERT
B) SELECT
C) ALTER
D) CREATE
When transforming an E-R data model into a relational database design, the key of the
parent entity should be placed as part of the primary key into the child entity ________.
A) when the child entity is ID-dependent
B) when the child entity is non-ID-dependent
C) when the child entity has a 1:1 relationship with the parent entity
D) when the child entity has a 1:N relationship with the parent entity
To count the number of rows in a table, use the SQL construct ________.
A) SELECT *
B) SELECT TOP n *
C) SELECT COUNT(TOP n)
D) SELECT COUNT(*)
Which of the following is not a characteristic that was introduced to E-R diagramming
by UML?
A) Class attributes
B) Relationship attributes
C) Visibility of attributes
D) Methods
The document type declaration for an XML document begins with the keyword
________.
A) XML
B) DTD
C) TYPE
D) DOCTYPE
In Microsoft Access, the relationship between two tables is not actually created until
________.
A) the OK button in the Create Relationships dialog box is clicked
B) the Create button in the Create Relationships dialog box is clicked
C) the OK button in the Edit Relationships dialog box is clicked
D) the Create button in the Edit Relationships dialog box is clicked
Snowflake schemas have normalized ________.
A) fact tables
B) dimension tables
C) map tables
D) reduce tables
The MySQL keyword used to retrieve a row of data while the cursor is operating is
________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FETCH
D) CLOSE {CursorName}
During the data import process in Oracle, if some of the spreadsheet cells in a column
of the source data are empty, ________.
A) you must put some data in them before importing
B) you must not specify this column as a foreign key later
C) you must ensure the data type for this column is numeric
D) you must check the “Nullable” box in the wizard
The SQL Server statement
SELECT *
FROM Table01
FOR XML EXPLICIT
tells SQL Server to place the data values from the columns in the table into XML
________.
A) elements
B) attributes
C) either elements or attributes, as chosen by SQL Server
D) either elements or attributes, as designated by the developer
Which of the following can only interact with relational database and table-like data
structures?
A) OLE DB
B) ODBC
C) ASP
D) ADO
SQL queries that use EXISTS and NOT EXISTS are ________.
A) normal subqueries
B) correlated subqueries
C) uncorrelated subqueries
D) constraint dependent subqueries
To set a column value to an initial value that is selected according to some business
logic, you would use ________.
A) the SQL DEFAULT constraint with the CREATE TABLE command
B) an SQL view
C) embedded SQL
D) an SQL trigger
When representing a one-to-many relationship in a relational database design,
________.
A) the parent is always on the one side of the “one-to-many” relationship
B) the child is always on the one side of the “one-to-many” relationship
C) either parent or child can be on the one side of the “one-to-many” relationship, and
the choice is arbitrary
D) either parent or child can be on the one side of the “one-to-many” relationship, and
special criteria indicate which table should be on the one side
Which of the following statements is true about Web 2.0?
A) It requires the Android Operating System.
B) It allows users to add content to Web sites.
C) Twitter and Facebook are examples of Web 2.0 sites.
D) Both B and C are correct
A data source that is fully SQL-compliant would use what type of DBMS driver?
A) Single-tier
B) Multiple-tier
C) SQL transform
D) Text-based
In IDEF1X, extended E-R model subtype entities are called ________.
A) generic entities
B) category entities
C) nonspecific entities
D) category clusters
An example of a graph database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
For database development, the most important Web-related technology to emerge in
recent years is ________.
A) FTP
B) HTTP
C) XML
D) OODBMS
In relational database design, ID-dependent entities are not used to ________.
A) represent N:M relationships
B) handle associative relationships
C) represent relationships where the child identifier does not include the key of the
parent
D) handle archetype/instance relationships
Which of the following is a common unsupervised data mining technique?
A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) QBE queries
The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is
________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) LOOP
Which of the following is not a component of a data warehouse?
A) Data extract, transform, and load (ETL) preparation programs
B) Data warehouse data
C) Operational database updates
D) Data warehouse metadata
The MySQL statement to change a stored procedure already stored in the database is
________.
A) CREATE PROCEDURE
B) ALTER PROCEDURE
C) DROP PROCEDURE
D) CLOSE PROCEDURE
Attributes may be ________.
A) complete
B) optional
C) multivalued
D) required
In UML, an attribute preceded by a(n) ________ is “protected.”
A) <persistent>
B) #
C) –
D) +
The SQL function COUNT ________.
A) counts the number of columns in a table
B) counts the number of rows in a table
C) counts the number of tables in a database
D) counts the number of updates to a database
When dropping a foreign key column from a table, which of the following steps is (are)
included in the process? (The order of the steps listed below is not relevant, only the
steps themselves.)
A) Drop the foreign key constraint from the table
B) Drop the foreign key column from the table
C) Drop the primary key in the other table referenced by the referential integrity
constraint
D) Both A and B are correct
Which of the following is not true about a relation?
A) Has rows containing data about an entity
B) Has columns containing data about attributes of the entity
C) Has cells that hold only a single value
D) Can have two identical rows
A database consists of integrated tables, which store ________.
A) reports
B) data and relationships among the data
C) forms
D) Both A and C are correct
Which of the following is a GUI tool for application development with Oracle
Database?
A) The Oracle Enterprise Manager Database Express
B) The Oracle SQL*Plus command utility program
C) The Oracle SQL Developer
D) The Oracle Database Configuration Assistant
General-purpose remarks columns rarely contain important data.