Databases

Question 1

What is the purpose of a data base?

Answer 1

Used to store data in a structured format

Question 2

Query

Answer 2

A search or question performed within a data base

Question 3

Flat File Database

Answer 3

All data stored on a single table

Question 4

Relational Data Base

Answer 4

Data stored on more than one table and linked using key fields

Question 5

What is a link between different tables called?

Answer 5

Relationship
One to one
One to many
Many to many

Question 6

Foreign Key

Answer 6

Link to a primary key in a relational database table

Question 7

What are the advantages of a relational data base?

Answer 7

-Data entered into database only once
-Mistakes less likely to happen
-Duplication avoided so file size smaller
-Queries can be performed
-Reports can be generated

Question 8

merge sort

Answer 8

The list is repeatedly divided into two until all the elements are separated individually. Pairs of elements are then compared, placed into order and combined. The process is then repeated until the list is recompiled as a whole.

Question 9

compiler

Answer 9

A compiler translates an entire program into machine code before execution.

Don’t need source code

Java and C++ are examples of compiled programming languages.

Question 10

interpreter

Answer 10

Each time the program is run, an interpreter translates the code into machine code, instruction by instruction.

Always need source code

Interpreter languages include JavaScript, PHP, Python and Ruby.

Question 11

Characteristics of low level languages

Answer 11

Specific
Take up less space as file sizes are usually smaller
Direct - doesn’t have to go through translator or interpreter

Question 12

Characteristics of high level languages

Answer 12

Less code needs to be written from scratch (libraries)
More readable and easier to find errors
More people know high level languages