INFS 346 FINAL

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension PRESCRIPTION in the STATEWIDE HEALTH star schema has ________ record(s). A. 82 B. 5 C. 9 D. 0 (the dimension PRESCRIPTION does not exist) E. 3

D

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

C

ROLLBACK command reverses the effect of the COMMIT command. A. True B. False

B

Volume, Variety, and Velocity of data are terms applicable exclusively to Big Data. A. True B. False

B

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

E

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

E

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

E

________ contain analytically useful information. A. Fact tables B. Surrogate keys C. Transaction identifiers D. Dimension tables E. Both dimension and fact tables

E

Purpose of database policies and standards is to reflect and support business processes and business logic. A. True B. False

A

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

B

A foreign key column must have the same name as the primary key column it refers to. A. True B. False

B

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

B

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

C

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)

C

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.

E

Where on the Spectrum of Solutions for Large Analytical Data Repositories, would the following example best fit? Data from 10 data sources is extracted. Two of those sources have the exact same structure, so they are pasted together before loading. The rest of the sources are loaded as they were. A. Left edge of the spectrum (Pure Data Lake). B. Right edge of the spectrum (Fully Developed Data Warehouse). C. Exact middle of the spectrum. D. Inside the spectrum, closer to the right edge of the spectrum (Fully Developed Data Warehouse). E. Inside the spectrum, closer to the left edge of the spectrum (Pure Data Lake).

E

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

E

_____ statements are sued to create and modify the structure of the database A. DCL B. All SQL C. DML D. TCL E. DDL

E

The data definition component is a part of every DBMS package. A. True B. False

A

Which of the following is an invalid SQL keyword? A. SeLeCt B. SE_LECT C. selectT D. Select E. select

B

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)

C

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

A

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis. A. True B. False

A

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

E

In a typical, properly designed star schema, the number of records (rows) in any of the dimension tables is: A. Smaller than in the fact table B. Same as in the fact table C. No typical rule—there is an even number of dimension tables with larger, smaller and same number of records as in the fact table D. Larger than in the fact table E. Between 50 and 100

A

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

A

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension CALENDAR in the STATEWIDE HEALTH star schema has ________ record(s). A. 2 B. 3 C. 0 (the dimension CALENDAR does not exist) D. 1 E. 5

A

In the process of query optimization, query cost refers to: A. How long it takes to execute a query. B. How much hard drive and memory is used to execute a query. C. How much electricity is used to execute a query. D. How many query hints were used to execute a query. E. All of the above.

A

Same data in the data lake can be transformed and analyzed by multiple groups of users in different ways for a variety of different purposes. A. True B. False

A

The data manipulation DBMS component is used: A. By end users, either directly or via front-end applications B. By DBAs only. C. By end users, via front-end applications only D. By end users, directly only E. By no end users

A

Two columns of two different tables in the same relational database can have the same names. A. True B. False

A

Unstructured and semi-structured data processed by Hadoop can provide a source of data for a data warehouse. A. True B. False

A

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

A

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

A

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

A

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

A

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

A

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.

A

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

A

_______ statements are used to manipulate the data within the database A. DML B. DCL C. DDL D. TCL E. All SQL

A

________ contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs. A. Dimension tables B. Surrogate keys C. Transaction identifiers D. Both dimension and fact tables E. Fact tables

A

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

B

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.

D

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: A. At least 1 and at most 4 data sources. B. At least 2 and at most 4 data sources. C. At least 1 and up to more that 4 sources. D. Between 0 and 4 data sources. E. At least 2 and up to more that 4 sources.

E

Veracity, Variability, Value, and Visualization of data are terms applicable exclusively to Big Data. A. True B. False

B

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

B

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

B

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

B

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

B

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

B

In contrast to a narrow constituency of operational data, analytical data is used by a widespread set of users. A. True B. False

B

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

B

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

B

Which of the following data examples has the most structure? A. Web log entry B. A row in a relational table C. E-mail D. Tweet E. They all have the same amount of structure.

B

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

B

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

B

________ contain measures related to the subject of analysis. A. Dimension tables B. Fact tables C. Transaction identifiers D. Both dimension and fact tables E. Surrogate keys

B

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

C

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

C

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

C

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

E

