CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022.

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 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