GCSE Database Theory

What does “SQL” stand for?

• Standard Query Language.
• Structured Query Language.
• Structured Quick-access Language.
• Standard Questioning Language.

What is a DBMS?

• It runs a database, and can provide control over user permission levels, provides both a visual and SQL interface and can allow a database to work across multiple devices.
• It is a technology which reduces lag time when running a query.
• It is the organisation that set up and maintains SQL.
• It is a Database Backup Management system that can be switched to if an active database fails.

What does a Relationship do within a database?

• It reduces data redundancy by linking fields in different tables.
• It shows which users in a database are related.
• It increases data redundancy by linking fields in different tables.
• The fields are the vertical columns in a table.

What is data redundancy?

• Data that is repeated multiple times.
• Data that is safe from SQL attacks.
• Data that is weak to SQL attacks.
• Data that has no use anymore.

What does data validation do?

• Checks that an input fits certain parameters such as length.
• Checks that inputted data is completely correct.
• Checks that there is no redundant data in a field.
• Checks that the correct SQL Query has been used.

What is QBE?

• A graphical, form based method of running a query on a database.
• A way of achieving data validation.
• An alternative to a DBMS.
• Another name for an SQL query.

A database is separated from the applications that use it so that…

• Different groups of users can have custom interfaces
• The tables don’t get mixed up
• Things are kept simple using “divide and conquer”
• It takes up less disk space

An advantage of using SQL instead of QBE is:

• It is a standardised system and therefore can easily communicate with other programs that use SQL.
• It is more intuitive to use than the QBE
• It prevents data redundancy due to not using an overly-complicated DBMS
• It increases the chance of a failover system being activated, protecting data in the event of a malicious attack.

A database is a store of data that is...

• persistent and organised
• persistent and disorganised
• temporary and organised
• temporary and disorganised

A database form is useful for...

• viewing and entering data
• only viewing data
• only entering data
• storing data