The independence of data is reliant on

It's accessibility through multiple different applications

A board of directors would want to use DBMS for,

Allowing multiple departments to access central data

Data inconsistency is,

The same information being entered twice

May have different files but can't share them

A relational database is more secure than a flat file because

The possible restriction of access to part of the program

Why would someone use data normalisation?

To ensure a flexible extraction of data

studbud

Databases!

13 termsStudBud Administration124 plays

Cool kids databases for #year13#ICT#kids

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
The independence of data is reliant on
It's accessibility through different tables
It's accessibility through different databases
It's accessibility through multiple different applications
It's accessibility through different records
2
A board of directors would want to use DBMS for,
Being able to store data in one location
Allowing multiple departments to access central data
Creating an efficient way of surveying data from the public
Allowing more complex software than a centralised system
3
Data redundancy would be common with,
Relational databases
Flat file databases
4
Data inconsistency is,
The correctness of data
The actual typing of data
The same information being entered twice
Disk space being taken up
5
If people are finding errors in the data, what is at risk?
The collection of data
The ways the data can be accessed
Redundant data
The correctness of data
6
The store of large amounts of data for use later on is an example of
Data mining
Data storage
Data back-ups
Data warehousing
7
A large collection of data stored in tables containing links between them is an example of,
Flat file database
Distributed database
Relational Database
Data mining
8
Mathematical algorithms pick up meaningful patterns in,
Data validation
Data mining
Data encryption
Data distribution
9
SQL stands for,
Structured Query Logistics
Series Query Language
Standard Query Language
Structured Query Language
10
A flatfile database,
May have one file that cannot be shared
May have different files but can't share them
May have different files that can be shared
May have one file that can be shared
11
An advantage of a distributed database is,
Adding a hierarchy of passwords
Non-dependence
Modifying the structure of data
More complex software than a centralised system
12
A relational database is more secure than a flat file because
Data is stored on a number of computers
You can reduce the change of data redundancy
Data is stored on a single table
The possible restriction of access to part of the program
13
Why would someone use data normalisation?
To ensure relationships are maintained in the database
To transfer the data in between tables in the database
To ensure a flexible extraction of data
To make queries

Databases! Flashcards | StudBud