CSCI 225 FINAL EXAM STUDY GUIDE
The following attribute can contain more than one value for each entity instance. Select one: a. A) Unique attribute b. B) Composite attribute c. C) Multivalued attribute d. D) Derived attribute
C
Which SQL keyword is used to sort the result-set? Select one: a. SORT BY b. ORDER c. ORDER BY
C
Which of the following describes the uniqueness data quality characteristic? Select one: a. D) The extent to which the data properly conforms to and matches up with the other data b. C) The extent to which data correctly reflects the real world instances it is supposed to depict c. B) The characteristic that requires each real-world instance to be represented only once in the data collection d. A) The degree to which all the required data is present in the data collection
C
Which of the following is a legitimate exact minimum and maximum cardinality? Select one: a. "B) (5, 0)" b. "A) (20, 10)" c. "C) (5, 10)" d. "D) (5, 4)"
C
Which of the following is NOT a possible cardinality constraint? Select one: a. C) Optional many b. A) Optional one c. D) Mandatory one d. B) Optional zero
D
Maximum cardinality can be optional. Select one: True False
False
ER modeling is a widely used logical database modeling method. Select one: True False
False
Update operations are also referred to as read operations. Select one: True False
False
"Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit." Select one: True False
True
A nonkey column is a column in a relation that is not a primary or a candidate key column. Select one: True False
True
A query retrieving the data from one relation can be used to populate another relation. Select one: True False
True
A web site can be an interface into a database. Select one: True False
True
Adding a unique attribute to a weak entity converts the weak entity to a regular entity. Select one: True False
True
Analytical databases are referred to as application-oriented. Select one: True False
False
"How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms." Select one: a. A) 3 b. B) 4 c. C) 115 d. D) 116
A
A regular entity must have at least one of the following attributes: Select one: a. A) Unique attribute b. B) Composite attribute c. C) Multivalued attribute d. D) Derived attribute
A
Autonumber data type option: Select one: a. C) Enables automatic generation of consecutive numeric data values in a column b. D) Enables automatic counting of columns in a table c. B) Assigns a number to each of the used data types d. A) Automatically converts the existing data type into a number type
A
The following attribute represents a collection of attributes: Select one: a. B) Composite attribute b. C) Multivalued attribute c. A) Unique attribute d. D) Derived attribute
A
The following is used at the end of an SQL statement to indicate the end of the SQL command. Select one: a. ; b. ? c. ! d. *
A
The values of the following attribute are NOT permanently stored in a database. Select one: a. D) Derived attribute b. A) Unique attribute c. C) Multivalued attribute d. B) Composite attribute
A
Which of the following describes the conformity data quality characteristic? Select one: a. D) The extent to which the data conforms to its specified format b. C) The extent to which data correctly reflects the real world instances it is supposed to depict c. A) The degree to which all the required data is present in the data collection d. B) The extent to which the data properly conforms to and matches up with the other data
A
Which of the following is NOT true? In a relational database: Select one: a. D) Two tables can have the same names b. B) Two tables can have the same number of columns c. A) Two tables can be a part of the same database d. C) Two tables can have the same number of rows
A
An associative entity is used as an alternative way of depicting: Select one: a. B) 1:1 relationships b. C) M:N relationships c. A) 1:M relationships d. D) Multivalued attributes
B
Joe is an example of: Select one: a. Data Type b. Metadata c. Data d. DBMS
C
"Within one relation, two rows can be identical." Select one: True False
False
A data mart is a data store based on the same principles as a data warehouse but with a wider scope. Select one: True False
False
A foreign key column must have the same name as the primary key column it refers to. Select one: True False
False
Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action. Select one: True False
False
Which of the following statements would be used to drop a column from the table? Select one: a. B) ALTER TABLE b. D) UPDATE c. C) DROP TABLE d. A) CREATE TABLE
A
Front-end applications facilitate: a. Indirect use b. Both direct and indirect use c. Direct use d. Neither direct nor indirect use
A
Maximum cardinality can be: Select one: a. B) Zero or many b. C) Optional or mandatory c. A) One or many d. D) Optional or many
C
Which of the following is a modify operation? Select one: a. B) Retrieving data from the relation b. A) Entering new data in the relation c. D) Changing the existing data in the relation d. C) Removing data from the relation
C
Which of the following is a read operation? Select one: a. D) Changing the existing data in the relation b. A) Entering new data in the relation c. B) Retrieving data from the relation d. C) Removing data from the relation
C
Which of the following is an invalid SQL keyword? Select one: a. C) selectT b. A) Select c. B) SE_LECT d. D) SeLeCt
C
With SQL, how do you select all the columns from a table named "Persons"? Select one: a. SELECT [all] FROM Persons b. SELECT Persons c. SELECT * FROM Persons d. EXTRACT Persons
C
Every relation without transitive functional dependencies is in 3NF. Select one: True False
False
Front-end applications are created in order to provide a mechanism for easy interaction between the database and the DBMS. Select one: True False
False
If A, B, C, and D are columns of the table whose composite primary key is A, B while C and D are nonkey columns then B --> D is a transitive functional dependency. Select one: True False
False
The logical database model is created prior to the conceptual database model. Select one: True False
False
"Within an ER diagram, each entity must be related to at least one other entity via a relationship." Select one: True False
True
"Within one entity, each attribute name must be different." Select one: True False
True
A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis. Select one: True False
True
A typical organization maintains and utilizes a number of operational data sources. Select one: True False
True
An attribute can be a part of several composite attributes. Select one: True False
True
Data warehouse front-end applications are often referred to as business intelligence (BI) applications. Select one: True False
True
Denormalization refers to reversing the effect of normalization by joining normalized relations into a relation that is not normalized. Select one: True False
True
Every relation without partial functional dependencies is in 2NF. Select one: True False
True
It is possible to join two tables without joining a foreign key column in one table with a primary key column in another table. Select one: True False
True
Mandating instantaneous entry of all new data is an example of a preventive data quality action. Select one: True False
True
The NOT NULL constraint enforces a column to not accept empty values. Select one: True False
True
Two columns of two different tables in the same relational database can have the same names. Select one: True False
True
End users can vary in: a. The frequency with which they access the database system b. The amount of data they need c. Their level of technical sophistication d. All of the above.
D
FirstName is an example of: Select one: a. Data b. DBMS c. Data Type d. Metadata
D
If A --> B and B --> A are existing functional dependencies, which of the following are NOT equivalent functional dependencies? Select one: a. A) A --> B and B --> A b. D) X, A --> B, X and X, B --> A, X c. B) A --> B, X and B --> A, X d. C) X --> A and A --> B
D
Tuple is a synonym for Select one: a. B) Field b. A) Column c. D) Table d. C) Row
D
What is the result of the following SQL query?SELECT ename FROM employee WHERE esalary = (SELECT MAX(salary) FROM employee); Select one: a. B) The query displays the salary of the employee (or employees) with the highest salary b. C) The query displays the name and the salary of the employee (or employees) with the highest salary c. A) The query displays the number that represents how many employees share the highest salary d. D) The query displays the name of the employee (or employees) with the highest salary
D
Which of the following is NOT a part of the data warehouse requirements step? Select one: a. C) Conceptual modeling b. A) Requirements collection c. B) Requirements definition d. D) Logical modeling
D
Which of the following is a format in which data can appear? Select one: a. Text b. Numbers c. Image d. All of the above
D
Which of the following is typically found in the database metadata? Select one: a. Student ages b. Employee names c. Product prices d. Data types
D
Which of the following statements would be used to change a value in a record of a table? Select one: a. A) CREATE TABLE b. B) ALTER TABLE c. C) INSERT INTO d. D) UPDATE
D
Which operator is used to select values within a range? Select one: a. RANGE b. WITHIN c. BETWEEN RANGE d. BETWEEN
D
With SQL, how can you insert a new record into the "Persons" table? Select one: a. INSERT VALUES Persons VALUES ('Jimmy', 'Jackson') b. ADD INTO Persons VALUES ('Jimmy', 'Jackson') c. INSERT Persons VALUES ('Jimmy', 'Jackson') d. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
D
Which of the following is a part of a Data Definition Language (DDL) statement? Select one: a. A) CREATE b. D) SELECT c. B) INSERT d. C) DELETE
A
Which of the following describes the accuracy data quality characteristic? Select one: a. A) The degree to which all the required data is present in the data collection b. C) The extent to which data correctly reflects the real world instances it is supposed to depict c. D) The extent to which the data properly conforms to and matches up with the other data d. B) The extent to which the data conforms to its specified format
B
Which of the following describes the consistency data quality characteristic? Select one: a. B) The characteristic that requires each real-world instance to be represented only once in the data collection b. D) The extent to which the data properly conforms to and matches up with the other data c. C) The extent to which data correctly reflects the real world instances it is supposed to depict d. A) The degree to which all the required data is present in the data collection
B
Every relation without partial functional dependencies is in 3NF. Select one: True False
False
Every relation without transitive functional dependencies is in 2NF. Select one: True False
False
Most RDBMS packages implement assertions using the CREATE ASSERTION statement. Select one: True False
False
The DELETE TABLE command is used to remove a table from the database. Select one: True False
False
How many entities are involved in a unary relationship? Select one: a. A) 1 b. B) 2 c. D) Between 1 and 2 d. C) More than 2
A
DBMS is software used for the following purpose: a. Insertion, storage, retrieval, update, and deletion of the data in the database b. All of the above c. Creation of databases d. Maintenance of databases
B
If A --> B is an existing functional dependency, which of the following is an augmented functional dependency? Select one: a. A) A, B --> C b. C) A --> C c. B) A, C --> B d. D) B --> A
C
Information can be used for: Select one: a. Neither for operational nor for analytical purposes b. Operational and analytical purposes c. Operational purposes only d. Analytical purposes only
B
How many entities are involved in a binary relationship? Select one: a. C) More than 2 b. B) 2 c. A) 1 d. D) Between 1 and 2
B
Minimum cardinality can be: Select one: a. B) Zero or many b. C) Optional or mandatory c. D) Optional or many d. A) One or many
B
What is the result of the following SQL statement?UPDATE employee SET salary = 50000 WHERE salary < 50000; Select one: a. "D) The statement sets the salary of each employee to 50,000" b. "C) The statement increases salary to 50,000 for each employee whose salary is below 50,000" c. "B) The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000" d. "A) The statement sets the salary for each employee to below 50,000"
B
Which SQL statement is used to delete data from a database? Select one: a. MINUS b. DELETE c. REMOVE d. COLLAPSE
B
Operational queries are typically issued: Select one: a. D) Never in a corporation that has users issuing analytical queries b. B) Less often than analytical queries c. C) Equally as often as analytical queries d. A) More often than analytical queries
D
An insertion anomaly occurs when a user who wants to insert data about one real world entity is forced to enter a unique value about it. Select one: True False
False
Data marts are always implemented as relational databases. Select one: True False
False
Entity instances are depicted in ER diagrams. Select one: True False
False
Every 3NF database can be further streamlined by including designer-added tables and keys. Select one: True False
False
Every ER notation uses the same rule for placement of cardinality constraints in the relationships of the ER diagram. Select one: True False
False
A DBMS can be used for creation of databases. Select one: True False
True
Which of the following describes the completeness data quality characteristic? Select one: a. B) The extent to which the data conforms to its specified format b. A) The degree to which all the required data is present in the data collection c. D) The extent to which the data properly conforms to and matches up with the other data d. C) The extent to which data correctly reflects the real world instances it is supposed to depict
B
Every normalized database is eventually denormalized. Select one: True False
False
Relation is a synonym for Select one: a. B) Field b. D) Table c. A) Column d. C) Row
B
Relationship attributes may be necessary in a relationship of what type? Select one: a. B) One-to-many b. D) Many-to-many c. C) Zero-to-many d. A) One-to-one
B
What does SQL stand for? Select one: a. Systematic Query Language b. Structured Query Language c. Strong Question Language d. Structured Question Language
B
Which SQL statement is used to extract data from a database? Select one: a. OPEN b. SELECT c. GET d. EXTRACT
B
Which SQL statement is used to insert new data in a database? Select one: a. ADD NEW b. INSERT INTO c. INSERT NEW d. ADD RECORD
B
Which SQL statement is used to return only different values? Select one: a. SELECT VARIANT b. SELECT DISTINCT c. SELECT UNIQUE d. SELECT DIFFERENT
B
What is the result of the following SQL query? SELECT ename, esalary * 1.1 FROM employee; Select one: a. For each employee, the query will display the name and the salary increased by 10% b. For each employee, the query will display the name, the salary, and all other columns from the table employee c. For each employee, the query will display the name and 10% of the salary d. For each employee, the query will display the name, the salary, all other columns from the table employee, and the number 1.1
A
Which of the following is a part of the database requirements step? Select one: a. Conceptual modeling b. Database deployment c. Logical modeling d. Database implementation
A
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table? Select one: a. DELETE FROM Persons WHERE FirstName = 'Peter' b. DELETE FROM Persons 'Peter' c. DELETE WHERE FirstName = 'Peter' d. DELETE FirstName='Peter' FROM Persons
A
_______ is a process used to improve the design of relational databases that contain redundant data and are therefore prone to update anomalies. Select one: a. D) Normalization b. B) Augmented functional dependency c. C) Trivial functional dependency d. A) Equivalent functional dependency
A
Data warehouse requirements can be refined and/or expanded following: Select one: a. B) Data warehouse deployment b. D) All of the above c. C) Creating ETL infrastructure d. A) Data warehouse useData warehouse requirements can be refined and/or expanded following: Select one: a. B) Data warehouse deployment b. D) All of the above c. C) Creating ETL infrastructure d. A) Data warehouse use
B
Which of the following describes the timeliness data quality characteristic? Select one: a. B) The characteristic that requires each real-world instance to be represented only once in the data collection b. D) The degree to which the data is aligned with the proper time window in its representation of the real world c. A) The degree to which all the required data is present in the data collection d. C) The extent to which the data properly conforms to and matches up with the other data
B
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Larry"? Select one: a. SELECT * FROM Persons WHERE FirstName<>'Larry' b. SELECT [all] FROM Persons WHERE FirstName LIKE 'Larry' c. SELECT * FROM Persons WHERE FirstName='Larry' d. SELECT [all] FROM Persons WHERE FirstName='Larry'
C