Question 1

A database administrator may be called a(n)__________ .

Accepted Answer

A)  office of database administration 
B)  DA 
C)  DAD 
D)  DBA 
E)  DB 
A)  office of database administration 
B)  DA 
C)  DAD 
D)  DBA 
E)  DB

Question 2

In E- R diagrams, entities are represented with rectangles.

Accepted Answer

A) True 
 B)False

Question 3

In a 1:M type of relationship, the foreign key is stored on the "1" side.

Accepted Answer

A) True 
 B)False

Question 4

The DBA may not be responsible for managing recovery after a failure of the database.

Accepted Answer

A) True 
 B)False

Question 5

A database management system is a ___________ .

Accepted Answer

A)  software program. 
B)  process. 
C)  team of people. 
D)  all of the above. 
E)  none of the above. 
A)  software program. 
B)  process. 
C)  team of people. 
D)  all of the above. 
E)  none of the above.

Question 6

A vertical bar on a line in crow's- foot notation means that there:

Accepted Answer

A)  may be more than one of the entity. 
B)  might be one of the entity. 
C)  must be one of the entity. 
D)  is a mistake...there should not be anything but the crow's feet. 
A)  may be more than one of the entity. 
B)  might be one of the entity. 
C)  must be one of the entity. 
D)  is a mistake...there should not be anything but the crow's feet.

Question 7

SQL stands for:

Accepted Answer

A)  Standard Query Language. 
B)  Structured Query Language. 
C)  Standard Question Language. 
D)  Simple Query Language. 
E)  Structured Question Language. 
A)  Standard Query Language. 
B)  Structured Query Language. 
C)  Standard Question Language. 
D)  Simple Query Language. 
E)  Structured Question Language.

Question 8

The data model should summarize the data requirements as derived from interviews with the end users.

Accepted Answer

A) True 
 B)False

Question 9

A DBMS and a database are two separate things.

Accepted Answer

A) True 
 B)False

Question 10

________are associated with only a single entity instance.

Accepted Answer

The answer of ________are associated with only a single entity...

Question 11

A database application consists of forms, reports, and database programs.

Accepted Answer

A) True 
 B)False

Question 12

Query forms use __________to search.

Accepted Answer

A)  keywords 
B)  content 
C)  attributes 
D)  metadata 
E)  Google 
A)  keywords 
B)  content 
C)  attributes 
D)  metadata 
E)  Google

Question 13

A crow's foot notation would indicate the maximum cardinality of the relationship.

Accepted Answer

A) True 
 B)False

Question 14

A database form translates the inputted change into a SQL query in order for the database to process it.

Accepted Answer

A) True 
 B)False

Question 15

In a one- to- many relationship, the foreign key is stored in the table that is on the__________ side of the relationship.

Accepted Answer

A)  one 
B)  many- to many 
C)  cardinal 
D)  many 
E)  weak 
A)  one 
B)  many- to many 
C)  cardinal 
D)  many 
E)  weak

Question 16

Bytes are grouped into columns, which are grouped into ______________.

Accepted Answer

A)  bits 
B)  rows 
C)  files 
D)  fields 
A)  bits 
B)  rows 
C)  files 
D)  fields

Question 17

Databases are considered self- describing because they contain __________.

Accepted Answer

The answer of Databases are considered self- describing because they...

Question 18

UML stands for__________ .

Accepted Answer

A)  Uniform Model Lingo 
B)  Uniform Modeling Language 
C)  Uniform Manmade Language 
D)  Unified Modeling Language 
E)  Unified Model Lingo 
A)  Uniform Model Lingo 
B)  Uniform Modeling Language 
C)  Uniform Manmade Language 
D)  Unified Modeling Language 
E)  Unified Model Lingo

Question 19

If we agree that a data model is really just a model of a user's perception of the world in question, how does this impact our thinking about data modeling?

Accepted Answer

Basically, if we accept this thinking ab

Question 20

A N:M relationship is represented with a(n):

Accepted Answer

A)  linking field. 
B)  composite table. 
C)  entity. 
D)  index field. 
E)  intersection table. 
A)  linking field. 
B)  composite table. 
C)  entity. 
D)  index field. 
E)  intersection table.

A database administrator may be called a(n)__________ .

In E- R diagrams, entities are represented with rectangles.

In a 1:M type of relationship, the foreign key is stored on the "1" side.

The DBA may not be responsible for managing recovery after a failure of the database.

A database management system is a ___________ .

A vertical bar on a line in crow's- foot notation means that there:

SQL stands for:

The data model should summarize the data requirements as derived from interviews with the end users.

A DBMS and a database are two separate things.

________are associated with only a single entity instance.

A database application consists of forms, reports, and database programs.

Query forms use __________to search.

A crow's foot notation would indicate the maximum cardinality of the relationship.

A database form translates the inputted change into a SQL query in order for the database to process it.

In a one- to- many relationship, the foreign key is stored in the table that is on the__________ side of the relationship.

Bytes are grouped into columns, which are grouped into ______________.

Databases are considered self- describing because they contain __________.

UML stands for__________ .

If we agree that a data model is really just a model of a user's perception of the world in question, how does this impact our thinking about data modeling?

A N:M relationship is represented with a(n):

Mis and You

Information Systems for Collaboration

Is for Competitive Advantage

Hardware and Software

Data Communications

Information Systems Within the Organization

E-Commerce and Supply Chain Systems

Business Intelligence Systems

Systems Development

Information Systems Management

Information Security Management

How the Internet Works

Filters

Exam 5: Database Processing

A database administrator may be called a(n)__________ .

In E- R diagrams, entities are represented with rectangles.

In a 1:M type of relationship, the foreign key is stored on the "1" side.

The DBA may not be responsible for managing recovery after a failure of the database.

A database management system is a ___________ .

A vertical bar on a line in crow's- foot notation means that there:

SQL stands for:

The data model should summarize the data requirements as derived from interviews with the end users.

A DBMS and a database are two separate things.

________are associated with only a single entity instance.

A database application consists of forms, reports, and database programs.

Query forms use __________to search.

A crow's foot notation would indicate the maximum cardinality of the relationship.

A database form translates the inputted change into a SQL query in order for the database to process it.

In a one- to- many relationship, the foreign key is stored in the table that is on the__________ side of the relationship.

Bytes are grouped into columns, which are grouped into ______________.

Databases are considered self- describing because they contain __________.

UML stands for__________ .

If we agree that a data model is really just a model of a user's perception of the world in question, how does this impact our thinking about data modeling?

A N:M relationship is represented with a(n):

Mis and You

Information Systems for Collaboration

Is for Competitive Advantage

Hardware and Software

Data Communications

Information Systems Within the Organization

E-Commerce and Supply Chain Systems

Business Intelligence Systems

Systems Development

Information Systems Management

Information Security Management

How the Internet Works

Filters