Home Library Explore SAT

Home Library Explore SAT

Databases Basics - GCSE Computer Science Flashcards | StudBud

Explore/Databases Basics - GCSE Computer Science

Databases Basics - GCSE Computer Science

13 terms·StudBud Administration·344 plays

GCSE Computer Science: Databases (Edexcel 2014 spec) #gcsecomputerscience #databases

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
What language do database use to search (query)?
MyISAM
SQL
TABLES
HTML
2
In the below example, what is the Primary Key?
FirstName
ClassCode
Surname
PupilNumber
3
What does DBMS stand for?
Database Memory System
Data Broken Manipulation Sent
Database Memory Size
Database Management System
4
Why do you need a Primary Key in a database?
Because it's the first field
Because it won't work otherwise
As a unique identifier
5
Text, Integer, Decimal, Boolean are all examples of which of these?
Validation
Field
Record
Data Type
6
Two or more tables linked together by common attributes is called a
Relational Database
Spreadsheet
Flat-file Database
7
Describe what is meant by a database
The @ sign in an e-mail address
A table where you can hold stuff
A persistent and organised store of data
Files on a computer like .txt
8
A database with all the data in one table is called a....
Relational database
Flat-file database
Simple database
Single-table database
9
What is a foreign key?
An Uploaded File in a Database
All the Columns of the Table
Primary Key in another Table
New Data Added to Database
10
A query is when you:
Create a Form
Add a Record
Delete a Record
Search the Database
11
How do you ensure data stolen by hackers can't be read easily?
Back it up
Delete it
Organise it
Encrypt it
12
Relational databases help to reduce
Two Table Corruption
Backup Failure
Data complexity
Data duplication
13
A primary key that is a combination of two or more attributes is a.... [HARD A* QUESTION!]
Non-Key
Composite Key
Foreign Key
Primary Key 2