What is the purpose of proper test data?

To check the error-handling or data validation techniques

The protection of intellectual property

What is one advantage of having an online form for data collecting?

Overcoming terrible handwriting

Typical constraints of a database solution include:

cost, speed of processing, legal requirements, capacity.

A small file that a web server stores on the user’s computer

organisations acquire data via websites because

It saves times by having customers enter data directly

To achieve normalisation it is necessary to:

Remove duplicates from a database

studbud

Unit 3- Outcome 2 IT applications

20 termsStudBud Administration29 plays

Addressing components related to databases and acquiring information via websites

Flashcards20 cardsFPractice quizPHost liveL

Questions 20

Answers

1
Data is filtered using a:
Form
Macro
Report
Query
2
T is a:
Primary Key
Neither a Foreign key and primary key
Foreign Key
Both a Foreign key and primary key
3
Which design tool is best to show the relationship between tables in a database?
Mock up
Entity Relationship diagram
Input process output chart
Data dictionary
4
Because a form is a visual element, a _________ is used for its design.
user acceptance survey
Data flow diagram
Layout diagram
flowchart
5
What is the purpose of proper test data?
To identify users who will need more training
To ensure that network speeds are adequate
To check the error-handling or data validation techniques
To check that the system has been properly installed
6
Which of the following is likely to be an advantage of using a relational database
no repetition of data
specialised database management software is required
multiple tables are linked together via a common field
changes to the structure of a database can be complex
7
Copyright refers to
The protection of intellectual property
The protection of personal, sensitive and health information
The protection of basic rights of individuals
Guidelines of acceptable behaviour
8
Which of the following design tools would be most appropriate to use when designing a database?
Sitemap
IPO chart
storyboard
Nassi-shneiderman Chart
9
In a database table each _________ corresponds to a field and each __________ is a record
query, row
column, form
row, column
column, row
10
What is one advantage of having an online form for data collecting?
Overcoming the need to purchase notepads
Overcoming terrible handwriting
Having to rely on the postal system
Having to tell people of your address
11
The creation of a solution is part of which stage of the problem-solving methodology?
Design
Development
Evaluation
Analysis
12
Which of the following is not a form of electronic validation in a database?
Data Type Check
Range Check
Limited List
Proof reading
13
Typical constraints of a database solution include:
documentation, speed of processing, availability, capacity.
cost, documentation, legal requirements, capacity.
cost, speed of processing, legal requirements, capacity.
speed of processing, legal requirements, manipulation.
14
Which of the following would be most likely a data format for the data type of boolean?
label
text box
radio buttons
Check boxes
15
A set of data related to one entity in a database is known as a:
Record
Column
File
Field
16
Technique used by organisation to protect the rights of individuals supplying data via website?
Security protocols
proxy servers
social protocols
Communication protocols
17
Which element of a database is used for input?
Query
Table
Report
Form
18
What is a cookie?
A way of communicating with other users
A large executable application
A delicious biscuit
A small file that a web server stores on the user’s computer
19
organisations acquire data via websites because
It allows users to vote
It saves times by having customers enter data directly
It provides social networking opportunities
Customers can purchase goods and services
20
To achieve normalisation it is necessary to:
Ensure each field is unique
Ensure each record contains the same data types
Remove duplicates from a database
Combine fields to increase efficiency of space

Unit 3- Outcome 2 IT applications Flashcards | StudBud