Ch.1/ Lab 6 Quiz Flashcards Preview

Oracle 11g SQL > Ch.1/ Lab 6 Quiz > Flashcards

Flashcards in Ch.1/ Lab 6 Quiz Deck (30):
1


Data in second normal form (2NF) may contain which of the following?

- repeating groups
- transitive dependencies
- partial dependencies
- both a and b

transitive dependencies

2


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

-data storage
-data mining
-data manipulation
-archived data

data mining

3


Which of the following may contain partial dependencies, but cannot contain repeating groups?

-unnormalized data
-first normal form (1NF)
-second normal form (2NF)
-third normal form (3NF)

first normal form (1NF)

4


What is added to a relational database to eliminate many-to-many relationships?

-bridging table
-transitive dependency
-primary entity
-secondary entity

bridging table

5


A DBMS includes which of the following capabilities?

-security
-data dictionary
-multiuser access
-all of the above

all of the above

6


Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?

-SQL
-SQL*Plus
-ASCII
-Script

SQL*Plus

7


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

-systems recovery
-systems analysis
-systems design
-systems implementation and review

systems design

8




If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

-Each customer can only own one car, but each car can be owned by many customers.

-Each customer can only own one car and each car can only be owned by one customer.

-Each customer can own many cars and each car can be owned by many customers.

-Each customer can own many cars, but each car can be owned by only one customer

Each customer can own many cars, but each car can be owned by only one customer.

9


Which of the following is used to determine the correct organization for data that is to be stored in a database?

-E-R model
-normalization process
-systems implementation and review
-systems analysis

normalization process

10


A ____ is a storage structure designed to hold a collection of data.

-column
-row
-table
-database

database

11


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

-primary key
-row
-partial dependency
-account number

primary key

12


Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

-systems analysis
--systems investigation
-systems design
-all of the above are steps in the SDLC

all of the above are steps in the SDLC

13


Data in third normal form (3NF) contains which of the following?

-repeating groups
-transitive dependencies
-partial dependencies
-none of the above

none of the above

14


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

-record
-row
-field
-both a and b

field

15


Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?

-one-to-many
-many-to-many
-one-to-all
-one-to-one

one-to-many

16



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

-attribute
-field
-tuple
-row

row

17


Which of the following can be used to link the data in two or more tables together?

-repeating group
-relationships
-SDLC
-common field

common field

18


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

-ANSI and ASCII
-ANSI and ISO
-IEEE and OSI
-OSI and ASCII

ANSI and ISO

19


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

-database
-character
-field
-file

file

20


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

-column
-row
-field
-row

column

21


A foreign key is usually found on which side of a relationship?

-one
-many
-unnormalized
-primary entity

many

22


The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

-one-to-many
-many-to-many
-one-to-all
-one-to-one

many-to-many

23


Which of the following usually correlates to a primary key in another table?

-transitive dependency
-composite primary key
-foreign key
-partial dependency

foreign key

24


Which of the following is used to create and maintain the physical database?

-Data mining
-Database Management System (DBMS)
-E-R Model
-Systems Development Life Cycle (SDLC)

Database Management System (DBMS)

25


Partial dependency exists if what conditions exist?

-a column is dependent on a portion of the table that is not identified as the primary key
-a column is dependent only on a portion of a composite primary key
-the data contains repeating groups
-the table is not in first normal form (1NF)

a column is dependent only on a portion of a composite primary key

26


In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

-entity
-row
-attribute
-file

entity

27


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

-Systems Development Life Cycle (SDLC)
-data mining
-E-R Modeling
-SQL

Systems Development Life Cycle (SDLC)

28


What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

-duplicate key
-foreign key
-composite primary key
-distinct key

-foreign key

29


Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

-unnormalized data
-first normal form (1NF)
-second normal form (2NF)
-third normal form (3NF)

-first normal form (1NF)

30


Which of the following can lead to partial dependencies?

-composite primary key
-common fields
-foreign keys
-normalization

composite primary key