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.
