Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

amanda > Lesson 1 > Flashcards

Lesson 1 Flashcards

1
Q

is a collection of related records

A

Data file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

is a combination of one or more related characters

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

compares data with a set of rules or values to find out if the data is correct

A

Validation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

consists of simple, English-like statements that allow users to specify the data to display, print, or store

A

Query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

is a query language that allows users to manage, update, and retrieve data

A

Structured Query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

refers to the procedures that keep data current

A

File maintenance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

uniquely identifies each record

A

Primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Collection of data organized in a manner that allows access, retrieval, and use of that data

A

Data base

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

a tool used to organize, store, retrieve, and communicate (report on) group of related information.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

a tool used by businesses to manage the huge amount of data required to run the business.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

contains data about each file in the database and each field in those files

A

Data Dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

the accuracy of a computer’s output depends on the accuracy of the input

A

Garbage in, garbage out (GIGO)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Collection of unprocessed items
* Text
* Numbers * Images
* Audio
* Video

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q
  • Processed data * Documents
  • Audio
  • Images
  • Video
A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

store data in rows and columns

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

retrieve and process data

A

Queries

17
Q

control data entry and data views

A

Forms

18
Q

summarize and print data

A

Reports

19
Q

group of related fields

A

Record

20
Q

a window on the screen that provides areas for entering or modifying data in a database

A

Form

21
Q

are used by a manager of any small organization to track necessary data

A

Filesystems

22
Q

provides a GUI to assist users with retrieving data

A

Query by example (QBE)

23
Q

allows users to design a report on the screen

A

Report Generator

24
Q

provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed

A

DBMS

25
Q

consists of rules and standards that define how the database organizes data

A

Data Model`

25
Q

stores data in tables that consist of rows and columns

A

Relational Database

26
Q

can store data in more than two dimensions of data

A

Multidimensional database

27
Q

is a huge database that stores and manages the data required to analyze historical and current transactions

A

Data Warehouse

28
Q

Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures

A

Data administrator (DBA)

28
Q

Decides on proper field placement, defines data relationship, and identifies users’ access privileges

A

Database Analyst (DA)

amanda (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions