Exam 1

Question 0

Database Management System = SOFT CRIN WTDB

Answer 0

Database Management System: software to create and interact with database.

Question 1

Database = LOST 2 STD

Answer 1

Database = logical structure to store data

Question 2

Each byte = CH BBB I

Answer 2

Each byte = character that is the basic building block of information.

Question 3

Record = CFSE & RPD

Answer 3

Record = collection of fields for specific entity and row in the physical database

Question 4

Relational Database Management System: SP CRDB ENT MAN RTD

Answer 4

Software to create the database and allows you to enter, manipulate, and retrieve data.

Question 5

SELECT statements are: ST 2 RT DFDB

Answer 5

Used to retrieve data from the database

Question 6

Syntax gives the BS ORU 4 CO

Answer 6

Gives the basic structure or rules for a command

Question 7

SELECT clause identifies

Answer 7

Columns

Question 8

FROM clause identifies

Answer 8

Tables

Question 9

Each clause begins with a:

Answer 9

Keyword

Question 10

To execute SQL statements use:

Answer 10

Semicolon or slash

Question 11

To select all data in a table:

Answer 11

Substitute an asterisk for the column names in a SELECT clause

Question 12

To select one column from a table:

Answer 12

Enter column name in SELECT clause

Question 13

To select multiple columns from a table:

Answer 13

Separate column names with a comma

Question 14

Enclose in double quotation marks when:

Answer 14

It contains blank spaces, special symbols or to retain case

Question 15

Arithmetic Operations are:

Answer 15

Executed left to right

Question 16

Multiplication and division are solved:

Answer 16

First with arithmetic operations

Question 17

Addition and subtraction are solved:

Answer 17

Last with arithmetic operations

Question 18

You override arithmetic operations with:

Answer 18

Parentheses

Question 19

To suppress duplicates:

Answer 19

Enter DISTINCT or UNIQUE after SELECT keyword

Question 20

Field= GRC

Answer 20

Field= group of related characters

Question 21

Field= ACE

Answer 21

Attribute or character of an entity

Question 22

Field= CPD

Answer 22

Column in the physical database

Question 23

File= GRSE

Answer 23

Group of records about the same type of entity

Question 24

Relational database = COR

Answer 24

Collection of relations

Question 25

Rows= DAE

Answer 25

Contain data about an entity

Question 26

Columns= DAAE

Answer 26

Data about attributes of the entity

Question 27

Cells= THSV

Answer 27

Cells of the table hold a single value

Question 28

Character = BUD & L, N, SS

Answer 28

Basic unit of data and can be a letter, #, or special symbol

Question 29

Bit= SDU

Answer 29

Smallest data unit

Question 30

Byte= 8FB

Answer 30

Few bits (usually 8)

Question 31

Database components:

Answer 31

Field, record, and file

Question 32

Relation:

Answer 32

Two-dimensional table

Question 33

Each column has:

Answer 33

A unique name

Question 34

The order of the columns is:

Answer 34

Unimportant

Question 35

The order of the rows is:

Answer 35

Unimportant

Question 36

No two rows can be:

Answer 36

Identical

Question 37

Table =

Answer 37

File

Question 38

File =

Answer 38

Relation

Question 39

Row =

Answer 39

Record

Question 40

Record =

Answer 40

Tuple

Question 41

Column =

Answer 41

Field

Question 42

Field =

Answer 42

Attribute

Question 43

Normalization:

Answer 43

Used to reduce or control data redundancy

Question 44

Primary key:

Answer 44

Field that serves to uniquely identify each record in a table

Question 45

Candidate key:

Answer 45

Any field that could be used as the primary key

Question 46

Surrogate key:

Answer 46

The records primary key identifier when no suitable primary key exists

Question 47

Foreign key:

Answer 47

A field in a table that is a primary key in another table

Question 48

Composite key:

Answer 48

A unique key that you create by combining two or more fields

Question 49

Partial dependency:

Answer 49

A column that is only dependent on a portion of the primary key

