INFS 346 Final Exam | Answered with complete solutions

INFS 346 Final Exam | Answered with complete solutions Which of the following is typically NOT found in the database metadata? A. Column names B. Table names C. All answers here are correct D. Row names E. Column data types Front-end applications facilitate: A. Sometimes direct and sometimes indirect interaction (but not both at the same time) B. Neither direct nor indirect interaction C. Direct interaction D. Indirect interaction E. Both direct and indirect interaction Implicit (undocumented) changes of requirements are permitted during: A. Logical modeling B. Implicit (undocumented) changes of requirements are not permitted C. Database use D. Implicit (undocumented) changes of requirements are always permitted (during any stage) E. Database deployment Which of the following is an example of a daily operational procedure or task supported by an operational database? A. Bank deducting the correct amount of money from a customer's checking account upon an ATM withdrawal B. E-business issuing a correct bill to a customer who purchased a camera C. Flight attendant courteously greeting passengers entering an aircraft D. All of the above E. A and B only A multivalued composite attribute can be used to depict which of the following weak entity concepts? A. Identifying relationship B. A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity C. All of the answers here are correct D. Partially unique attribute E. A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity What is depicted by ER Diagrams? A. Neither data nor metadata B. Both data and metadata C. Metadata only D. Either data or metadata, but not both E. Data only Within an ER diagram that contains multiple entities, each entity must be related to at least one other entity via a relationship. A. True B. False The values of the following attribute are NOT permanently stored in a database. A. Unique attribute B. Optional attribute C. Multivalued attribute D. Composite attribute E. Derived attribute What is depicted by ER Diagrams? A. Either data or metadata, but not both B. Data only C. Both data and metadata D. Neither data nor metadata E. Metadata only Which of the following is a legitimate exact minimum and maximum cardinality? A. (5, 4) B. (20, 10) C. (5, 10) D. (5, 0) E. (0, 0) How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms. A. 1005 B. 115 C. 116 D. 4 E. 3 A multivalued composite attribute can be used to depict which of the following weak entity concepts? A. Partially unique attribute B. Identifying relationship C. A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity D. A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity E. All of the above Within an ER diagram that contains multiple entities, each entity must be related to at least one other entity via a relationship. A. True B. False How many entities are involved in a unary relationship? A. Less than zero. B. 2 C. Zero D. 1 E. More than 2 Which of the following is true according to the Central School Library ER diagram? A. Each library book has multiple copies B. Each library book must have at least 10 copies C. All of the statements give here are true D. Each library book must have more than 2 copies E. Each library book has one or more copies Which of the following is NOT true according to the Central School Library ER diagram? A. Each author has a different AuthorName value B. Each library book has a name C. Each copy of the same book must have a different CopyID value D. Each copy has a cover type E. Two copies can have the same CopyID value Which of the following is NOT true according to the Central School Library ER diagram? A. A book has a unique LBID B. A book can have no authors C. A book can have two authors D. A book can have more than two authors E. A book can have one author Which of the following is a legitimate exact minimum and maximum cardinality? A. (5, 4) B. (20, 10) C. (5, 10) D. (0, 0) E. (5, 0) Which of the following is NOT true? In a relational database: A. Two tables, in the same database, can have the same number of columns B. Two tables, in the same database, can have the same name C. A foreign key column of one table is related to a primary key column of another table D. Two tables can be a part of the same database E. Two tables, in the same database, can have the same number of rows Which of the following is true? In a relational table: A. Two columns can have identical values (i.e. same values in each row of those two columns) B. Two columns can have the same names C. Two rows can have identical values (i.e. same values in each column of those two rows) D. Values in the same column can be from different domains E. None of the above is true If a 1:M relationship is optional on both sides, which of the following is true? A. The resulting foreign key must have null (empty) values B. The resulting foreign key cannot have null (empty) values C. Two foreign keys are created as a result of mapping such a relationship, one that can have null (empty values) and one that cannot have null (empty values) D. The resulting foreign key can have null (empty) values E. No foreign key is created as a result of mapping such a relationship An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many relations? A. 3 B. 1 C. 2 D. 5 E. 4 If an entity has three unique attributes, how many primary keys will its mapped relation have? A. 4 B. 3 C. 0 D. 2 E. 1 If an M:N relationship is mandatory on one side and optional on the other side, and if both relations resulting from the entities involved in the relationship each have 3 records, then the resulting bridge relation CANNOT have less than A. 9 B. 3 C. 0 (no records required) D. 1 E. 4 What is depicted by relational schemas? A. Both data and metadata B. Neither data nor metadata C. Data only D. Metadata only E. Either data or metadata, but not both A foreign key column must have the same name as the primary key column it refers to. A. True B. False If in one of two identical relational tables the first row is moved to the last place, those two relational tables are no longer identical. A. True B. False Two columns of two different tables in the same relational database can have the same names. A. True B. False Every relation contains: A. Partial functional dependency B. Transitive functional dependency C. All of the answers given here are true D. Full key functional dependency E. None of the answers given here are true Which of the following is a modify operation? A. All of the answers given here are true B. Changing the existing data in the relation C. Retrieving data from the relation D. Entering new data in the relation E. Removing data from the relation Every relation contains: A. Trivial functional dependency B. Augmented functional dependency C. Equivalent functional dependency D. All of the answers given here are true E. None of the answers given here are true Which of the following (regarding the relation ENROLLMENT) represents the insertion anomaly? A. Inability to insert a student without adding a major B. Inability to insert a major without adding a student C. Inability to insert a major name without a major ID D. Inability to insert a student name without a student ID E. All of the answers given here are true Which of the following (regarding the relation ENROLLMENT) represents the deletion anomaly? A. Deleting a student may delete all information about a major B. None of the answers given here are true C. Deleting a student ID may delete a student name D. Deleting a major may delete all information about a student E. Deleting a major ID may delete the major name Which of the following (regarding the relation ENROLLMENT) represents the modification anomaly? A. If a student ID changes, we may have to change the major ID as well B. If a major name changes, it may have to be changed in more than one record C. If a major ID changes, we may have to change the student ID as well D. If a student decides to use a longer version of his or her name, we cannot accommodate that modification E. All of the above Which of the following is in danger of being affected by the deletion anomaly in the table ENROLLMENT (with its current 3 records)? A. Student 111, Joe B. Student 333, Lisa C. Major E, English D. Major H, History E. Student 222, Bob What type of functional dependency does NOT exist in the table ENROLLMENT? A. None of the functional dependencies listed here exist in the table ENROLLMENT B. Partial C. Full key D. Trivial E. Transitive Table ENROLLMENT is: A. In 1NF but not in 2NF B. In 3NF C. In 2NF but not in 3NF D. Not in 1NF E. None of the answers given here are true Normalizing table ENROLLMENT to 3NF will result in: A. No changes (table ENROLLMENT remains as is, no additional tables) B. Two separate tables C. Four separate tables D. Five separate tables E. Three separate tables Which of the following is an invalid SQL statement? A. SELECT*FROMemployee; B. SELECT *FROM employee; C. SELECT * FROM employee; D. SELECT * ,FROM employee; E. They are all invalid What is the result of the following SQL query?SELECT ename, esalary * 1.1 FROM employee; A. For each employee, the query will display the name, the salary, and all other columns from the table employee B. For each employee, the query will display the name, the salary, all other columns from the table employee, and the number 1.1 C. For each employee, the query will display the name and the salary increased by 10% D. For each employee, the query will display the name and 10% of the salary E. None of the above Which of the following statements would be used to change a value in a record of a table? A. CREATE TABLE B. ALTER TABLE C. INSERT INTO D. DELETE FROM E. UPDATE _____ statements are sued to create and modify the structure of the database A. DCL B. All SQL C. DML D. TCL E. DDL _______ statements are used to manipulate the data within the database A. DML B. DCL C. DDL D. TCL E. All SQL Which of the following is an invalid SQL keyword? A. SeLeCt B. SE_LECT C. selectT D. Select E. select What will be the result of the following query on table STUDENT? SELECT * FROM student; A. The entire relation STUDENT will be displayed B. StudentID column of the relation STUDENT will be displayed C. Last record of the relation STUDENT will be displayed D. First record of the relation STUDENT will be displayed E. None of the answers given here are correct What will be the result of the following query on table STUDENT? SELECT studentid FROM student; A. None of the answers given here are correct B. The entire relation STUDENT will be displayed C. StudentID column of the relation STUDENT will be displayed D. First record of the relation STUDENT will be displayed E. Last record of the relation STUDENT will be displayed Which of the following statements would be used to populate a table with data? A. SELECT B. CREATE TABLE C. DROP TABLE D. INSERT INTO E. UPDATE What will be the result of the following query on table STUDENT? SELECT studentid, ssn FROM student; A. StudentID column of the relation STUDENT will be displayed B. The entire relation STUDENT will be displayed C. None of the answers given here are correct D. First record of the relation STUDENT will be displayed E. Last record of the relation STUDENT will be displayed What is the appropriate data type for following data (column name is price): Price ====== 45.25 53.75 ..... A. numeric(2,2) B. numeric(4,2) C. Integer D. Char What is the purpose of an index? A. Increasing the speed and accuracy of queries and update operations. B. Increasing the speed of update operations. C. Increasing the speed of queries and update operations. D. Increasing the speed and accuracy of queries. E. Increasing the speed of queries. Which of the following statements given to you by a consultant should arouse suspicion? A. The reports we made for you allow you to enter the data about your customers. B. All the content on the web-site we made for you is stored in the database. C. The forms we made for you allow you to enter the data about your customers. D. The forms we made for you allow you to view the data about your customers. E. The reports we made for you allow you to view the data about your customers. Which of the following scenarios does not indicate a preventive data quality action? A. Joe focuses and gets some coffee before entering data B. Joe looks up correct spelling of value before entering it in the form on a web-site. C. Joe's entry of a value IG for his state is rejected, because the system knows that there is no state with the abbreviation IG. D. Joe realizes that he entered a misspelled value in the form on a web-site. He logs back into the web-site and corrects it. E. Joe uses a drop menu to enter the state value of his address A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis. A. True B. False The purpose of the source system is: A. Original operational purpose only B. As a write-only source system C. Both the original operational purpose and as a source system for the data warehouse D. Either as the original operational purpose or as a source system for the data warehouse, but not both E. As a source system for the data warehouse only In contrast to a narrow constituency of operational data, analytical data is used by a widespread set of users. A. True B. False Which of the following differences, renders normalization of data warehouses unnecessary? A. Data Update Difference only B. Data Redundancy Difference only C. Data Update Difference and Data Redundancy Difference D. Data Time-Horizon Difference only E. Data Time-Horizon Difference, Data Update Difference, and Data Redundancy Difference Which of the following would typically be stored in source systems? A. Subject-Oriented Data B. Derived Data C. Summarized Data D. Detailed Data E. All of the above is typically present in source systems. Which of the following would typically be stored in target systems? A. Subject-Oriented Data B. Derived Data C. Summarized Data D. Detailed Data E. All of the above is typically present in target systems Integrated data warehouse for a company that maintains exactly 4 operational databases (and no other operational data sources), and is not open to considering external sources, will have: A. At least 1 and at most 4 data sources. B. Between 0 and 4 data sources C. At least 2 and at most 4 data sources. D. At least 2 and up to more that 4 sources E. At least 1 and up to more that 4 sources Integrated data warehouse for a company that maintains exactly 4 operational databases (and no other operational data sources), and is open to considering external sources, will have: