DAT 380 Wk 5 - Apply - Post-Course Assessment Quiz

Click Here To Download Your Files :

http://www.onlinehelp123.com/dat-380

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link

http://www.onlinehelp123.com/dat-380

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