Unit 2

1.

1 point

What is the best method to determin if the security features of a database system are working?

Periodically perform audits

Manage data activities

Use the least privilege concept

Install keyboard locks

2.

1 point

One method to maintain database access control is for database administrators (DBA) to limit user's access by

periodically performing audits

installing keyboard locks

managing data activities

using the least privilege concept

3.

1 point

Which term is used to address the data item instead of having to address the entire size of the data item?

schema

pointer

structure

model

4.

1 point

Which term is a retrieval package characteristic that is a collection of tools used to automate the process of installing, upgrading, configuring, and removing software modules from a remote computer?

Remote data management

Package management system

Computer-aided software engineering

Package distribution

5.

1 point

Which item's purpose is to graphically illustrate system objects or entities and their relationships?

Entity-Relationship diagram

Data normalization

Semantic modeling

Normalization

6.

1 point

The term "relation" is a mathematical use in relational database structure and another term for

model

schema

structure

table

7.

1 point

Another structure name for a network that is similar to a tree structure is a

plex

model

view

schema

8.

1 point

Which term is a relational data table with data calculated at query time?

View

Meta-data

Build

Database table

9.

1 point

Which database normalization form has a type of entity dependency called transitive dependency?

Third normal

First normal

Second normal

Fourth normal

10.

1 point

A tree structure whithin a hierachical data structure is best used to display database records that have what type of fields?

Reliant

Independent

Structured

Repeated

11.

1 point

Data about data within tables is which term?

Build

View

Database table

Meta-data

12.

1 point

Which term is a set of data elements or values organized by using a model of horizontal rows and vertical columns?

View

Database table

Build

Meta-data

13.

1 point

What causes database fragmentation?

Data denormalization

Gaps left in the database due to record deletions

Database becoming logically unorganized

Unstructured record formats

14.

1 point

Which term best describes the process of organizing data into tables in such a way that the results of using the database are unambiguous and as intended?

Data denormalization

Entity-Relationship modeling

Normalization

Semantic modeling

15.

1 point

Which term is a structured description of records used to describe database objects representations and the relationships among them?

schema

structure

model

pointer

16.

1 point

The redundant storing of the customre name in the purchase order entity is an example of

Data denormalization

Semantic modeling

Normalization

Entity-relationship diagram

17.

1 point

Which term best describes a database process of using symbols to represent something in a manner different from which it was intended?

Entity-Relationship modeling

Semantic modeling

Normalization

Remote data management

18.

1 point

What database administrator (DBA) maintenance responsibility involves maintaining a practical collection of metadata, DBMS software, code libraries, and editing tools?

Maintaining a data repository

Managing the DBMS

Managing the database structure

Managing data activity

19.

1 point

What database administrator (DBA) maintenance responsibility includes configuration control which entails updating information on an enterprise's computer systems?

Managing data activity

Managing the database management system (DBMS)

Managing the database structure

Mantaining a data repository