AIS Exam
Showing posts with label AIS Exam. Show all posts
Showing posts with label AIS Exam. Show all posts

A table in third normal form

A table in third normal form 





a. Cannot have any repeating groups
b. Has no transitive dependencies
c. Has no non-key fields depending on only a part of the composite primary key
d. All of the above
e. a and b




Answer: D

A third normal form violation can occur for which of the following tables?

A third normal form violation can occur for which of the following tables?




a. A table with a single field primary key and two non-key attributes
b. A table with a composite primary key and two non-key attributes
c. A table with a composite primary key and one non-key attribute
d. All of the above
e. a and b





Answer: E

A "transitive dependency" is a dependency between

A "transitive dependency" is a dependency between



a. Two primary keys
b. A primary key and a candidate key
c. A primary key and a non-key attribute
d. Two non-key attributes
e. A non-key attribute and a composite primary key





Answer: D

A table with a single field primary key can never

A table with a single field primary key can never




a. Violate first normal form
b. Violate second normal form
c. Violate third normal form
d. Have more than one non-key attribute
e. Have more than 4 fields


Answer: B

For a table to be in first normal form, it must

For a table to be in first normal form, it must




a. Have a composite primary key
b. Have at least one foreign key
c. Not have a composite primary key
d. Not have any foreign keys
e. Not have any repeating groups





Answer: E

A Level 0 DFD

A Level 0 DFD




a. Is the same as a context diagram
b. Shows more detail than a Level 1 DFD
c. Shows less detail than a context diagram
d. Shows details about a high level process depicted in a context diagram
e. None of the




Answer: D

At the highest level, a DFD is referred to as a

At the highest level, a DFD is referred to as a



a. Level 0 DFD
b. Level 1 DFD
c. Context diagram
d. Scope diagram
e. Master level DFD






Answer: C

Interpret the following EER diagram: Sales Regions || Assigned O< Salespersons:

Interpret the following EER diagram: Sales Regions || Assigned O< Salespersons:




a. Every sales region has exactly one salesperson; a salesperson may be assigned to either no sales regions or many sales regions
b. Every salesperson must be assigned to exactly one sales region; a sales region may have either none or many salespersons
c. Every sales region has one or more salespersons; a salesperson is assigned to one or more sales regions
d. Every salesperson may be assigned to one or more sales regions; a sales region may have on or more salespersons
e. Every salesperson must be assigned to exactly one sales region; a sales region must have exactly one salesperson





Answer: B

Which of the following statements about the REA data model is true?

Which of the following statements about the REA data model is true?




a. Each resource is generally linked to at least two agents
b. Each event its generally linked to at least three agents
c. Each event is generally linked to at least one resource
d. Each agent is generally linked to at least two events
e. Each agent is generally linked to at least two resources




Answer: C

In an EER diagram, an "O" on the relationship line next to an entity is used to indicate that

In an EER diagram, an "O" on the relationship line next to an entity is used to indicate that




a. The entity's participation in the relationship is optional
b. The entity's participation in the relationship is mandatory
c. There are no instances of that entity (empty set)
d. There are no primary keys defined for the entity
e. There are no secondary keys in the entity (all key relation)





Answer: A
Subscribe to: Posts (Atom)