- Description
DAT 380 Wk 5 – Apply – Post-Course Assessment Quiz
1
Data is said to be verifiable if:
- the data always yields consistent results.
- the data is obtained from trusted sources.
- the data is stored in different places within the database.
- the data cannot be changed or manipulated.
2
The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.
- True
- False
3
Database designers determine the data and information that yield the required understanding of the entire business.
- True
- False
4
During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.
- analysis
- detailed systems design
- maintenance
- implementation
5
Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.
- True
- False
6
In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.
- True
- False
7
Relational algebra defines the theoretical way of manipulating table contents using relational operators.
- True
- False
8
The _____ command restricts the selection of grouped rows based on a condition.
- HAVING
- DISPLAY
- CONVERT
- FROM
9
The _____ command defines a default value for a column when no value is given.
- UNIQUE
- CHECK
- DEFAULT
- NOT NULL
10
After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.
- True
- False
11
The special operator used to check whether an attribute value is within a range of values is _____.
- IN
- NULL
12
VMS/VSAM is an example of the _____.
- hierarchical model
- file system data model
- XML data model
- relational data model
13
A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.
- 3NF
- 2NF
- 4NF
- 1NF
14
To implement a small database, a database designer must know the “1” and the “M” sides of each relationship and whether the relationships are mandatory or optional.
- True
- False
15
An operational database is sometimes referred to as an enterprise database.
- True
- False
16
A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.
- persistent storage module (PSM)
- base table
- statement-level trigger
- cursor-style process
17
The default comparison condition for the subtype discriminator attribute is the _____ comparison.
- greater than
- nonequality
- equality
- less than
18
In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.
- True
- False
19
A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
- True
- False
20
The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics.
- True
- False
21
Ideally, an entity identifier is composed of _____ attribute(s).
- two
- six
- three
- one
22
The idea of determination is unique to the database environment.
- True
- False
23
In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype.
- foreign key constraint
- nonunique constraint
- overlapping constraint
- disjoint constraint
24
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.
- True
- False
25
Today, most relational database products can be classified as object/relational.
- True
- False