Ch. 1 Flashcards Preview

Oracle 11g SQL > Ch. 1 > Flashcards

Flashcards in Ch. 1 Deck (27):
1

If uncontrolled, what can lead to data anomalies?

data redundancy

2

A record in the logical design of a database corresponds to a ____ in the physical database.

row

3

Analyzing historical sales data stored in a database is commonly referred to as ____.

data mining

4

A ____ is a group of interrelated files

database

5

Which of the following terms is considered the basic unit of data in a database?

character

6

Which of the following terms refers to a group of related records?

file

7

Which of the following committees are responsible for establishing SQL guidelines?

ANSI and ISO

8

Which of the following terms best describes where a group of characters that represents a customer’s address would be stored in the logical design?

field

9

A record in the logical design of a database is represented by what in the physical database?

row

10

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

systems design

11

A field in the logical design of a database is represented by what in the physical database?

column

12

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

systems analysis

13

The multi-step process used when creating a new system is referred to as ____.

the Systems Development Life Cycle

14

Which of the following is an example of an attribute?

a person’s hair color

15

Data mining refers to ____.

analyzing data already stored in a database

16

Which of the following terms represents a collection of fields?

record

17

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

systems deployment

18

Which of the following is used to uniquely identify each record?

primary key

19

What represents a characteristic or attribute that is being collected about an entity?

field

20

What is the first step in the SDLC?

1. Systems investigation: understanding the problem

21

What is the second step in the SDLC?

2. Systems analysis: understanding the solution to the previously identified problem

22

What is the third step in the SDLC?

3. Systems design: defining the logical and physical components

23

What is the fourth step in the SDLC?

4. Systems implementation: creating the system

24

What is the fifth step in the SDLC?

5. Systems integration and testing: placing the system into operation for testing

25

What is the sixth step in the SDLC?

6. Systems deployment: Placing the system into production

26

What is the seventh step in the SDLC?

7. Systems maintenance and review: evaluating the implemented system

27

What are the seven step process of the Systems Development Life Cycle (SDLC)?

Systems investigation
Systems analysis
Systems design
Systems implementation
Systems integration and testing
Systems deployment
Systems Maintenance and review