Which of the following terms refers to a group of related records?a. character
b. database
c. file
d. field - c. File
Which of the following is used to uniquely identify each record?
a. primary key
b. row
c. par
...
Which of the following terms refers to a group of related records?a. character
b. database
c. file
d. field - c. File
Which of the following is used to uniquely identify each record?
a. primary key
b. row
c. partial dependency
d. account number - a. Primary Key
Which of the following is used to create and maintain the physical database?
a. Database Management System (DBMS)
b. Data mining
c. Systems Development Life Cycle (SDLC)
d. E-R Model - a.
Database Management System (DBMS)
Which of the following committees are responsible for establishing SQL guidelines?
a. ANSI and ASCII
b. OSI and ASCII
c. IEEE and OSI
d. ANSI and ISO - d. ANSI and ISO
Which of the following is an example of an attribute?
a. a person's hair color
b. the people who live in a particular town
c. the patients in a doctor's office
d. vendors - a. a person's hair color
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?
a. composite primary key
b. foreign key
c. duplicate key
d. distinct key - b. Foreign Key
What represents a characteristic or attribute that is being collected about an entity?
a. record
b. row
c. field
d. both a and b - c. Field
The multi-step process used when creating a new system is referred to as
a. E-R Modeling
b. the Systems Development Life Cycle
c. data mining
d. SQL - b. the Systems Development Life Cycle
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
a. systems implementation and review
b. systems design
c. systems analysis
d. systems recovery - b. systems design
[Show More]