INFS 346 Final: Quizzes

Which of the following is an invalid SQL statement? -SELECT * FROM employee; -SELECT * FROM employee; -SELECT * FROM employee; -SELECT *, FROM employee; -they are all invalid

SELECT *, FROM employee;

Which of the following is true according to the Central School Library ER diagram? -each library book must have at least 10 copies -each library book must have more than 2 copies -each library book has multiple copies -each library book has one or more copies -all of the statements given here are true

each library book has multiple copies

What is the result of the following SQL query? SELECT ename, esalary * 1.1 FROM employee; -for each employee, the query will display the name, the salary, and all other columns from the table employee -for each employee, the query will display the name, the salary, all other columns from the table employee, and the number 1.1 -for each employee, the query will display the name and the salary increased by 10% -for each employee, the query will display the name and 10% of the salary -none of the above

for each employee, the query will display the name and 10% of the salary

What type of function dependency does NOT exist in the table ENROLLMENT? -transitive -trivial -full key -partial -none of the functional dependencies listed here exist in the table ENROLLMENT

partial

Which of the following is a legitimate exact minimum and maximum cardinality? -(5, 0) -(0, 0) -(20, 10) -(5, 10) -(5, 4)

(5, 10)

If an entity has three unique attributes, how many primary keys will its mapped relation have? -1 -4 -0 -3 -2

1

Consider the tables below. How many rows will the following query return? -5 -3 -4 -1 -2

2

Consider the tables below. How many rows will the following query return? -1 -8 -3 -0 -5

5

Consider the tables below. How many rows will the following query return? -8 -0 -1 -5 -3

5

How many steps will linear search need to find the Sales Rep whose SRID value is 5555? -0 -9 -5 -It is impossible to find the sales rep whose SRID value is 5555 -1

5

Which of the following is an example of a daily operational procedure or task supported by an operational database? -Bank deducting the correct amount of money from a customer's checking account upon an ATM withdrawal -E-business issuing a correct bill to a customer who purchased a camera -flight attendant courteously greeting passengers entering an aircraft -all of the above -A and B only

A and B only

The data dictionary created by the ________ is often referred to as the catalog. -TCL -DML -DCL -DBMS -all of the above

DBMS

_____ statements are sued to create and modify the structure of the database -DML -TCL -DDL -All SQL -DCL

DDL

Normalizing table ENROLLMENT to 3NF will result in: -two separate tables -four separate tables -five separate tables -no changes -three separate tables

two separate tables

Implicit (undocumented) changes of requirements are permitted during: -database deployment -Implicit (undocumented) changes of requirements are always permitted (during any stage) -Implicit (undocumented) changes of requirement are not permitted -database use -logical modeling

Implicit (undocumented) changes of requirement are not permitted

The application development DBMS component provides functionalities to the developers of: -database models -security and backup procedures -data dictionaries -front-end applications -all of the above

front-end applications

Assume that the referential integrity constraint between SALESREP and REGION tables is implemented with the delete restrict option. How many records in the table REGION can be deleted? -1 -4 -0 -3 -2

1

Consider the tables below. How many rows will the following query return? -1 -5 -3 -2 -4

1

How many entities are involved in a unary relationship? -less than zero -more than 2 -2 -0 -1

1

How many steps will binary search need to find the Sales Rep whose SRID value is 5555? -0 -1 -5 -9 -It is impossible to find the sales rep whose SRID value is 5555

1

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

