Database Systems Practice Test
Practice test on core database systems concepts from the indexed Coronel, Morris, and Rob textbook.
12 questions · pass mark 70% · try 5 free
1 Which data model is the main focus of the core database design and implementation material?
- Hierarchical model
- Relational model
- Network model
- Object database model
The study material centers much of its design and implementation coverage on the relational database model.
2 ER modeling is presented as a strictly linear process with no iteration.
- True
- False
The material states that ER modeling is iterative and that designers move back and forth among activities such as attribute definition, normalization, and verification.
3 Which activities are explicitly checked during ER model verification?
Select all that apply
- End-user data views
- Required transactions
- Access rights and security
- Business-imposed data requirements and constraints
The retrieved material lists all four as part of ER model verification.
4 What is the main goal of normalization?
- Increase redundancy
- Reduce redundancy and update anomalies
- Replace SQL with graphical tools
- Eliminate the need for constraints
Normalization is used to reduce redundancy and improve table design.
5 Which language is used to define and manipulate relational data?
- HTML
- UML
- SQL
- XML
Structured Query Language (SQL) is the primary language for working with relational databases.
7 more questions in this test
Take the full test in MagicalTutor with instant marking, an explanation for every answer, and a score tracked against your weak topics.
Take the full test