Typically, there are at least four different copies of the database schema used in the
redesign process.
The Read Only transaction isolation level is unique to Oracle Database.
Attributes preceded by a + are protected.
SOAP was originally an XML-based standard for providing remote procedure calls
over the Internet.
A database design is rarely a redesign of an existing database.
Java Server Pages (JSP) can run only on Linux or Unix servers.
Database redesign is equally difficult whether or not the database has data in it.
Databases are created in a DBMS during the implementation step.
A transaction is a series of actions to be taken on the database such that either all of
them are performed successfully or none of them is performed at all.
Because of the need to know the functional dependencies in a database, it is a good idea
to create a dependency graph.
When the parent entity has a surrogate key, the enforcement actions are the same for
both parent and child.
The clause SELECT COUNT (*) results in a table with a single row and a single
column.
Object classes have properties that represent characteristics of the objects in the class.
A row can be uniquely identified by a key.
When people use the term join they normally mean an equijoin.
The SQL built-in function AVG computes the average of values in numeric columns.
An entity’s minimum cardinality in a relationship indicates the number of entity
instances that must participate in the relationship.
When the correct SQL command is used to delete a table’s structure, the command can
only be used with a table that has already had its data removed.
There is only one way to install PHP.
Google’s Bigtable was an early example of structured storage.
In a common form of RFM analysis, an RFM score of 5 1 1 means that the customer
orders frequently and orders items of high monetary value but has not ordered anything
for some time.
In E-R modeling, entities within an entity class may have different attributes.
A stored program that is attached to a table or view is called a stored procedure.
For a workstation running the Windows operating system, a commonly used file system
utility is Microsoft Internet Explorer.
An ID-dependent table can be used to represent multivalued attributes.
SQL Server AFTER triggers may be used with insert and update actions, but not delete
actions.
When creating a relational database design from E-R diagrams, first create a relation for
each relationship.
The use of a doubly nested set of NOT EXISTS SELECT statements is so rare that even
if you are a professional database developer you will probably never see it used.
Relations are classified into normal forms based on the types of modification anomalies
that they are vulnerable to.
ODBC stands for Open Database Connectivity.
A standby data repository is one which requires a person to generate the metadata and
place it in the repository.
Relationships are classified by their cardinality.
The default cursor concurrency setting for a keyset cursor in SQL Server is ________.
A) Pessimistic
B) Optimistic
C) Serializable
D) Read only
In an Enterprise-class database system, business users interact directly with the DBMS,
which directly accesses the database data.
Business Intelligence (BI) reporting systems can do which of the following operations?
A) Filter data
B) Group data
C) Modify data
D) Both A and B are correct
Which SQL keyword is used to name a new table and describe the table’s columns?
A) SET
B) CREATE
C) SELECT
D) ALTER
Which of the following is not a transaction isolation level supported by Oracle
Database?
A) Read Committed
B) Serializable
C) Repeatable Read
D) Read Only
A circle across the relationship line near an entity indicates ________.
A) a maximum cardinality of “zero”
B) a maximum cardinality of “one”
C) a minimum cardinality of “optional”
D) a minimum cardinality of “required”
SQL views are always updatable when ________.
A) the view is based on a single table with no computed columns, and all non-null
columns are present in the view
B) the view is based on any number of tables, with or without computed columns, and
the INSTEAD OF trigger is defined for the view
C) the view is based on multiple tables, the update is being done on the most
subordinate table, and the rows of that table can be uniquely identified
D) Both A and B are correct
Based on the table below, a function to compute a 10% late penalty on a customer’s
balance would have how many input parameters?
CUSTOMER
A) 0
B) 1
C) 2
D) it doesn’t matter
Copying spreadsheet data into a database is part of a larger data warehousing process
known as ________.
A) import/export
B) spreadsheet conversion
C) extract, transform, and load
D) data verification
In a correlated subquery of a database that has tables TableOne and TableTwo, if table
TableOne is used in the upper SELECT statement, then which table is used in the lower
SELECT statement?
A) TableOne
B) TableTwo
C) Both TableOne and TableTwo
D) Either TableOne or TableTwo
Which of the following is not a definition of information?
A) Data presented in a meaningful context
B) Knowledge derived from data
C) Data processed by summing, ordering, averaging, grouping, comparing or other
similar operations
D) A list of facts
A ________ is a file that has no repeating groups.
A) flat file
B) stacked file
C) record file
D) key file
For a workstation running the Windows operating system, the user file system
permissions Modify and Write must be granted to the Users group at the ________
folder.
A) wwwroot
B) inetpub
C) Web
D) eclipse
The term set refers to all records that have the same ________.
A) primary key
B) unique secondary key
C) nonunique secondary key
D) search key
The first step in transforming an extended E-R model into a relational database design
is to ________.
A) create a table for each relationship
B) evaluate the entities against the normalization criteria
C) create a table for each entity
D) remove any recursive relationships
The Microsoft Access 2013 Close button is actually a ________.
A) Save and Close button
B) Save and Exit button
C) Close and Exit button
D) Print and Close button
Hardware is installed and tested during the ________ step of the SDLC.
A) requirements analysis
B) component design
C) implementation
D) systems maintenance
In general, each relation should have ________.
A) one and only one theme
B) one or more themes
C) exactly two themes
D) one or two themes
Which of the following is not true about surrogate keys?
A) They are identifiers that are supplied by the system, not the users.
B) They have no meaning to the users.
C) They are non-unique within a table.
D) They can be problematic when combining databases.
A sales contact manager used by a salesperson is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) data mining application
Because of the need to know the functional dependencies in a database, it is a good idea
to create a(n) ________.
A) conceptual schema
B) internal schema
C) dependency graph
D) table-relationship diagram
In many-to-many relationships between strong entities in a relational database design,
which of the following is not true?
A) The intersection table is ID-dependent on one of the parents
B) The intersection table is ID-dependent on both of the parents
C) The relationships from the intersection table to the parent tables are identifying
relationships
D) The maximum cardinality to the intersection table is always N
Given the functional dependency (A, B) → C, then ________.
A) A and B together → C
B) A → C
C) B → A
D) Both A and B are correct
We have obtained access to the company’s operational data. In one record, we find that
a customer’s age has been recorded as “337.” This is an example of ________.
A) dirty data
B) inconsistent data
C) nonintegrated data
D) a “wrong format” problem
In Microsoft Access 2013, the maximum length in characters of a “Short Text” data type
column is ________.
A) 25
B) 255
C) 65535
D) unlimited
To use JDBC, programs must be written in Java.
The Oracle Database PL/SQL statement used to complete the basic PL/SQL block
structure is ________.
A) DECLARE
B) BEGIN
C) IF…ELSE…END IF
D) END;
An advantage of denormalization is ________.
A) faster updating
B) faster querying
C) faster copying of data
D) faster design
In OLAP, the characteristic of a measure is called a ________.
A) level
B) dimension
C) slice
D) member
For which of the following types of failure would Oracle Database use OnLine ReDo
files as part of a recovery effort?
A) Instance failure
B) Application failure
C) Media failure
D) Logic failure
Which of the following is not an XML Web service standard?
A) SOAP
B) WSDL
C) Ethernet
D) UDDI
Business Intelligence (BI) systems obtain their data by all of the following means
except ________.
A) read and process data from an operational database
B) process extracts from operational databases
C) process data purchased from data vendors
D) read and process data entered by BI system users
The presence of one or more foreign keys in a relation prevents ________.
A) the elimination of modification anomalies
B) the elimination of duplicated data
C) more complex SQL for multitable subqueries and joins
D) Both A and B are correct
The Java JRE is installed directly from the Java download page at ________.
A) www.oracle.com
B) www.jre.com
C) www.jdk.com
D) www.sun.com
Describe the tabbed Ribbon.
Describe the two ways that semantic object views can be used.
What is a reporting system?
Compare the characteristics of an operational database and a dimensional database.
Why do we say a database is self-describing and why is this an advantage?
Explain the ambiguity in the broad definition of a weak entity.
Briefly describe subqueries and joins. Explain when each is not an acceptable
alternative for the other.
What is theNetBeans IDE?
What are the four sets of minimum cardinalities that can be present in a 1:N binary
relationship?
What is a linked list?
Explain how relationships are created using SQL. Include an example.
What is the Microsoft Web Platform Installer, and what are the advantages and
disadvantages of using it to install PHP?
Write the database table design to represent the data model below, including tables, the
proper placement of the foreign key, and referential integrity constraint.
Describe how to set table properties in a MySQL Workbench database design.
In Microsoft Visio 2013, describe the possible cardinality settings for a Relationship
object that can be set in the symbols menu in a database design, and how these settings
correspond to the IE Crow’s Foot symbols shown in Figure F-20.
Discuss the Microsoft PowerShell utility.