logo image

214 practice exam

The ____ structure is quite different from that of an operational or transactional database.
data warehouse
The database structure in a DBMS is stored as a ____.
collection of files
____________________ exists when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.
data inpendence
In early computer file systems, a(n) ___________________________________ was hired to create a computer-based system that would track data and produce required reports.
data processing specialist
A(n) ___________________________________ is a collection of programs that manages the database structure and controls access to the data stored in the database.
database management system
Data ____________________ is a discipline that focuses on proper generation, storage and retrieval of data.
management
XML data is ____
semistructured
____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
metadata
true or false….M:N relationships are not appropriate in a relational model.
true
True or false…
The relational model is hardware-dependent and software-independent.
false
____ are normally expressed in the form of rules.
contraints
True or false …
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
false
True or false
A manager and a programmer usually have the same view of the same data.
false
____ are important because they help to ensure data integrity.
contraints
True or false….
The terms data model and database model are often used interchangeably.
true
One of the limitations of the ____ model is that there is a lack of standards.
hierarchical
Students and classes have a ____ relationship.
many to many
A(n) ____________________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
business rule
A ____ contains at least all of the attribute names and characteristics for each table in the system.
data dictionary
Codd’s rule of ____ states:
Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).
logical data independence
the proper use of ____________________ keys is crucial to controlling data redundancy.
foreign
The relational operators have the property of ____________________; that is, the use of relational algebra operators on existing relations (tables) produces new relations.
closure
A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.
relational schema
The ____________________ catalog can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table’s creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users, and access privileges.
system
To avoid nulls, some designers use special codes, known as ____________________, to indicate the absence of some value.
flags
True or false
A foreign key must exist in both tables that have a relationship.
false
____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
predicate
A derived attribute ____.
need not be physically stored within the database
A ____ relationship exists when three entities are associated
tenary
A(n) ____________________ is the attribute’s set of possible values.
domain
True or false …
The existence of a mandatory relationship indicates that the minimum cardinality is 1 for the mandatory entity.
false
An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
existence
A ____ attribute is one that cannot be subdivided.
simple
A(n) ____________________ attribute need not be physically stored within the database.
derived
A(n) ____________________ attribute cannot be subdivided.
simple
True or false…
A composite identifier is a primary key composed of more than one attribute.
true
One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
primary
True or false…d
An entity cluster is a “virtual” entity type used to represent multiple entities and relationships in the ERD.
true
True or false
At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
true
the property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
inheritance
The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
compromises that include renormalization
True or false
A good relational DBMS excels at managing denormalized relations.
false
A dependency based on only a part of a composite primary key is called a(n) ____________________.
partial dependency
A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.
transitive dependency
True or false
With parrtial dependencies, data redundancies occur because every row entry requires duplication of data.
true
For most business transactional databases, we should normalize relations into ____.
3NF
Before converting a table into 3NF, it is imperative the table already be in ____.
2NF
true or false
Relational models view the data as part of a table or collection of tables in which all key values must be identified.
true
The preferred placement for a foreign key when working with a 1:1 relationship is to ____.
place the foreign key in one of the entities
The “____” characteristic of a primary key states that:
The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls.
unique values
A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.
application program
___ data are the result of formatting to facilitate storage, use and generation of information.
structured
End-user data is ____.
raw facts of interest to the end-user
____________________ is the result of processing raw data to reveal its meaning.
information
A(n) ____ database is designed to support a company’s day-to-day operations
transactional
A ____ is a collection of related records.
file
True or false…….
Data processing can be as simple as organizing data to reveal patterns.
true
True or false ….
Corporations use only structured data.
false
A(n) ____ is anything about which data are to be collected and stored.
entity
True or false ….
End-user interfaces require the end user to manually generate SQL code.
false
The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
entity relationship
Business rules are derived from ____.
a detailed description of an organization’s operations
The ____________________ defines the portion of the database “seen” by the application programs that produce information from the data.
subschema
an_____ is a relatively simple representation of more complex real-world data structures.
data model
When you can change the internal model without affecting the conceptual model, you have ____________________ independence.
logical
A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
relationship
true or false….
business rules must be rendered in writing
true
The network model has structural level dependence.
true
A(n) _________ is an orderly arrangement used to logically access rows in a table
index
All primary key entries are unique, and no part of a primary key may be ____
null
The _________ relationship is the relational database norm.
1:M
The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n) ____________________.
relation
True or false….
A left outer join on tables CUSTOMER and AGENT yields all of the rows in the CUSTOMER table, including those that do not have a matching value in the AGENT table
true
true or false….
The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage.
true
In the following table description, ____ is the primary key.
PRODUCT (PROD_CODE, PROD_DESCRIPT, PROD_PRICE, PROD_ON_HAND, VEND_CODE)
PROD_CODE
true or false….
Attributes do not have a domain.
false
_______relationships are most common
binary
Attributes may share a ____.
domain
A ____ attribute can be further subdivided to yield additional attributes.
composite
A(n) ____________________ attribute cannot be subdivided.
simple
true or false….
Relationships operate only in one direction
false
true or false…..
A composite identifier is a primary key composed of more than one attribute.
true
Another word for existence-independent is ____.
strong
True or false……
Ideally, a primary key is composed of several attributes.
false
A ____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects
natural
true or false …..
implementating non-overlapping subtypes requires the use of one discriminator attribute for each subtype
false
The ____________________ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
completeness
true or false…
To model time-variant data, you must create a new entity in a M:N relationship with the original entity.
false
____ relationships occur when there are multiple relationship paths between related entities.
redundant
From a structural point of view, 2NF is better than ____.
1NF
true or false….
Atomic attributes are attributes that can be further divided.
false
A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
repeating group
true or false….
Repeating groups must be eliminated by making sure that each column defines a single entity.
false
According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.
JOB_CHG_HOUR
Before converting a table into 3NF, it is imperative the table already be in ____.
2NF
True or false…
Denormalization produces a lower normal form.
true
3.A(n) ____ database is used by an organization and supports many users across many departments.
4.__________________ exists when the same data are stored unnecessarily at different places.
True or false….
One disadvantage of a database system over previous data management approaches is increased costs.
true
Raw data must be properly ____________________ for storage, processing and presentation.
formatted
Accurate, relevant, and timely information is the key to ____.
good decision making
___________________________________ is a special language used to represent and manipulate data elements in a textual format.
XML
true or false…..In Chen notation, entities and relationships must be oriented horizontally.
false
true or false…
The hierarchical model is software-independent.
false
A(n) ____________________ is a representation of the relational database’s entities, the attributes within those entities and the relationships between those entities.
relational diagram
13. Oracle 11g is an example of a(n) ____
14.Students and classes have a ____ relationship.
many-to-many
Data modeling starts with a very complex representation, and as knowledge of the problem is gained, the model is simplified.
false
true or false…
A data model is usually graphical.
true
(n) ____ represents a particular type of object in the real world.
entity
the relational model’s creator, E. F. Codd, used the term relation as a synonym for ____.
table
____ combines all rows from two tables, excluding duplicate rows.
UNION
___ yields only the rows that appear in both tables.
INTERSECT
true or false…
Only a single attribute, not multiple attributes, can define functional dependence.
false
In a relational table, each column has a specific range of values known as the ____________________ domain.
attribute
True or false…