2

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension PATIENT in the STATEWIDE HEALTH star schema has ________ record(s). -5 -0 (the dimension patient doesn't exist) -1 -2 -3

3

An ER diagram that contains two entities involved in two separate M:N relationships will be mapped as how many relations? -4 -3 -2 -5 -1

4

Assume that the referential integrity constraint between SALESREP and REGION tables is implemented with the delete restrict option. How many records in the table SALESREP can be deleted? -0 -1 -2 -3 -4

4

Assume that the referential integrity constraint between SALESREP and REGION tables is implemented with the delete restrict option. How many rows will each table have if a user attempts to delete the first record in the table REGION? -REGION: 3 records SALES REP: 3 records -REGION: 3 records SALES REP: 2 records -REGION: 4 records SALES REP: 4 records -REGION: 3 records SALES REP: 4 records -REGION: 4 records SALES REP: 3 records

REGION: 4 records SALESREP: 4 records

Which of the following is an invalid SQL keyword? -SeLeCt -select -SE_LECT -Select -selecT

SE_LECT

What will be the result of the following query on table STUDENT? SELECT studentid, ssn FROM student; -none of the answers given here are correct -studentID column of the relation STUDENT will be displayed -last record of the relation STUDENT will be displayed -the entire relation STUDENT will be displayed -first record of the relation STUDENT will be displayed

none of the answers given here are correct

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension PRESCRIPTION in the STATEWIDE HEALTH star schema has ________ record(s). -3 -0 (the dimension prescription doesn't exist) -5 -82 -9

0

Consider the tables below. How many rows will the following query return? -2 -5 -3 -1 -4

3

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 -1 -3 -9 -0 (no records required) -4

3

Consider the tables below. What will be the result of the following query? -333 -333 Lisa 30 RAD -Sue -Lisa -Lola

333

Consider the tables below. What will be the result of the following query? -Jill -Linda -Lisa -RAD -30

Lisa

Which of the following data examples has the most structure? -they all have the same amount of structure -a row in a relational table -e-mail -tweet -web log entry

a row in a relational table

Which of the following (regarding the relation ENROLLMENT) represents the deletion anomaly? -none of the answers given here are true -deleting a student ID may delete a student name -deleting a major may delete all information about a student -deleting a student may delete all information about a major -deleting a major ID may delete the major name

deleting a student may delete all information about a major

The values of the following attribute are NOT permanently stored in a database. -optional attribute -multivalued attribute -composite attribute -derived attribute -unique attribute

derived attribute

Which of the following would typically be stored in source systems? -subject-oriented data -derived data -summarized data -detailed data -all of the above is typically present in source systems

detailed data

________ contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs. -surrogate keys -both dimension and fact tables -fact tables -transaction identifiers -dimension tables

dimension tables

Which of the following is NOT true according to the Central School Library ER diagram? -each copy has a cover type -each library book has a name -each author has a different authorname value -two copies can have the same copyid value -each copy of the same book must have a different copyid value

each author has a different authorname value

Consider the tables below. What will be the result of the following query? -111 Jill -111 Surgery -111 Jill Surgery -Jill Surgery -111 Jill SUR

Jill Surgery

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

True

Purpose of database policies and standards is to reflect and support business processes and business logic -True -False

True

Which of the following would typically be stored in target systems? -subject-oriented data -derived data -summarized data -detailed data -all of the above is typically present in source systems

all of the above is typically present in source systems

Front-end applications facilitate: -Indirect interaction -neither direct nor indirect interaction -direct interaction -sometimes direct and sometimes indirect interaction (but not both at the same time) -both direct and indirect interaction

indirect interaction

_______ statements are used to manipulate the data within the database -DCL -DDL -DML -All SQL -TCL

DML

Which of the following statements would be used to populate a table with data? -SELECT -CREATE TABLE -DROP TABLE -INSERT INTO -UPDATE

INSERT INTO

Which of the following scenarios does not indicate a preventive data quality action? -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. -Joe uses a drop menu to enter the state value of his address -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. -Joe looks up correct spelling of value before entering it in the form on a web-site. -Joe focuses and gets some coffee before entering data

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.

Assume that the referential integrity constraint between SALESREP and REGION tables is implemented with the delete cascade option. How many rows will each table have if a user attempts to delete the first record in the table REGION? -REGION: 3 records SALES REP: 3 records -REGION: 3 records SALES REP: 2 records -REGION: 4 records SALES REP: 4 records -REGION: 3 records SALES REP: 4 records -REGION: 4 records SALES REP: 3 records

REGION: 3 records SALESREP: 2 records

The data definition component is a part of every DBMS package -True -False

True (it is used to create the components of the database, which are necessary for the database to function)

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. -left edge of the spectrum (Pure Data Lake). -right edge of the spectrum (Fully Developed Data Warehouse). -exact middle of the spectrum. -inside the spectrum, closer to the right edge of the spectrum (Fully Developed Data Warehouse). -inside the spectrum, closer to the left edge of the spectrum (Pure Data Lake).

inside the spectrum, closer to the left edge of the spectrum (Pure Data Lake)

Consider the tables below. What will be the result of the following query? -number 40 shown on the screen -number 70 shown on the screen -number 2 shown on the screen -number 20 shown on the screen -number 100 shown on the screen

number 40 shown on the screen

Which of the following would NOT be found in an authorization matrix? -user IDs -ALTER command -SELECT command -Names of tables -recovery log checkpoint

recovery log checkpoint

How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms. -3 -115 -4 -116 -1005

3

Volume, variety, and velocity of data are terms applicable exclusively to Big Data -True -False

False

If a 1:M relationship is optional on both sides, which of the following is true? -the resulting foreign key cannot have null values -the resulting foreign key can have null values -two foreign keys are created as a result of mapping such a relationship, one that can have null values and one that cannot have null values -the resulting foreign key must have null values -no foreign key is created as a result of mapping such a relationship

the resulting foreign key can have null values

Every relation contains: -augmented functional dependency -trivial functional dependency -none of the answers given here are true -equivalent functional dependency -all of the answers given here are true

trivial functional dependency

ROLLBACK command reverses the effect of the COMMIT command -True -False

False

Veracity, variability, value, and visualization of data are terms applicable exclusively to Big Data -True -False

False

Which of the following (regarding the relation ENROLLMENT) represents the modification anomaly? -if a student ID changes, we may have to change the major ID as well -if a major name changes, it may have to be changed in more than one record -if a major ID changes, we may have to change the student ID as well -if a student decides to use a longer version of his or her name, we cannot accommodate that modification -all of the above

if a major name changes, it may have to be changed in more than one record

What is the appropriate data type for following data (column name is price): Price ====== 45.25 53.75 -numeric (2,2) -numeric (4,2) -Integer -char

numeric (4,2)

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ record(s). -0 (the dimension medication doesn't exist) -5 -1 -3 -2

3

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: -at least 2 and at most 4 data sources -at least 1 and at most 4 data sources -at least 2 and up to more than 4 sources -between 0 and 4 data sources -at least 1 and up to more than 4 sources

at least 2 and at most 4 data 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: -at least 1 and at most 4 data sources. -between 0 and 4 data sources. -at least 1 and up to more that 4 sources. -at least 2 and up to more that 4 sources. -at least 2 and at most 4 data sources.

at least 2 and up to more than 4 sources

Which of the following is not true: -data marts typically have more subjects than data warehouses -data marts typically have shorter implementation time than data warehouses -data marts typically have fewer data sources than data warehouses -data marts typically have more narrow focus than data warehouses -data marts are typically not as big as data warehouses

data marts typically have more subjects than data warehouses

Which of the following differences, renders normalization of data unnecessary? -data update difference only -data redundancy difference only -data update difference and data redundancy difference -data time-horizon difference, data update difference, and data redundancy difference -data time-horizon difference only

data update difference and data redundancy difference

A multivalued composite attribute can be used to depict which of the following weak entity concepts? -all of the answers here are correct -A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity -partially unique attribute -Identifying relationship -a regular (non-identifying) many-to-many relationship between a weak entity and a regular entity

identifying relationship

Which of the following (regarding the relation ENROLLMENT) represents the insertion anomaly? -Inability to insert a student without adding a major -Inability to insert a major without adding a student -Inability to insert a major name without a major ID -Inability to insert a student name without a student ID -all of the answers given here are true

inability to insert a major without adding a student

Which of the following is a modify operation? -removing data from the relation -retrieving data from the relation -entering new data in the relation -all of the answers given here are true -changing the existing data in the relation

changing the existing data in the relation

What is depicted by ER diagrams? -metadata only -data only -neither data nor metadata -either data or metadata, but not both -both data and metadata

metadata only

What is depicted by relational schemas? -either data or metadata, but not both -data only -neither data nor metadata -metadata only -both data and metadata

metadata only

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

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. -True -False

False

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

False

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. -True -False

True

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

True

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

True

Within an ER diagram that contains multiple entities, each entity must be related to at least one other entity via a relationship. -True -False

True

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

3

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

the programmer using Hadoop has to write the functions for distributing the data among nodes.

Which of the following statements given to you by a consultant should arouse suspicion? -the reports we made for you allow you to view the data about your customers. -the reports we made for you allow you to enter the data about your customers. -the forms we made for you allow you to view the data about your customers. -the forms we made for you allow you to enter the data about your customers. -all the content on the web-site we made for you is stored in the database.

the reports we made for you allow you to enter the data about your customers.

Which of the following is true? In a relational table: -two columns can have identical values (i.e. same values in each row of those two columns) -two columns can have the same names -two rows can have identical values (i.e. same values in each column of those two rows) -values in the same column can be from different domains -none of the above is true

two columns can have identical values (i.e. same values in each row of those two columns)

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; -Shannon can revoke insert on CLIENT for Grant. -Shannon can read data from CLIENT, change data in CLIENT, change the metadata of CLIENT -Shannon can read data from CLIENT, change data in CLIENT, change the metadata of CLIENT, insert data in CLIENT -Shannon can read data from CLIENT, change data in CLIENT, insert data in CLIENT -Grant can select, alter and update clients for Shannon.

Shannon can read data from CLIENT, change data in CLIENT, change the metadata of CLIENT

________ contain analytically useful information. -fact tables -dimension tables -transaction identifiers -surrogate keys -both dimension and fact tables

both dimension and fact tables

The purpose of the source system is: -as a source system for the data warehouse only -original operational purpose only -as a write-only source system -either as the original operational purpose or as a source system for the data warehouse, but not both -both the original operational purpose and as a source system for the data warehouse

both the original operational purpose and as a source system for the data warehouse

The data manipulation DBMS component is used: -by end user, via front-end applications only -by no end users -by end users, either directly or via front-end applications -by end users, directly only -by DBAs only

by end users, either directly or via front-end applications

Which of the following is NOT a data administration task? -monitoring and maintaining the database -securing the database against unauthorized access -creating a conceptual database model -providing database backup and recovery -all of the above are data administration tasks

creating a conceptual database model

________ contain measures related to the subject of analysis. -dimension tables -fact tables -both dimension and fact tables -surrogate keys -transaction identifiers

fact tables

Which of the following is applicable to a data lake? -all data in the data lake is stored in one integrated star schema. -the data in the date lake is automatically deleted from everywhere else where it previously existed. -data prepared, transformed, and analyzed by users, is loaded in the data lake. -potentially analytically useful data is extracted from sources and then placed in the data lake. -potentially analytically useful data is transformed and then placed in the data lake.

potentially analytically useful data is extracted from sources and then placed in the data lake.

Which of the following is NOT true according to the Central School Library ER diagram? -a book can have two authors -a book can have no authors -a book can have one author -a book has a unique LBID -a book can have more than two authors

a book can have no authors

Every relation contains: -all of the answers given here are true -partial functional dependency -transitive functional dependency -full key functional dependency -none of the answers given here are true

full key functional dependency

Implicit changes of data warehouse requirements are permitted during: -data warehouse use -data warehouse deployment -creating ETL infrastructure -DWH deployment -Implicit changes of requirements are not permitted

Implicit changes of requirements are not permitted

Which of the following statements would be used to change a value in a record of a table? -CREATE TABLE -ALTER TABLE -INSERT INTO -DELETE FROM -UPDATE

UPDATE

Consider the tables below. What will be the result of the following query? -number 3 shown on the screen -numbers 2 and 1 shown on the screen -number 1 shown on the screen -number 5 shown on the screen -numbers 2, 1, and 2 shown on the screen

numbers 2, 1, and 2 shown on the screen

In a typical, properly designed star schema, the number of records (rows) in any of the dimension tables is: -smaller than in the fact table -no typical rule-there is an even number of dimension tables with larger, smaller and same number of records as in the fact table -larger than in the fact table -same as in the fact table -between 50 and 100

smaller than in the fact table

What will be the result of the following query on table STUDENT? SELECT studentid FROM student; -studentID column of the relation STUDENT will be displayed -none of the answers given here are correct -the entire relation STUDENT will be displayed -last record of the relation STUDENT will be displayed -first record of the relation STUDENT will be displayed

studentID column of the relation STUDENT will be displayed

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

table B has more records than table A

What will be the result of the following query on table STUDENT? SELECT * FROM student; -the entire relation STUDENT will be displayed -studentID column of the relation STUDENT will be displayed -last record of the relation STUDENT will be displayed -first record of the relation STUDENT will be displayed -none of the answers given here are correct

the entire relation STUDENT will be displayed

Which of the following is NOT true? In a relational database: -two tables can be a part of the same database -two tables, in the same database, can have the same name -two tables, in the same database, can have the same number of columns -two tables, in the same database, can have the same number of rows -a foreign key column of one table is related to a primary key column of another table

two tables, in the same database, can have the same name

Big data sets, when compared with most databases and data warehouses: -have higher possibility of different interpretations -need less explorative and experimental approaches to yield value -are not as likely to benefit from visualization -have more metadata -have equal amount of metadata

have higher possibility of different interpretations

In the process of query optimization, query cost refers to -how long it takes to execute a query -how much hard drive and memory is used to execute a query -how much electricity is used to execute a query -how many query hints were used to execute a query -all of the above

how long it takes to execute a query

Table ENROLLMENT is: -In 1NF but not in 2NF -none of the answers given here are true -In 2NF but not in 3NF -not in 1NF -In 3NF

in 2NF but not in 3NF

What is the purpose of an index? -Increasing the speed of queries and update operations -Increasing the speed of update operations -Increasing the speed and accuracy of queries and update operations -Increasing the speed of queries -Increasing the speed and accuracy of queries

increasing the speed of queries

Which of the following is in danger of being affected by the deletion anomaly in the table ENROLLMENT (with its current 3 records)? -student 111, Joe -student 333, Lisa -student 222, Bob -major E, English -major H, History

major E, English

Which of the following is typically NOT found in the database metadata? -all answers here are correct -table names -column names -column data types -row names

row names

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

telemetry data could be used as a source for adding data about the range of prices of new vehicles to the warehouse.