Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
In the ADO.NET framework, the__________ object contains the actual SQL code or a
stored procedure call to be run by the database.
a. Command
b. DataReader
c. DataAdapter
d. DataSet
Performance transparency ensures that the system finds the most cost-effective path to
access remote data.
a. True
b. False
Metadata describe the data characteristics and the set of relationships that links the data
found within the database.
a. True
b. False
Implementing overlapping subtypes requires the use of one discriminator attribute for
each subtype.
a. True
b. False
________________relates to the activities that make the database execute transactions
more efficiently in terms of storage and access speed.
a. Performance tuning
b. Database design
c. Query access
d. Database management
A __________schema is a type of star schema in which dimension tables can have their
own dimension tables.
a. snowflake
b. starflake
c. dimension
d. matrix
A table is in BCNF if every determinant in the table is a foreign key.
a. True
b. False
The_________-- relationship should be rare in any relational database design.
a. 1:1
b. 1:M
c. M:1
d. M:N
The SELECT operator yields a vertical subset of a table.
a. True
b. False
Normalization produces a lower normal form.
a. True
b. False
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key
column has no null entries, and all entries are unique. This is an example
of____________ integrity.
a. entity
b. referential
c. relational
d. null
By default, the fact table's primary key is always formed by combining the superkeys
pointing to the dimension tables to which they are related.
a. True
b. False
SQL is considered difficult to learn; its command set has a vocabulary of more than 300
words.
a. True
b. False
A__________ contains the description of the entire database as seen by the database
administrator.
a. distributed global dictionary
b. distributed data dictionary
c. distributed global schema
d. distributed data schema
The existence of a mandatory relationship indicates that the minimum cardinality is 0 or
1 for the mandatory entity.
a. True
b. False
The system is subjected to exhaustive testing during the testing phase of the Systems
Development Life Cycle (SDLC).
a. True
b. False
Training principles and methodologies are planned during the implementation phase of
the Systems Development Life Cycle (SDLC).
a. True
b. False
A trigger definition consists of the triggering timing, the triggering event, the triggering
level, and the triggering action.
a. True
b. False
Most real-world database transactions are formed by only one database request.
a. True
b. False
Depending on the sophistication of the application development software, nulls can
create problems when functions such as COUNT, AVERAGE, and SUM are used.
a. True
b. False
The SQL command that modifies an attribute"s values in one or more table's rows is
_____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
A single-user database system automatically ensures___________ of the database,
because only one transaction is executed at a time.
a. serializability and durability
b. atomicity and isolation
c. serializability and isolation
d. atomicity and serializability
In the optimistic approach, during the _________phase, changes are permanently
applied to the database.
a. read
b. validation
c. write
d. shared
When performing user access management, a DBA assigns passwords to each user at
both the operating system and DBMS levels.
a. True
b. False
In the context of developing a data administration strategy, a(n)____________ provides
a framework that includes computerized, automated, and integrated tools such as a
DBMS and CASE tools.
a. access plan
b. active data dictionary
c. information systems architecture
d. security policy
Operational data are commonly stored in many tables, and the stored data represent
information about a given________________
only.
a. transaction
b. database
c. table
d. concept
Whether you purchase online or by standing in line, the system-level transaction details
are essentially the same, and they require the same basic database structures and
relationships.
a. True
b. False
A star schema is designed to optimize data query operations rather than data update
operations.
a. True
b. False
Variables can be declared inside a stored procedure.
a. True
b. False
Data stored at their highest level of granularity are said to be atomic data.
a. True
b. False
The_____________ guarantees that if a portion of a transaction operation cannot be
committed, all changes made at the other sites participating in the transaction will be
undone to maintain a consistent database state.
a. DO-UNDO-REDO protocol
b. two-phase commit protocol (2PC)
c. coordinator protocol
d. write-ahead protocol
_______________relationships can be implemented by creating a new entity in 1:M
relationships with the original entities.
a. 1:N
b. M:1
c. M:N
d. 1:1
Describe the need for convenient and safe backup storage.
A(n)____________ is a carefully designed and constructed repository of facts that is a
part of a larger whole known as an information system.
A designer must have a thorough understanding of the company's data types, extent,
and uses in order to develop an accurate _____.
Any attribute that is at least part of a key is known as a__________- .
A(n)______ is a collection of similar objects with a shared structure and behavior.
APIs are faster than_______________ scripts because the code resides in memory and
there is no need to run an external program for each request.
What characteristics do tables that conform to the concept of well-informed relations
have?
Composite primary keys are particularly useful as identifiers of composite entities,
where each primary key combination is allowed________ in the M:N relationship.
How are triggers critical to proper database operation and management?
A(n)___________ view is a view that can be used to update attributes in the base
table(s) that are used in the view.
One of the advantages of a distributed database management system (DDBMS) is less
danger of a single-________ failure.
Explain multivalued attributes with the help of examples. How are multivalued
attributes indicated in the Chen Entity Relationship model?
What components should an implementation-ready data model contain?
In the context of database administration, _____________is the extent to which
individuals and organizations have the right to determine the "who, what, when, where,
and how" of data usage.
The____________ stage uses data modeling to create an abstract database structure that
represents real-world objects in the most realistic way possible.
Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?
What is a server-side extension? Explain.
In the SQL environment, the word_____________ covers both questions and actions.
