IGCSE Computer Science - Database

What is a database?

• A programming language for maintaining databases

• A method of searching a database

• A single table with no links

• A collection of data stored in a logical and ordered manner

What is a primary key in a database?

• A programming language for maintaining databases

• A method of searching a database

• A unique field that can search things quickly

• A collection of data about one single item in a database

What is a relational database?

• Many tables together that have a relationship with each other

• A single table with no links

• A method of searching a database

• A programming language for maintaining databases

What is a foreign key in a database?

• A method of searching a database

• Allows links between databases - not unique

• A programming language for maintaining databases

• A single table with no links

What is SQL used for in databases?

• A collection of data about one single item in a database

• A method of searching a database

• A single table with no links

• Specialized programming language for maintaining a database

What is the purpose of a query in a database?

• A method of searching a database

• A single table with no links

• A collection of data about one single item in a database

• A programming language for maintaining databases

What is the structure of a database table?

• Consisting of records and fields

• A single table with no links

• A method of searching a database

• A programming language for maintaining databases

What is the purpose of a record in a database?

• A collection of data about one single item in a database

• A single table with no links

• A method of searching a database

• A programming language for maintaining databases

What is the purpose of a view in a database?

• A virtual table based on the result-set of an SQL statement

• A single table with no links

• A collection of data about one single item in a database

• A programming language for maintaining databases

What is the role of a database administrator?

• To manage and maintain the database system

• To create a new database

• To define the structure of a database

• To perform mathematical operations on the database