Brainscape's Knowledge GenomeTM

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


See full index

DataBase > DATABASE > Flashcards

DATABASE Flashcards

1
Q

Raw Facts

A

Data

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

Result of processing raw data to reveal meaning

A

Information

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

Must be formatted for storage, processing, and presentation.

A

Raw Data

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

Are the foundation of information, which is the bedrock of knowledge.

A

Data

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

Shares, integrated computer structure that stores a collection of end user data and metadata.

A

Database

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

Raw facts of interest to end user.

A

End-user data

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

Data about data.

It provides description of data characteristics and relationships in data.

Complements and expands value of data.

A

Metadata

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

What does DBMS stands for?

A

Database Management System

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

It lets you create a database.
‘Add, change, delete, sort, and view the data in a database.

A

DBMS

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

When and where did DBMS created?

A

1990’s Sweden

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

Software whose source code is freely and publicly available.

A

Open source software

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

Is a free and open-source cross-platform web server solution package developed by Apache Friends.

A

XAMPP

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

XAMPP stands for

A

X-operating system, Apache, Mysql, Php, Perl

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

Consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.

A

XAMPP

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

View data logically rather than physically

A

Relational model

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

Structural and data independence

Resembles a file conceptually

A

Table

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

Is easier to understand than hierarchical and network models

A

Relational database model

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

Perceived as a two-dimensional structure composed of rows and columns

A

Table

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

Represents a single entity occurrence within the entity set.

A

Table row

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

Represents an attribute, and each column has a distinct name.

A

Table column

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

TRUE or FALSE

Each intersection of a row and column represents a single data value.

A

TRUE

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

TRUE or FALSE

All values in a column must conform to the same data format.

A

TRUE

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

Each column has a specific range of values known as the

A

Attribute Domain

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

TRUE or FALSE

The order of the rows and columns is important to the DBMS.

A

FALSE

The order of the rows and columns is immaterial to the DBMS.

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

TRUE or FALSE

Each table must have an attribute or combination of attributes that uniquely identifies each row.

A

TRUE

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

Provides detailed accounting of all tables found within the user/designer-created database

Contains (at least) all the attribute names and characteristics for each table in the system

Contains metadata: data about data

A

Data dictionary

27
Q

Contains metadata

Detailed system data dictionary that describes all objects within the database

A

System catalog

28
Q

process of determining the particular tables and columns that will comprise a database.

A

Database Design

29
Q

(like a noun): person, place, thing or event

A

Entity

30
Q

(like an adjective or adverb): property of an entity

A

Attribute

31
Q

association between entities

A

Relationship

32
Q

Relational modeling ideal

Should be the norm in any relational database design

A

1:M relationship

33
Q

Should be rare in any relational database design

A

1:1 relationship

34
Q

Cannot be implemented as such in the relational model

can be changed into 1:M relationships

A

M:N relationships

35
Q

Popular and widely used language for retrieving and manipulating database data

A

Structured Query Language (SQL)

36
Q

When did SEQUEL renamed?

A

1980

37
Q

Used by most DBMSs

A

Structured Query Language (SQL)

38
Q

When did sql developed

A

mid-1970s

39
Q

question represented in a way that the DBMS
can understand

A

Query

40
Q

TRUE or FALSE

There is a special formatting rules in SQL

A

FALSE

No special formatting rules

41
Q

Use this command to retrieve specified columns
and all rows; e.g., list the number, name and balance
of all customers

A

SELECT

42
Q

It indicate all columns in the
SELECT clause

A

asterisk (*)

43
Q

Used to retrieve rows that satisfy some condition

A

WHERE clause

44
Q

column name, comparison
operator followed by either a column name or a value

A

Simple condition

45
Q

Connects two or more simple
conditions with AND, OR, and NOT operators

A

Compound condition

46
Q

all simple conditions are true

A

AND operator

47
Q

any simple condition is true

A

OR operator

48
Q

Reverses the truth of the original
condition

A

NOT operator

49
Q

Use instead of AND operator

Use when searching a range of values

Makes SELECT commands simpler to construct

A

BETWEEN Operator

50
Q

Does not exist in the database
but is computed using data in existing columns

A

Computed column

51
Q

Used for pattern matching

A

LIKE Operator

52
Q

Represents any single character

A

Underscore (_)

53
Q

TRUE or FALSE

By default, no defined order in which results are displayed

A

TRUE

54
Q

list data in a specific
order

A

ORDER BY clause

55
Q

column on which data is to be
sorted

A

Sort key or key

56
Q

Is default sort order

A

Ascending

57
Q

For descending order sort, use ___________

A

DESC

58
Q

Used to calculate totals of columns

A

SUM Function

59
Q

Eliminates duplicate values

Used with COUNT function

A

DISTINCT Operator

60
Q

an inner query placed inside another
query

A

Subquery

61
Q

uses subquery results

A

Outer query

62
Q

creates groups of rows that share
common characteristics

A

Grouping

63
Q

What is the difference between HAVING and WHERE.

A

WHERE: limit rows

HAVING: limit groups

Can use together if condition involves both rows and
groups

DataBase (1 decks)

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