As rare as 1:1 relationships should be, certain conditions absolutely require their use.
True

true
Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes—as foreign keys—at least the ____ keys of the tables that are to be linked.
primary
A relationship is an association between ____
entities
Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
optional
true or false…
The Crow’s Foot model is less implementation-oriented than the Chen model.
false
true or false….
In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
true
In an ER diagram, primary keys are indicated by ____.
underlining
In the relationship “EMPLOYEE claims DEPENDENT” the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
existence-dependent
A derived attribute is indicated in the Chen model by a ____
dashed line
36.The step, ____, occurs first in the process of building an ERD.
true or false…
fWithin a specialization hierarchy, a supertype can exist only within the context of a subtype.
false
If one exists, a data modeler uses a ____ as the primary key of the entity being modeled.
natural identifier
____________________ completeness means that not every supertype occurrence is a member of a subtype.
partial
The ____________________ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
completeness
From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
derived
____________________ is a process to help reduce the likelihood of data anomalies.
normalization
45. If database tables are treated as though they were files in a file system, the _____________________________________________ never has a chance to demonstrate its superior data-handling capabilities.
RDBMS

it stands for relational database management system

true or false…
A table is in BCNF if every determinant in the table is a candidate key.
true
true or false…
with parrtial dependencies, data redundancies occur because every row entry requires duplication of data.
true
Data redundancy produces ____.
data integrity problems
1. ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
meta data
Most decision-support data are based on historical data obtained from ____.
operational
4. A workgroup database is a(n)____ database.
multiuser
5.The organization of the data within the folders in a manual file system was determined by ____.
its expected use
6.____________________ exists when different and conflicting versions of the same data appear in different places.
data inconstancy
7. Data ____________________ is a discipline that focuses on proper generation, storage and retrieval of data.
management
8. true or false
A data warehouse can store data derived from many sources.
true
10. In the ____ model, the basic logical structure is represented as an upside-down tree.
hierarchical
11.MySQL is an example of a(n) ____.
relational data model
14. The ____ model uses the concept of inheritance.
object-oriented
15. The ____ model is said to be a semantic data model.
object-oriented
16. The ____________________ is the conceptual organization of the entire database as viewed by the database administrator.
schema
17. true or false..
The entity relationship model is limited to conceptual modeling, with no implementation component.
true
20. ____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
SELECT
23. A ____ key is defined as a key that is used strictly for data retrieval purposes.
secondary
26. ____ yields a vertical subset of a table.
PROJECT
27. If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ____________________ integrity
referential
28. true or false..
If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ____________________ integrity
true
30. In the original ERM described by Chen, relationships do not contain ____________________.
attributes
31. The associative entity is also known as a ____ entity.
composite
32. The ERM forms the basis of a(n) ___________________________________.
34. In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
ERD

“entity relationship diagram “

35. In an ER diagram, primary keys are indicated by ____.
underlining
36. A ____ attribute is one that cannot be subdivided.
simple
38. ____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
generalization
42. The default comparison condition for the subtype discriminator attribute is the ____ comparison.
equality
43. ____________________ refers to the level of detail represented by the values stored in a table’s row.
granularity
44. A relational table must not contain a(n) ____.
repeating group
45. A table that displays data redundancies yields ____.
anomalies
46. When designing a database, you should ____.
make sure entities are in normal form before table structure are created
48. true or false…
It is possible for a table in 2NF to exhibit transitive dependency, where one or more nonprime attributes functionally determine other nonprime attributes.
true
49. true or false…
A table is in BCNF if every determinant in the table is a foreign key.
false
4. The response of the DBMS to a query is the ____.
5. A ____ database supports data distributed across several different sites.

Need essay sample on "214 practice exam"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy