CIST 1220 Final Exam Study Guide Summer 2022

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