1.Databases-Intro

Question 1

Which one of these fields would NOT be on a school database about a pupil?

Accepted Answer

Age

Question 2

What is SQL

Accepted Answer

A way to get data out of database files

Question 3

What does SQL stand for?

Accepted Answer

Structured Query Language

Question 4

All records are held together in what??

Accepted Answer

Table

Question 5

What is a query?

Accepted Answer

A way to sort data, A way to filter data

Question 6

What is a benefit of defining data-types for each attribute?

Accepted Answer

To help optimise the amount of space used by the data, Help the database software find matching data (faster), Helps to allow calculations and queries to be performed sucessfully

Question 7

Select an advantage of using Microsoft Access to create a database

Accepted Answer

You can make changes very easily, It helps when learning database concepts, Easy to search for data

Question 8

Which of these could not be stored in a database?

Accepted Answer

MS Access

Question 9

All of the information held about a single person is called a?

Accepted Answer

Record

Question 10

Why might a company like Amazon hold your bank details?

Accepted Answer

To speed up the ordering process for repeat orders

Question 11

What type of database has linked data tables?

Accepted Answer

Relational DB

Question 12

A single piece of information held about someone such as their name or address is called a?

Accepted Answer

Attribute, Field

Question 13

What type of database can be stored as a spreadsheet.

Accepted Answer

Flat File DB

Question 14

To find a specific surname in a database starting with 'Z' you could press..

Accepted Answer

Create a SQL query, Sort Descending

1.Databases-Intro

Questions 14

1.Databases-Intro

Questions 14