What will be the outcome of the following two SQL statements:GRANT SELECT, INSERT, ALTER, UPDATE ON client TO shannon;REVOKE INSERT ON client FROM shannon; A. Shannon can read data from CLIENT, change data in CLIENT, change the metadata of CLIENT, insert data in CLIENT B. Grant can select, alter and update clients for Shannon. C. Shannon can read data from CLIENT, change data in CLIENT, change the metadata of CLIENT D. Shannon can read data from CLIENT, change data in CLIENT, insert data in CLIENT E. Shannon can revoke insert on CLIENT for Grant.

C

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

C

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

C

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

C

Which of the following is NOT a data administration task? A. Monitoring and maintaining the database system B. Securing the database against unauthorized access C. Creating a conceptual database model D. Providing database backup and recovery E. All of the above are data administration tasks

C

Which of the following is NOT true? A. Hadoop technology uses the MapReduce framework. B. Hadoop automatically collects the output of the Map phase, sorts it, and distributes it among the compute nodes executing the Reduce phase. C. The programmer using Hadoop has to write the functions for distributing the data among nodes. D. The programmer using Hadoop has to write the Map and Reduce functions. E. Both Map and Reduce tasks are distributed among multiple nodes.

C

Which of the following is applicable to a data lake? A. Potentially analytically useful data is transformed and then placed in the data lake. B. Data prepared, transformed, and analyzed by users, is loaded in the data lake. C. Potentially analytically useful data is extracted from sources and then placed in the data lake. D. The data in the date lake is automatically deleted from everywhere else where it previously existed. E. All data in the data lake is stored in one integrated star schema.

C

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

C

Which of the following is not true: A. Data marts are typically not as big as data warehouses B. Data marts typically have more narrow focus than data warehouses C. Data marts typically have more subjects than data warehouses D. Data marts typically have shorter implementation time than data warehouses E. Data marts typically have fewer data sources than data warehouses

C

Which of the following would NOT be found in an authorization matrix? A. User IDs B. SELECT command C. Recovery log checkpoint D. ALTER command E. Names of tables

C

Assume that aggregate fact Table B is based on the detailed fact table A. Which of the following is false. A. All dimensions connected to Table B are connected to Table A. B. Number of dimensions that Table B is connected to is equal or less than the number of dimensions that Table A is connected to. C. Number of records in Table B is equal or less than the number of records in Table A. D. Table B has more records than Table A. E. Table B provides aggregated view of facts in Table A.

D

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension DOCTOR in the STATEWIDE HEALTH star schema has ________ record(s). A. 0 (the dimension DOCTOR does not exist) B. 1 C. 2 D. 3 E. 5

D

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ record(s). A. 1 B. 5 C. 2 D. 3 E. 0 (the dimension MEDICATION does not exist)

D

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension PATIENT in the STATEWIDE HEALTH star schema has ________ record(s). A. 2 B. 5 C. 1 D. 3 E. 0 (the dimension PATIENT does not exist)

D

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

D

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

D

How many entities are involved in a unary relationship? A. Less than zero. B. 2 C. Zero D. 1 E. More than 2

D

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

D

The application development DBMS component provides functionalities to the developers of: A. Database models B. Security and backup procedures C. Data dictionaries D. Front-end applications E. All of the above

D

The data dictionary created by the ________ is often referred to as the catalog. A. TCL B. DML C. DCL D. DBMS E. All of the above

D

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

D

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

D

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

D

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

D

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

D

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

E

Big data sets, when compared with most databases and data warehouses: A. Are not as likely to benefit from visualization B. Have more metadata C. Need less explorative and experimental approaches to yield value D. Have equal amount of metadata E. Have higher possibility of different interpretations

E

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

E

Implicit changes of data warehouse requirements are permitted during: A. Data warehouse use B. Data warehouse deployment C. Creating ETL infrastructure D. DWH deployment E. Implicit changes of requirements are not permitted

E

Which of the following is NOT true? A. Telemetry data could be used as a source for adding data about the change in distance driven by drivers to the data warehouse. B. Telemetry data could be used as a source for adding data about drivers' driving skills to the data warehouse. C. Telemetry data could be used as a source for adding data about the frequency of vehicle use to the warehouse. D. Telemetry data could be used as a source for adding data about the change of frequency of vehicle use to the warehouse. E. Telemetry data could be used as a source for adding data about the range of prices of new vehicles to the warehouse.

E