Most data that can be encountered are best classified as_____________– .
a. structured
b. semistructured
c. unstructured
d. historical
The entity relationship model (ERM) is dependent on the database type.
a. True
b. False
Business intelligence (BI) architecture is composed of data, people, processes,
technology, and the management of such components.
a. True
b. False
In Chen notation, entities and relationships have to be oriented horizontally; not
vertically.
a. True
b. False
A________ is a query inside a query.
a. subquery
b. range query
c. join
d. set query
When the specific cardinalities are not included on the diagram in Crow’s Foot notation,
cardinality is implied by the use of _____.
a. symbols
b. attributes
c. images
d. tables
Which of the following is a personal analytics vendor for BI applications?
a. IBM
b. Kognitio
c. Netezza
d. MicroStrategy
A____________ attribute is one that cannot be subdivided.
a. composite
b. simple
c. single-valued
d. multivalued
Database designers determine the data and information that yield the required
understanding of the entire business.
a. True
b. False
The serializable isolation level is the least restrictive level defined by the ANSI SQL
standard.
a. True
b. False
Overlapping subtypes are subtypes that contain_______— subsets of the supertype
entity set.
a. null
b. exclusive
c. solitary
d. nonunique
When using a(n)____________ join, only rows that meet the given criteria are returned.
a. full
b. inner
c. outer
d. set
Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather sparse data.
d. They do not support very large amounts of than performance.
The decision to store ___________attributes in database tables depends on the
processing requirements and the constraints placed on a particular application.
a. multivalued
b. derived
c. single-valued
d. composite
In the context of data backup and recovery, the activities of a___________ includes the
DBA operations that are classified as disaster management.
a. database programmer
b. systems analyst
c. data administrator
d. database security officer
When setting optimizer hints, _______________instructs the optimizer to minimize the
overall execution time, that is, to minimize the time it takes to return the total number
of rows in the query result set. This hint is generally used for batch mode processes.
a. ALL_ROWS
b. FIRST_ROWS
c. INDEX(P_QOH_NDX)
d. OPTIMIZATION_ROWS
The DBMS _____________the SQL query and chooses the most efficient
access/execution plan.
a. parses
b. executes
c. fetches
d. processes
______________is the result of revealing the meaning of raw facts.
a. End-user data
b. An encoded sample
c. An encrypted bit
d. Information
Students and classes have a ____________relationship.
a. one-to-one
b. one-to-many
c. many-to-one
d. many-to-many
UPDATE tablename
*****
[WHERE conditionlist];
The____________ command replaces the ***** in the syntax of the UPDATE
command, shown above.
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression
Normalization represents a micro view of the entities within the ERD.
a. True
b. False
Which of the following queries will output the table contents when the value of the
character field P_CODE is alphabetically less than 1558-QW1?
a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE <“1558-QW1”;
b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = [1558-QW1];
c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = (1558-QW1);
d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = {1558-QW1};
Relationships between entities always operate in one direction.
a. True
b. False
A(n)________ ‘s main function is to help one understand the complexities of the
realworld environment.
a. node
b. entity
c. model
d. database
Database programming languages receive all application requests and translate them
into the complex operations required to fulfill those requests.
a. True
b. False
As long as two transactions, T1 and T2, access _________data, there is no conflict, and
the order of execution is irrelevant to the final outcome.
a. shared
b. common
c. unrelated
d. locked
Each time an end user clicks a hyperlink, the browser generates a(n)__________ page
request that is sent to the designated web server using the TCP/IP Internet protocol.
a. HTML
b. XML
c. HTTP GET
d. API
______________are in charge of presenting data to the end user in a variety of ways.
a. Data stores
b. ETL tools
c. Data visualization tools
d. Data analysis tools
The Oracle equivalent to an MS Access AutoNumber is a(n)___________ .
a. auto-number
b. sequence
c. TO_NUMBER function
d. trigger
A______ is the primary key of one table that has been placed into another table to
create a common attribute.
a. superkey
b. composite primary key
c. candidate key
d. foreign key
The distributed database system must be__________ of the computer hardware system.
A(n)___________order sequence is a multilevel ordered sequence that can be created
easily by listing several attributes, separated by commas, after the ORDER BY clause.
When designing a new database structure based on the business requirements of the end
users, the database designer will construct a data model using a technique such
as____________- .
_______________exists when different and conflicting versions of the same data
appear in different places.
The most distinctive characteristic of modern OLAP tools is their capacity for _____
analysis.
____________, or transactions done over the Internet, enables all types of organizations
to sell products and services to a global market.
In order to meet requirements, you may have to denormalize some portions of a
database design.
What are the main types of objects in the OLE-DB model? Explain.
Describe the use of the INTERSECT operator.
In the_____________ , no row may contain two or more multivalued facts about an
entity.
DATE() and SYSDATE are special functions that return today’s date in MS Access
and__________ , respectively.
In a relational table, each column has a specific range of values known as the________
domain.
_________________is an index based on a specific SQL function or expression.
The_______________ aspect of introducing a DBMS in an organization deals with
hardware and software changes in the organization.
To delete an index, one must use the______________ command.
All relational tables satisfy the______________ requirements.
What are database checkpoints?
One of the advantages of a distributed database management system (DDBMS) is
___________operating cost.
Specialization is based on grouping________________ characteristics and relationships
of the subtypes.
From a data modeling point of view, ___________–data refer to data whose values
change over time and for which one must keep a history of the data changes.