Data Modelling Quiz

What is the main function of a physical schema in data modelling?

• To determine the database implementation and data types for each field

• To develop the logical schema

• To describe the business requirements for the database

• To specify the access details for the system

What is the role of a data dictionary in a database?

• To create SQL queries

• To manage the database and tables

• To store the metadata about the data

• To provide in-built security measures

What is a Database Management System (DBMS) used for?

• To develop the logical schema

• To create SQL queries

• To interact with the database and manage its structure

• To specify the access details for the system

What is a major advantage of relational databases over flat file databases?

• Data Encryption

• In-built security features

• Backup automation features

What is the purpose of a logical schema in data modelling?

• To specify the access details for the system

• To describe the structure of the database and how the data connects

• To create SQL queries

• To determine the database implementation and data types for each field

What is the main function of a conceptual schema in data modelling?

• To describe the data to be stored in a database

• To create SQL queries

• To define the physical schema

• To specify the data types for each field

What are the security measures provided by relational databases?

• Backup automation features, Data Encryption

• All of the above

• Authentication through usernames and passwords, Access rights & levels

• Transaction logging for auditing purposes, Ensuring database consistency