WorksheetsA-Level Comp Sci 9618 Databases
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What is a limitation of using a file-based approach for the storage and retrieval of data?
a)
Lack of data integrity
b)
Faster query processing
c)
Scalability
d)
Lower storage requirements
2.
Which feature of a relational database addresses the limitations of a file-based approach?
a)
Data redundancy
b)
Data isolation
c)
Data consistency
d)
Increased storage requirements
3.
What is the main purpose of an entity-relationship (E-R) diagram?
a)
To document a database design
b)
To create database tables
c)
To normalize database tables
d)
To manage database users
4.
Which term refers to the process of organizing a database to minimize redundancy and improve data integrity?
a)
Denormalization
b)
Normalization
c)
Optimization
d)
Indexing
5.
What does Third Normal Form (3NF) ensure in a database?
a)
No non-key dependencies
b)
No partial dependencies
c)
No multivalued dependencies
d)
No duplicate data
6.
What is the purpose of a primary key in a relational database?
a)
To ensure data redundancy
b)
To uniquely identify a record
c)
To link tables in a many-to-many relationship
d)
To store multiple values in a single field
7.
What is the purpose of a foreign key in a relational database?
a)
To uniquely identify a record
b)
To enforce data consistency
c)
To link tables in a relationship
d)
To store multiple values in a single field
8.
Which feature is provided by a Database Management System (DBMS) to address the issues of a file-based approach?
a)
Data management
b)
Data redundancy
c)
Data fragmentation
d)
Increased storage requirements
9.
In a DBMS, what is the purpose of a query processor?
a)
To maintain a data dictionary
b)
To create and modify database structure
c)
To execute database queries
d)
To ensure data security
10.
What is the industry standard for both Data Definition Language (DDL) and Data Manipulation Language (DML)?
a)
Structured Query Language (SQL)
b)
Python
c)
C++
d)
Java
11.
Which SQL command is used to create a new database?
a)
CREATE DATABASE
b)
CREATE TABLE
c)
ALTER TABLE
d)
INSERT INTO
12.
In SQL, which command is used to add a primary key to a table?
a)
ALTER TABLE ... ADD PRIMARY KEY
b)
ALTER TABLE ... ADD FOREIGN KEY
c)
CREATE TABLE ... PRIMARY KEY
d)
CREATE TABLE ... FOREIGN KEY
13.
Which SQL command is used to query data from a database table?
a)
INSERT INTO
b)
DELETE FROM
c)
UPDATE
d)
SELECT ... FROM
14.
In SQL, which command is used to add a foreign key to a table?
a)
ALTER TABLE ... ADD FOREIGN KEY
b)
ALTER TABLE ... ADD PRIMARY KEY
c)
CREATE TABLE ... FOREIGN KEY
d)
CREATE TABLE ... PRIMARY KEY
15.
Which SQL command is used to modify existing data in a database table?
a)
INSERT INTO
b)
DELETE FROM
c)
UPDATE
d)
SELECT ... FROM
100 %
