Question 1

One example of a popular DBMS is:

Accepted Answer

A)  Excel 
B)  OEM. 
C)  Java. 
D)  SQL Server. 
E) .NET.

Question 2

If you are a database administrator, it is likely that your organization has a policy against taking a__________ copy of any application home to practice with.

Accepted Answer

The answer of If you are a database administrator, it...

Question 3

Why is the development process in reality a continuous cycle of change?

Accepted Answer

The answer of Why is the development process in reality...

Question 4

One of the problems in ________processing is that two people could change data without it updating.

Accepted Answer

The answer of One of the problems in ________processing is...

Question 5

Many users prefer to avoid database applications altogether and simply store their data in a(n):

Accepted Answer

A)  spreadsheet. 
B)  encrypted table. 
C)  file. 
D)  mattress. 
E)  old can.

Question 6

__________of information are represented by individual bytes.

Accepted Answer

The answer of __________of information are represented by individual bytes....

Question 7

The DBA, as opposed to the user, is responsible for authorizing changes to the database.

Accepted Answer

A) True 
 B)False

Question 8

What is an ERD?

Accepted Answer

The answer of What is an ERD?...

Question 9

It is easiest to make adjustments to a database during the modeling stage.

Accepted Answer

A) True 
 B)False

Question 10

What are the stages in developing a database application? At what point is it easiest to make changes?

Accepted Answer

The answer of What are the stages in developing a...

Question 11

________cardinality indicates the most entities that can be involved in a relationship.

Accepted Answer

The answer of ________cardinality indicates the most entities that can...

Question 12

An entity has an unique attribute which is known as the:

Accepted Answer

A)  identifier. 
B)  index field. 
C)  key attribute. 
D)  foreign key.

Question 13

A __________is in charge of implementing, maintaining, and operating the organization's databases.

Accepted Answer

The answer of A __________is in charge of implementing, maintaining,...

Question 14

The__________ shows the number of entities that can be involved in a relationship.

Accepted Answer

A)  lost- update 
B)  cardinality 
C)  E- R 
D)  UML 
E)  data integrity

Question 15

In a relational database, each entity is described by:

Accepted Answer

A)  attributes. 
B)  data. 
C)  fields. 
D)  characters. 
E)  bytes.

Question 16

An example of a one- to- many type of relationship might be:

Accepted Answer

A)  an employee can be assigned one and only one computer. 
B)  an employee is assigned a company car. 
C)  an employee cannot be assigned a computer. 
D)  an employee can be assigned more than one computer.

Question 17

"Address" would be a likely attribute of a customer entity in a database application.

Accepted Answer

A) True 
 B)False

Question 18

In order to transform a data model into a database design, one must first represent each entity with a table.

Accepted Answer

A) True 
 B)False

Question 19

User accounts and roles are part of the DBMS security features.

Accepted Answer

A) True 
 B)False

Question 20

What is metadata? Give an example. Why is it important?

Accepted Answer

The answer of What is metadata? Give an example. Why...

Exam 5: Database Processing

One example of a popular DBMS is:

If you are a database administrator, it is likely that your organization has a policy against taking a__________ copy of any application home to practice with.

Why is the development process in reality a continuous cycle of change?

One of the problems in ________processing is that two people could change data without it updating.

Many users prefer to avoid database applications altogether and simply store their data in a(n) :

__________of information are represented by individual bytes.

The DBA, as opposed to the user, is responsible for authorizing changes to the database.

What is an ERD?

It is easiest to make adjustments to a database during the modeling stage.

What are the stages in developing a database application? At what point is it easiest to make changes?

________cardinality indicates the most entities that can be involved in a relationship.

An entity has an unique attribute which is known as the:

A __________is in charge of implementing, maintaining, and operating the organization's databases.

The__________ shows the number of entities that can be involved in a relationship.

In a relational database, each entity is described by:

An example of a one- to- many type of relationship might be:

"Address" would be a likely attribute of a customer entity in a database application.

In order to transform a data model into a database design, one must first represent each entity with a table.

User accounts and roles are part of the DBMS security features.

What is metadata? Give an example. Why is it important?