1) What type of database contains only 1 table? a) Flat File b) Relational c) Linked d) Single e) Seperate f) Table 2) Which key is used to uniquely identify a record? a) Primary b) Foreign c) Front Door d) Car e) Secondary f) Locker 3) What type of validation would you use to check a phone number has exactly 11 characters? a) Length b) Restricted Choice c) Range d) Presence e) Primary f) Required 4) Which type of validation does a primary key ALWAYS have automatically? a) Presence b) Required c) Length d) Range e) Restricted Choice f) Key 5) Which of these are parts of a data dictionary? a) Key b) Field Name c) Attribute Name d) Relationship e) Record f) Values 6) Which of these are data types? a) Date b) Boolean c) Text d) Date/Time e) Yes/No f) Integer 7) What do the bubbles (or ovals) represent in an ER diagram? a) Attributes b) Fields c) Primary Key d) Table e) Relationship f) Entity 8) What type of validation is this? >= 40 and <=100 a) Range Check b) Length Check c) Restricted Choice d) Presence Check e) Required f) Greater than and less than 9) Which of these are GDPR principles? a) Lawfulness and transparency b) Data Minimisation c) Time reduction d) Storage space increases e) Information Transparency f) Purpose Descriptions 10) Which type of relationship can be found in a relational database? a) One-To-Many b) Many To None c) None to Many d) None to None e) One to Lots f) Lots to Everything

N5 Relational Databases

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?