GCSE OCR Computing 'Databases'

Question 1

The DBMS should allow data sharing

Accepted Answer

True

Question 2

Which of the following refers to the process of extracting specific data from a database

Accepted Answer

Interrogation

Question 3

A database stores data that is

Accepted Answer

Organised, Persistant

Question 4

Which of the followiung is not a disadvantage of a flat file database structure?

Accepted Answer

Easy sorting and filtering

Question 5

Which of the following are common instructions in maintaining a database?

Accepted Answer

Delete, Update, Insert

Question 6

Which of the following is used to identify every record in a table?

Accepted Answer

Primary Key

Question 7

Records stored in order. Fast to access individual records. Which One?

Accepted Answer

Direct access

Question 8

Database reports can't be generated from tables or queries

Accepted Answer

False

Question 9

Records stored in sequence in order of key field. Which One?

Accepted Answer

Sequential

Question 10

In a relational database, data is stored...

Accepted Answer

Over multiple tables

Question 11

What does DBMS stand for?

Accepted Answer

Database management system

Question 12

The DBMS must allow multiple applications to edit the same data at the same time

Accepted Answer

False

Question 13

A complex database query searches for data in multiple fields...

Accepted Answer

True

Question 14

Which of the following is used to link one table to another in a database

Accepted Answer

Foreign Key

Question 15

New Records appended to file. Time consuming to search. Difficult to update. Which One?

Accepted Answer

Serial

Questions 15