NEW
Font size
WorksheetsDatabases
Total questions: 25
Worksheet time: 13mins
Which is the best description of a database?
Stores data
Stores data in a organised structure and messy way
Stores data in an organised and logical structure
Stores data in an unorganised and untidy structure
Which of these could be a primary key?
ID number
Surname
Teacher name
Students addresses
What is the definition of a Foreign Key?
A field in a table that is written in another language
A field in a table that links to the World Wide Web
A field in a table that cannot be edited or accessed by users
A field in a table that is used as a link to a field in another table
How would you define a relational database?
A database consisting of data relating to families
An online database
A database linked to another database
A database consisting of multiple tables, that are linked using keys
What type of field would be best to store the following text: "AA-00-67"
Number
Currency
Date
Text
What is the definition of a database entity?
Another name for a table
A way of performing searches and sorts in a database
It represents people, places, objects or things stored in tables in a database
A way of linking tables in a database
Head teacher who runs a School
The best data type to choose for a postcode/zipcode would be:
Number
Date/Time
Text
Currency
The best data type to choose for date of birth would be:
Text
Number
Currency
Date/Time
To find a particular set of data in a database you would use a:
Table
Form
Query
Report
A RDBMS consists a collection of ?
Tables
Fields
Records
Keys
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons;
SELECT ALL Persons;
SELECT [all] FROM Persons;
SELECT *.Persons;
What does RDBMS stand for?
Relational Database Basic Management System
Relational Database Management System
Required Database Management Setup
None of these
The SQL statement that queries or reads data from a table is ________
SELECT
READ
QUERY
None of the above is correct.
A database table can have __________ primary key(s).
any no: of
exactly one
three
two
A database table can have ____ number : of Foreign Keys.
1
2
4
any
Which is the first stage when drawing an ERD for a database?
Idea
Complete
Conceptual
Physical
What does ERD stand for?
Environmental Research Division
Extended Reach Drilling
Evil Rubber Duckie
Entity Relationship Diagram
