stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Revision 2 databases Flashcards | StudBud
Explore
/
Revision 2 databases
Revision 2 databases
12 terms
·
StudBud Administration
·
208 plays
Database revision Quiz for KS4 CS revision
Flashcards
12 cards
F
Practice quiz
P
Host live
L
Questions
12
Answers
1
When data is entered in a database is validated. What does validation mean? tick all correct
The process of checking that data entered is correct
The process of checking data
A check to see if data entered conforms to set rules
Valid date entered
2
Which statement is not true about a DBMS?
all data is available to all users
It controls who can see what data.
New applications can be made without affecting existing data
Data can be shared between applications
3
A format check is a type of data validation. A format check is?
Must be between a certain range of characters
A way of sending money to another person
Data entered must follow a set pattern
A way of making more space on a hard drive
4
What legislation do you need to know about in your CS exam
Health and Safety at work Act
Computer Misuse Act
Hunting with Dogs Act
Data protection Act
5
what do the initials DBMS stand for?
Database Money software
Dinosaur Megalithic Synapsis
Database Management system
Database Management Software
6
What features must a primary key have?
It must contain a unique value for each row of data
It must not contain null values
It can have the same value in one record as another
A database can have several primary keys
7
A field in a database is
A piece of data on one specific topic, in all records,
where plants are grown
A green area of grass
a collection of data about one thing
8
A table in a relational database is? tick all correct
A square thing or round thing with 4 legs
A collection of data about one specific area
Where the computer sits
An entity
9
Which statements are correct for a secondary key
A secondary key can make searches faster
A secondary key is the second primary key in an database
A table can have more than one secondary key
A secondary key is only found in schools
10
A check digit is
A number that used to specify an unique user
A number that is shaded in black and white squares
A number added to data, to check , it has not been corrupted
A number used in an Eastern European country.
11
a relational database is?
Two or more tables linked together.
A database about your friends and loves
A way of resolving arguments
A database created by a member of your family
12
The abbreviation CRUD stands for
Computing Register Unique Data
Create Read Update delete
CRUmbs Devoured
Computer Reads Undesirable Data
