What is meant by data mining?

Interrogating data stored in a warehouse to find patterns

What is meant by data redundancy?

Storing an item of data more than once

What is part of the definition for a distributed database?

One database controled by a DBMS, Storage is not attached to a common processor

What is meant by data normalisation?

A staged process which removes repeated groups of data

What is meant by data consistency?

Relationship between inputted, processed and outputted data

What is the definition of a file-file database?

A simple database that stores alldata in a single table

What is the definition of a database?

An organised collection of related data

What is the definition of a relational database?

Many databases or tables linked by primary and foreign keys

What is meant by data warehousing?

A large collection of archived data used for decision making

studbud

WJEC ICT ( A2 ) - Databases

13 termsStudBud Administration165 plays

Imported from external platform

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
Which is not an advantage of a relational database?
Avoids data duplication
Easy to set up
Increased security with hierarchy of passwords
Applications using the data are separate
2
What is meant by data mining?
Interrogating data stored in a warehouse to find patterns
Looking at data stored in a warehouse to find patterns
Interrogating data stored in a bin
Interrogating staff in a warehouse to find patterns
3
What is meant by data redundancy?
Storing data three times
Forgetting an item of data more than once
Storing an item of data more than once
Storing an item of data in a database
4
What is part of the definition for a distributed database?
Multiple databases controlled by a DBMS
Lots of databases on a network
One database controled by a DBMS
Storage is not attached to a common processor
5
What is meant by data normalisation?
A staged process which removes repeated fields
A staged process which removes data
A staged process which removes repeated groups of data
A process which removes repeated groups of data
6
What is meant by data consistency?
Relationship between irrelevant, postponed and outside data
Relationship between inserted, processed and outgoing data
Relationship between inputted, processed and outputted data
Relationship between inputted, processed and outsourced data
7
What is the definition of a file-file database?
A complex database that stores fields in multiple table
A simple database that stores fields in a single table
A database that does not store data
A simple database that stores alldata in a single table
8
What is the definition of a database?
A load of tables and stuff
A random collection of data
An organised collection of unrelated data
An organised collection of related data
9
What is the definition of a relational database?
Many databases or tables linked by primary keys
Many databases or tables linked by primary and foreign keys
Many databases or tables linked by stuff
Many databases or tables linked by foreign keys
10
What is not a feature of a flat-file database?
All data is stored in a single table
Can be created by spreadsheet software
There is sharing of data
Column headings are the field names
11
What is not an advantage of a distributed database?
If one server fails, anther can be used
Less data inconsistency
Faster response to user queries
Easy to backup
12
What is meant by data integrity?
The colour of the data
How big the data is
How incorrect the data is
How correct the data is
13
What is meant by data warehousing?
Archived cats used for decision making
A collection of archived data used for decision making
A large collection of archived data used for a laugh
A large collection of archived data used for decision making

WJEC ICT ( A2 ) - Databases Flashcards | StudBud