Brainscape's Knowledge GenomeTM

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


See full index

Sql Advanced DataBase > Quiz 1 > Flashcards

Quiz 1 Flashcards

1
Q

What is Data

A

Raw facts

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

What is information?

A

the result of processing raw data to reveal its meaning

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

what is Knowledge

A

familiarity awareness and understanding of information

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

a discipline that focuses on properly generating storage and retrieval of data

A

Data management

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

a shared integrated computer structure that stores a collection of End-user-data and meta data

A

Database

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

Meta data

A

data about data

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

DBMS

A

Database management system

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

data inconsistency

A

when different versions of the same data appear in different places

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

Query

A

specific request

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

ad hoc query

A

spur of the moment question

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

query result set

A

what the dbms sends back

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

Data Quality

A

a comprehensive approach to promoting accuracy validity and timeliness of data

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

Single-user data base

A

supports one user

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

runs on personal computer

A

desktop database

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

multiuser data base

A

Supports multiple users at the same time

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

workgroup database

A

small number of users less then 50

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

enterprise database

A

more then 50 users

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

centralized database

A

data located at a single site

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

distributed database

A

data distributed across several different sites

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

general-purpose databases

A

contain a wide variety of data used in multiple diciplines

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

discipline-specific databases

A

contain data focused on specific subject areas

22
Q

operational database

A

supports a company’s day to day transactions

23
Q

operational databases are also known as

A

Online transactions processing (oltp), transaction, production database

24
Q

analytical databases

A

focus on storing historical data

25
Q

Data warehouse

A

stores data in a format optimized for decision making

26
Q

Set of tools that provide advanced data analysis

A

OLAP online analytical processing

27
Q

Business intelligence

A

approach to capture and process business data to help support business decisions

28
Q

data that exist in raw state

A

Unstructured data

29
Q

result of formating unstructured data to facilitate storaage

A

Structured data

30
Q

semistructured data

A

some structuring has been done

31
Q

special language used to manipulate data elements in a textual format

A

Markup Language XML

32
Q

supports the storage and management of semistructured xml data

A

XML database

33
Q

Social Media

A

anywhere anytime access style database

34
Q

Not only SQL

A

NoSQL

35
Q

focus on design of database

A

database design

36
Q

access to a file is dependent on its structure

A

Structural dependence

37
Q

You can change the file structure without affecting the application

A

Structural independence

38
Q

exists when you can change the data storage characteristics with out afftecting the programs ability to access the data

A

data independence

39
Q

When you cant change data storage characteristics and still access the data

A

Data dependence

40
Q

How the human views the data

A

Logical data format

41
Q

how the computer must work with the data

A

Physical data format

42
Q

Scattered locations of information

A

Islands of information

43
Q

keeping data in more then one place

A

Data redundancy

44
Q

when required changes in redundant data are not successful

A

Data anomaly

45
Q

organization of components that define and regulate the collection, storage management and use of data withing a database environment

A

Database System

46
Q

Used to look up required data component structures and relationships

A

Data dictionary

47
Q

relates to activities that make the database perform more effciently

A

Performance Tuning

48
Q

Nonprocedural language, lets the user specify what must be done without having to specify how

A

Query language

49
Q

SQL structured query language

A

de facto language of most dbms

50
Q

Loose coupling

A

Keeping the database separate from the application(dbms)

Sql Advanced DataBase (8 decks)

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