Quiz
Exams
This quiz has question types that open in the usual player.
Questions in this quiz (6)
1List the three items which are considered to be the foundation of a relational database:
(1) [blank_start]Entities[blank_end] (2) [blank_start]Attributes[blank_end] (3) [blank_start]Relationships[blank_end]- AEntities
- BAttributes
- CRelationships
2Which is a FALSE statement regarding flat file databases?
- Aa) Flat files are inflexible
- Bb) Flat files are not available on the network
- Cc) Inconsistencies and anomalies in a flat file can easily occur
- Dd) New data fields cannot easily be added in a flat file
- Ee) Data redundancy can occur in a flat file database
3Which is a FALSE statement regarding relational databases?
- Aa) Relational databases are dynamic
- Bb) Relational databases are not available on the network
- Cc) Inconsistencies and anomalies in a relational database can be avoided
- Dd) Data can be added and changed easily in a relational database
- Ee) New topics of data can be added to an existing relational database
4What is the function of the Primary Key of a table?
[blank_start]Unique identifier of an instance[blank_end]- AUnique identifier of an instance
5What are the two requirements that a field must follow in order to be considered a valid Primary Key field?
[blank_start]Unique in every instance[blank_end]
[blank_start]Present in every instance[blank_end]- AUnique in every instance
- BPresent in every instance
6What is the function of the Foreign Key of a table?
[blank_start]Ensures referential integrity[blank_end]- AEnsures referential integrity
Information
- Description
- Quiz on Exams, created by Ailsa Taylor on 02/05/2019.
- Author
- Ailsa Taylor
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz