stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Chapter 8 - MANAGING A DATABASE Flashcards | StudBud
Explore
/
Chapter 8 - MANAGING A DATABASE
__________ information gives more value than it cost to produce.
A range check ____
Chapter 8 - MANAGING A DATABASE
27 terms
·
StudBud Administration
·
1,307 plays
TUTORIAL 8
Flashcards
27 cards
F
Practice quiz
P
Host live
L
Questions
27
Answers
1
A range check ____
determines whether a number is within a specified range
ensures that users enter only alphabetic data into a field
ensures the users enter only numeric data into a field
verifies that a required field contains data
2
__________ information gives more value than it cost to produce.
cost-effective
organised
timely
verifiable
3
_______ information can be proven as correct or incorrect
timely
organised
cost-effective
verifiable
4
The database analyst ______
creates and maintains the data dictionary
decides on the proper placement of fields
checks backup and recovery procedures
monitors the performance of the database
5
The database administrator (DBA) perform the following functions except
decides on the proper placement of fields
monitors the performance of the database
checks backup and recovery procedures
manage security of the database
6
A database management system allows users to perform the following except _____
view web pages on Internet
create forms and reports from the data
add, modify, and delete data
create a computerized database
7
A composite key is a field in that uniquely identifies each record
True
False
8
Check digit, a validation used to make sure no errors occurred during the reading of barcode.
False
True
9
A report generator allows users to establishing who can enter, modify, delete, & view data
True
False
10
_________ checks if the input data contains the required number of characters.
range check
character check
length check
check digit
11
Data consistency identifies the quality of the data
True
False
12
Verification process compares data with a set of rules to find out if the data is correct
True
False
13
For sharing in a database, data is non-centralized & share over network by entire organization
False
True
14
__________ information has an aged suited to its use
timely
organised
cost-effective
verifiable
15
Validation a process where data is checked to see if it satisfies certain criteria
False
True
16
The following are functions perform by a database management system (DBMS) except _____________
data backup and recovery
data dictionary
file retrieval and maintenance
file compression
17
A ________ is a field that uniquely identifies each record in a file.
secondary key
primary key
composite key
key field
18
All of the following are strengths of the database approach, except _______
reduced development time
easier access
improved data integrity
less complexity
19
Database contains files, file contains records which contains fields that made up of character.
False
True
20
___ process where data is checked to see if it satisfies certain criteria/accepted boundaries.
verification
algorithms checking
error checking
validation
21
Data Backup & Recovery utility uses logs and/or backups to restore a database.
False
True
22
Information is a collection of unprocessed items which include text, numbers, images, etc.
False
True
23
____ procedures include adding records to modifying records in and deleting records from a file
validation
backup
consistency check
file maintenance
24
Data is a collection of processed items which can include text, numbers, images, etc
False
True
25
File maintenance include adding records to modifying records in & deleting records from a file
False
True
26
A database management system (DBMS) performs the following functions except _______
keeps track of who accessed data
design a report on the screen
access and browse web pages
specify the data to display, print or stored.
27
A _________contains data about each file in the database and each field in those files
data warehouse
data dictionary
data mart
data modeler
