Database Concepts Quiz

What is a database?

• A collection of data items and links between them

• A type of computer program

• A physical storage device

• A type of computer network

What is the primary key in a table?

• A data structure built from one or more columns in a database table

• A set of attributes that form a primary key

• A unique identifier for a table

• An individual data item stored for an entity

What is the purpose of normalisation in a relational database?

• To reduce data redundancy and ensure integrity

• To increase data redundancy and complexity

• To speed up searching for data

• To store data in a non-structured manner

What is the purpose of an E-R diagram in database design?

• To provide a visual representation of how entities are related

• To store data in a file-based approach

• To write SQL scripts for database manipulation

• To create database tables

What is the cardinality of a relationship that is one-to-many?

• 1:m

• m:1

• m:m

• 0:1

What is the purpose of a Database Management System (DBMS) in relation to a file-based approach?

• To improve data security

• To create data dependencies

• To decrease data inconsistency

• To increase data redundancy

Which command is used in SQL to add a primary key to a table?

• FOREIGN KEY

• CREATE TABLE

• PRIMARY KEY

• ALTER TABLE

How can a Database Administrator (DBA) ensure the security of student data using a DBMS?

• By using access rights to manage user actions

• By storing data in unsecured locations

• By implementing regular back-ups

• By allowing unrestricted access to all users

What is the purpose of a query processor in a DBMS?

• To design data models

• To process and execute queries

• To manage data dictionary entries

• To create databases

Which SQL command is used to add new rows to a table?

• INSERT INTO

• DELETE FROM

• UPDATE

• ALTER TABLE