Database Mock Exam Form
Please complete the Database Mock Exam Form to the best of your ability. All responses will be used for assessment purposes only.
Candidate Name
*
First Name
Last Name
Email Address
*
example@example.com
Exam Date
*
 -
Month
 -
Day
Year
2 digit month, 2 digit day, 4 digit year
Date
Select Exam Subject
*
Please Select
Relational Databases
SQL Fundamentals
Database Design
NoSQL Concepts
Data Modeling
Other
Which SQL statement is used to retrieve data from a database?
*
SELECT
INSERT
UPDATE
DELETE
Which of the following is a primary key characteristic?
*
Uniquely identifies each record
Allows duplicate values
Can be null
Stores large text data
What does 'normalization' achieve in database design?
*
Reduces data redundancy
Increases data duplication
Decreases data security
Speeds up all queries
Which type of JOIN returns all records when there is a match in either left or right table?
*
FULL OUTER JOIN
INNER JOIN
LEFT JOIN
CROSS JOIN
Rate your confidence in your database knowledge
1
2
3
4
5
Any additional comments or feedback?
Submit Exam
Should be Empty: