Quiz
Module 7
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (10)
11) The relational data model portrays data as being stored in _____.
- Aa) Hierarchies
- Bb) Objects
- Cc) Tables
- Dd) Files
22) How a user conceptually organises and understands data is referred to as the _____.
- Aa) Physical view
- Bb) Data model view
- Cc) Logical view
- Dd) Data organisation view
33) What is each row in a relational database table called?
- Aa) Relational
- Bb) Anomaly
- Cc) Attribute
- Dd) Tuple
44) Which of the following is an individual user’s view of the database?
- Aa) Conceptual-level schema
- Bb) Internal-level schema
- Cc) External-level schema
- Dd) Logical-level schema
55) Which of the following would managers most likely use to retrieve information about sales during the month of October?
- Aa) DML
- Bb) DDL
- Cc) DSL
- Dd) DQL
66) Which of the following attributes would most likely be a primary key?
- Aa) Supplier name
- Bb) Supplier area code
- Cc) Supplier number
- Dd) Supplier account balance
77) Which of the following is a software program that runs a database system?
- Aa) DQL
- Bb) DML
- Cc) DBMS
- Dd) DDL
88) The constraint that all primary keys must have non-null data values is referred to as which of the following?
- Aa) Referential integrity rule
- Bb) Normalisation rule
- Cc) Entity integrity rule
- Dd) Relational data model rule
99) The constraint that all foreign keys must have either null values or the value of a primary key in another table is referred to as which of the following?
- Aa) Referential integrity rule
- Bb) Foreign key value rule
- Cc) Entity integrity rule
- Dd) Null value rule
1010) Which of the following attributes in the Cash receipts table (representing payments received from customers) would most likely be a foreign key?
- Aa) Cash receipt number
- Bb) Customer number
- Cc) Customer cheque number
- Dd) Cash receipt date
Information
- Description
- accounting Quiz on Module 7, created by Catherine Tumanguil on 02/11/2016.
- Author
- Catherine Tumanguil
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz