Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
The ODBC API standard defines three levels of compliance: ____, Level-1, and
Level-2, which provide increasing levels of functionality.
a. Complete
b. Basic
c. Core
d. Level-0
The conceptual design step that determines end-user views, outputs, and
transaction-processing requirements is ____.
a. data analysis and requirements
b. entity relationship modeling and normalization
c. data model verification
d. distributed database design
A(n) ____'s main function is to help you understand the complexities of the real-world
environment.
a. constraint
b. entity
c. model
d. database
The conceptual design step that defines entities, attributes, and relationships is ____.
a. database analysis and requirements
b. entity relationship modeling and normalization
c. data model verification
d. distributed database design
The syntax for a left outer join is ____.
a. SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE
join-condition
b. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
c. SELECT column-list WHERE LEFT table1 = table 2
d. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
At the implementation level, the supertype and its subtype(s) depicted in the
specialization hierarchy maintain a(n) ____ relationship.
a. self-referencing
b. 1:1
c. 1:M
d. M:N
Which query is used to list a unique value for V_CODE, where the list will produce
only a list of those values that are different from one another?
a. SELECT ONLY V_CODE FROM PRODUCT;
b. SELECT UNIQUE V_CODE FROM PRODUCT;
c. SELECT DIFFERENT V_CODE FROM PRODUCT;
d. SELECT DISTINCT V_CODE FROM PRODUCT;
In Oracle, the ____ command is used to change the display for a column, for example,
to place a $ in front of a numeric value.
a. DISPLAY
b. FORMAT
c. CHAR
d. CONVERT
If an entity can exist apart from one or more related entities, it is said to be
____-independent.
a. existence
b. relationship
c. business
d. weak
____ systems provided no data extraction/integration process.
a. Third-generation Mobile BI and cloud-based
b. First-generation BI
c. First-generation departmental decision support
d. Traditional mainframe-based online transaction processing
____ can serve as a test vehicle for companies exploring the potential benefits of data
warehouses.
a. Data networks
b. Data marts
c. Data cubes
d. OLAPs
A(n) ____is a dynamic table that not only contains the SQL query command to generate
the rows, but also stores the actual rows.
a. OLAP
b. materialized view
c. star schema
d. data cube
End-user data is ____.
a. raw facts about the end-user
b. raw facts of interest to the end-user
c. data about data
d. accurate, relevant and timely information
Normalization works through a series of stages called normal forms. For most purposes
in business database design, ____ stages are as high as you need to go in the
normalization process.
a. two
b. three
c. four
d. five
Which query will use the given columns and column aliases from the PRODUCT table
to determine the total value of inventory held on hand?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT;
____ yields better performance.
a. Denormalization
b. Normalization
c. Atomization
d. Compression
A ____ identifier is composed of more than one attribute.
a. primary
b. foreign
c. composite
d. domain
Implementing BI in an organization involves capturing not only business data (internal
and external) but also the ____.
a. metadata
b. facts
c. information
d. rules
The ____ component of a CASE tool produces the information system's input/output
formats.
a. analysis
b. graphics
c. program document generator
d. screen painter and report generator
____ is a higher-level object-oriented application interface used to access remote
database servers.
a. API
b. ODBC
c. DAO
d. RDO
The ____ data model is said to be a semantic data model.
a. relational
b. network
c. object-oriented
d. entity relationship
____ means that data used during the execution of a transaction cannot be used by a
second transaction until the first one is completed.
a. Serializability
b. Atomicity
c. Isolation
d. Time stamping
In an outer join, the matched pairs would be retained and any unmatched values in the
other table would be left ____.
a. in another table
b. null
c. out of the results
d. with matching values from the original table
The implementation of ____-produced applications tends to prolong the operational life
of systems by making them easier to update and maintain.
a. database
b. network
c. CASE
d. design
The ____ operator could be used in place of INTERSECT if the RDBMS does not
support it.
a. IN
b. OF
c. AND
d. UNION
A ____ relationship exists when an association is maintained within a single entity.
a. unary
b. ternary
c. binary
d. weak
To work with the data, the DBMS must retrieve the data from the ____ and place it in
the ____.
a. data files, procedure cache
b. data files, data cache
c. temporary files, RAM
d. temporary files, procedure cache
Lock ____ indicates the level of lock use.
a. granularity
b. shrinking
c. growing
d. serializability
____ transparency allows the system to perform as if it were a centralized database
management system.
a. Heterogeneity
b. Distribution
c. Performance
d. Failure
The SQL command that lets you insert rows into a table is ____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
Every XML document has a ____.
a. root element
b. base tag
c. schema
d. DTD
When using the Oracle TO_NUMBER function to convert a character string into a
number, ____ represents a digit.
a. 0
b. 9
c. $
d. #
Because real-world database design is generally done by teams, you should strive to
organize the design's major components into ____________________.
The only time the client and server computers communicate is when the client requests
a page -when the user clicks a link- and the server sends the requested page to the
client.
Atomic attributes are attributes that can be further subdivided.
A(n) ____________________ is a representation of the relational database's entities,
the attributes within those entities and the relationships between those entities.
The first step in ____________________ design is to discover the data element
characteristics.
What are some of the features provided by Web application servers?
Business rules apply to businesses and government groups, but not to other types of
organizations such as religious groups or research laboratories.
The ____________________design stage uses data modeling to create an abstract
database structure that represents real-world objects in the most realistic way possible.
____________________ exists when different and conflicting versions of the same data
appear in different places.
A(n) ________________________________________ provides a framework that
includes the use of computerized, automated, and integrated tools such as a DBMS and
CASE tools.
Explain normalization and its different forms.
Dependency diagrams are very helpful in getting a bird's-eye view of all the
relationships among a table's attributes.
Backups must be clearly identified through detailed descriptions and date information,
assuring that the correct backup is used to recover the database.
End-user interfaces require the end user to manually generate SQL code.
SQL requires the use of the ADD command to enter data into a table.
Entity supertypes and subtypes are organized in a specialization hierarchy.
APIs are faster than _________________________ scripts because the code is resident
in memory and there is no need to run an external program for each request.
Dependencies that are based on only a part of a composite primary key are called
transitive dependencies.
An entity supertype can have disjoint or overlapping entity subtypes.
Within a specialization hierarchy, a supertype can exist only within the context of a
subtype.