Question 50

1NF=

Answer 50

Eliminate repeating groups and identify primary key

Question 51

2NF=

Answer 51

Table is in 1NF and partial dependencies are eliminated

Question 52

3NF=

Answer 52

Table is in 2NF and transitive dependencies are eliminated

Question 53

Tables are linked through:

Answer 53

A common field

Question 54

Common field=

Answer 54

A primary key in one table and a foreign key in the other table

Question 55

SQL=

Answer 55

A data sub language that has constructs for defining and processing a database

Question 56

Data definition language is used to:

Answer 56

Define database structures

Question 57

Data Manipulation Language is used to:

Answer 57

Query and update data

Question 58

Concatenation:

Answer 58

Are two vertical bars and can combine data with string literal

Question 59

Concatenation allows use of:

Answer 59

Column alias

Question 60

WHERE clause is used to:

Answer 60

Retrieve rows based on a stated condition

Question 61

WHERE clause requires:

Answer 61

Column name, comparison operator, and value or column for comparison

Question 62

WHERE clause is:

Answer 62

Case sensitive

Question 63

List WHERE clause after:

Answer 63

FROM clause

Question 64

In WHERE clause enclose non-numeric data in:

Answer 64

Single quotes

Question 65

Comparison Operators:

Answer 65

Indicates how the data should relate to the given search value

Question 66

The default SQL format for dates is:

Answer 66

DD-MON-YY

Question 67

>

Answer 67

Greater than

Question 68

<

Answer 68

Less than

Question 69

<>

Answer 69

Not equal to

Question 70

<=

Answer 70

Less than or equal to

Question 71

>=

Answer 71

Greater than or equal to

Question 72

Math comparison operators may work with:

Answer 72

Text as well as numbers

Question 73

BETWEEN... AND Operator

Answer 73

To find values in a specified range

Question 74

IN Operator

Answer 74

Values are separated by commas and list must be in parentheses

Question 75

LIKE Operator

Answer 75

Performs pattern searches

Question 76

Logical operators:

Answer 76

Used to combing conditions

Question 77

Not

Answer 77

Reverses meaning

Question 78

And

Answer 78

Both conditions must be true

Question 79

Or

Answer 79

At least one condition must be true

Question 80

ORDER BY Clause

Answer 80

Presents data in sorted order

Question 81

Use DESC keyword to:

Answer 81

Override column default

Question 82

In ascending order, values will be listed in the following sequence:

Answer 82

Numeric values, character values, NULL values

Question 83

Secondary sort may be used to:

Answer 83

Sort multiple exact matches

Question 84

Joins are used to:

Answer 84

Link tables and reconstruct data in a relational database

Question 85

Joins can be created through:

Answer 85

Using the WHERE clause or using the JOIN keyword in the FROM clause

Question 86

Cross Join is created by omitting joining condition in the:

Answer 86

WHERE clause or through CROSS JOIN keywords in the FROM clause

Question 87

Equality Join:

Answer 87

Links rows through equivalent data in a common field that exists in both tables

Question 88

Equality join is also called:

Answer 88

Equijoins, natural join, inner joins, or simple joins

Question 89

Table Alias:

Answer 89

A temporary name that works like a column alias

Question 90

If a table alias is assigned to a table:

Answer 90

It must be used any time the table is referenced in the SQL statement

Question 91

Use NATURAL JOIN when:

Answer 91

Tables have one column in common

Question 92

Use JOIN... USING when:

Answer 92

Tables have more than one column in common

Question 93

Use JOIN... ON when:

Answer 93

A condition is needed to specify a relationship other than equivalency

Question 94

Using the JOIN keyword frees the:

Answer 94

WHERE clause for exclusive use in restricting rows

Question 95

Self Joins:

Answer 95

Used to link a table to itself

Question 96

Outer Joins

Answer 96

Used to include rows that do not have a match in the other table

Question 97

Set Operators

Answer 97

Used to combine the results of two or more SELECT statements