NEW
Font size
WorksheetsDatabases
Total questions: 10
Worksheet time: 7mins
Which of the following relationships cannot be created directly between two tables in a normalised relational database?
many-to-many
one-to-one
one-to-many
many-to-one
What is used to uniquely identify a record on a table?
Foreign Key
Primary Key
Candidate Key
Combination Key
Which of the following is not a reason to normalise a database?
maintain referential integrity
eliminate data redundancy
reduce data storage
improve performance
Which of the following does not mitigate problems with concurrent usage of a client-server database?
record locks
commitment ordering
deadlocks
serialisation
What is the purpose of an index on a database table?
to make sure records are unique
to put records in a specific order
to reduce storage
to make it faster to search for a record
Which of the following SQL statements has valid syntax?
SELECT * FROM mytable.myrecord WHERE ORDER ascending
SELECT * FROM mytable
ORDER BY myfield
SELECT myrecord FROM mytable WHERE mydate=21/3/2025
SELECT FROM mytable WHERE myfield LIKE "J*"
When referring to a database, what does DDL stand for?
Data Description Language
Data Definition Language
Dynamic Data Language
Dynamic Description Language
Which of the following SQL statements has invalid syntax?
DELETE FROM mytable
UPDATE mytable SET myfield='new value'
INSERT INTO mytable
SELECT * FROM mytable
Which of the following is not part of third normal form
There should be no transitive dependencies
Every field should be functionally dependent on the key
The data should be atomic
No data values should be repeated
Comparing an ERD to a database, you could describe an entity as being represented by a table. Using this comparison, what would an attribute be represented by in the database?
a field
a record
a key
an index
