ISYS5351

Identify which of the following modeling element is not associated with Use case diagrams? a) Actor b) Include relationship c) Exclude relationship d) Aggregate relationship

d) Aggregate relationship

Adding a unique attribute to a weak entity converts the weak entity to a regular entity. T/F

TRUE

Every relation is in 1NF. T/F

TRUE

A ternary relationship can always be depicted as three binary relationships. T/F

FALSE

A unary relationship cannot have mandatory participation on both sides. T/F

FALSE

Aggregated fact tables have a finer level of granularity than detailed tables. T/F

FALSE

Database implementation involves using ________ to implement the database model as an actual database. a) Front-end applications b) DBMS c) Database system d) Indirect interaction

b) DBMS

Which of the following is NOT true: a) Data marts typically have fewer data sources than data warehouses b) Data marts typically have broader focus than data warehouses c) Data marts are typically not as big as data warehouses d) Data marts typically have shorter implementation time than data warehouses

b) Data marts typically have broader focus than data warehouses

The set of processes that is used to populate the data warehouse tables with the appropriate relevant data retrieved from the operational databases is known as: a) BI b) ETL c) OLAP d) OTLP

b) ETL

Which of the following is NOT true? Front-end (BI) applications are used to retrieve the data from: a) Dependent data marts b) ETL infrastructure c) Independent data marts d) Data warehouse

b) ETL infrastructure

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

c) (5, 10)

"If an M:N relationship is mandatory on both sides, 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 ________ records." a) 0 b) 1 c) 3 d) 9

c) 3

"Typically, in a star schema all ________ are given a simple, non-composite system-generated key, also called a surrogate key." a) Fact tables b) Dimension tables c) Time columns d) Transaction identifiers

b) Dimension tables

Which of the following is typically found in the database metadata? a) Data types b) Product prices c) Employee names d) Student ages

a) Data types

Every relation contains: a) Full key functional dependency b) Partial functional dependency c) Transitive functional dependency d) All of the above

a) Full key functional dependency

OLAP tools are: a) Write-only tools b) Read-only tools c) Read and write tools d) Read, write, and delete tools

b) Read-only tools

An associative entity is used as an alternative way of depicting: a) 1:M relationships b) 1:1 relationships c) M:N relationships d) Multivalued attributes

c) M:N relationships

Data time-horizon is: a) Typically longer in operational systems than in analytical systems b) Typically equal in operational systems and in analytical systems c) Typically shorter in operational systems than in analytical systems d) Typically nonexistent in operational systems and in analytical systems

c) Typically shorter in operational systems than in analytical systems

Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in: a) A new relation b) Two foreign keys c) A composite primary key d) A foreign key in both of the relations mapped from the involved entities

d) A foreign key in both of the relations mapped from the involved entities

DBMS is software used for the following purpose: a) Creation of databases b) Maintenance of databases c) Insertion, storage, retrieval, update, and deletion of data in the database d) All of the above

d) All of the above

"If a 1:M relationship is optional on the 1 side and mandatory on the M side, which of the following is true?" a) The resulting foreign key can have null (empty) values b) The resulting foreign key cannot have null (empty) values c) The resulting foreign key must have null (empty) values d) No foreign key is created as a result of mapping such a relationship

a) The resulting foreign key can have null (empty) values

If A --> B is an existing functional dependency, which of the following is an augmented functional dependency? a) A, B --> C b) A, C --> B c) A --> C d) B --> A

b) A, C --> B

Joe is an example of: a) Metadata b) Data type c) DMBS d) Data

d) Data

FirstName is an example of: a) DBMS b) Data c) Data type d) Metadata

d) Metadata

Relation is a synonym for: a) Column b) Field c) Row d) Table

d) Table

A data mart is a data store based on the same principles as a data warehouse but with a wider scope. T/F

FALSE

A dimensional model cannot be based on a single source. T/F

FALSE

A foreign key column must have the same name as the primary key column it refers to. T/F

FALSE

A relationship of degree 3 (also known as a ternary relationship) depicts 3 or more entities involved in one relationship. T/F

FALSE

A row of a relation can have in its column two values from the column's domain. T/F

FALSE

Analytical information is based on operational information. T/F

TRUE

Conceptual data modeling is another term for requirements visualization. T/F

TRUE

Creating a data warehouse involves using the functionalities of database management software to implement the data warehouse model as a collection of physically created and mutually connected database tables. T/F

TRUE

Data warehouse front-end applications are often referred to as business intelligence (BI) applications. T/F

TRUE

Database administration encompasses the tasks related to the maintenance and supervision of a database system. T/F

TRUE

Dimensional modeling can be employed as a relational data modeling technique. T/F

TRUE

The description of the structure and the properties of the data fits into which category? a) Information b) Metadata c) Data d) DBMS

b) Metadata

"A weak entity that has a 1:1 identifying relationship with its owner, must have a partial key." T/F

FALSE

"During a proper requirements collection process, the requirements can be added iteratively and implicitly." T/F

FALSE

A DBMS is a presentation software (such as MS Power Point). T/F

FALSE

All sources for a dimensional model must be operational data sources from the company that is building the dimensional model. T/F

FALSE

Analytical databases are referred to as application-oriented. T/F

FALSE

Analytical databases collect and present operational information in support of daily operational procedures and processes. T/F

FALSE

Archived data from source systems is never present in the data warehouse. T/F

FALSE

DCL commands are used to manage database transactions. T/F

FALSE

Data marts are always implemented as relational databases. T/F

FALSE

Each weak entity has one owner entity. T/F

FALSE

"In an ER diagram, each entity is always connected to all of the other entities, either via a direct relationship or indirectly via other entities and relationships." T/F

TRUE

"Operational data typically represents the current state of affairs in the real world, while analytical data can represent both the current situation and snapshots from the past." T/F

TRUE

A DBMS can be used for creation of databases. T/F

TRUE

A DBMS can be used for insertion and retrieval of the data in the database. T/F

TRUE

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis. T/F

TRUE

A dimensional model can contain more than one fact table. T/F

TRUE

"If a 1:M relationship is optional on both sides, and if the table resulting from the 1 side has 3 records, then the table resulting from the M side CANNOT have less than ________ records." a) 0 b) 1 c) 2 d) 3

a) 0

Which of the following is a part of a DML statement? a) SELECT b) CREATE c) DROP d) ALTER

a) SELECT

"If a 1:M relationship is optional on both sides, which of the following is true?" a) The resulting foreign key can have null (empty) values b) The resulting foreign key cannot have null (empty) values c) The resulting foreign key must have null (empty) values d) No foreign key is created as a result of mapping such a relationship

a) The resulting foreign key can have null (empty) values

The ________ slowly changing dimension approach changes the old value in the dimension's record with the new value. a) Type 1 b) Type 2 c) Type 3 d) Type 0

a) Type 1

"If an entity has three unique attributes, how many primary keys will its mapped relation have?" a) 0 b) 1 c) 2 d) 3

b) 1

How many entities are involved in a binary relationship? a) 1 b) 2 c) More than 2 d) Between 1 and 2

b) 2

If A --> B and B --> A are existing functional dependencies, which of the following are NOT equivalent functional dependencies? a) A --> B and B --> A b) A --> B, X and B --> A, X c) X --> A and A --> B d) X, A --> B, X and X, B --> A, X

c) X --> A and A --> B

"If a 1:M relationship is mandatory on both sides, and if the table resulting from the 1 side has 3 records, then the table resulting from the M side CANNOT have less than ________ records." a) 0 b) 1 c) 2 d) 3

d) 3

Which of the following is a format in which data can appear? a) Image b) Text c) Numbers d) All of the above

d) All of the above

Which of the following is a part of the database requirements step? a) Database implementation b) Logical modeling c) Database deployment d) Conceptual modeling

d) Conceptual modeling

Including a transaction identifier in the fact table is often referred to as: a) Aggregated fact table b) Snowflaking c) Galaxy of stars d) Degenerate dimension

d) Degenerate dimension

The values of the following attribute are NOT permanently stored in a database. a) Unique attribute b) Composite attribute c) Multivalued attribute d) Derived attribute

d) Derived attribute

Implicit changes of requirements are permitted during: a) Database deployment b) Logical modeling c) Database use d) Implicit changes of requirements are not permitted

d) Implicit changes of requirements are not permitted

Every normalized database is eventually denormalized. T/F

FALSE

The purpose of the drill down operation is to make the granularity of the data in the query result finer. T/F

TRUE

The purpose of the drill up operation is to make the granularity of the data in the query result coarser. T/F

TRUE

The relation resulting from mapping a weak entity (with a 1:M identifying relationship) has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity. T/F

TRUE

How many entities are involved in a unary relationship? a) 1 b) 2 c) More than 2 d) Between 1 and 2

a) 1

Querying and presenting data from data warehouses and/or data marts for analytical purposes is known as: a) ETL b) OLAP c) OLTP d) Micro batches

b) OLAP

OLAP/BI tools can be used for: a) Ad-hoc direct analysis only b) Creation of front-end (BI) applications only c) Ad-hoc direct analysis and creation of front-end (BI) applications d) Neither ad-hoc direct analysis nor creation of front-end (BI) applications

c) Ad-hoc direct analysis and creation of front-end (BI) applications

"Increasing the speed of a single query is always a priority, even if it requires slowing down the majority of other queries." T/F

FALSE

"Information that is collected in database systems can be used, in general, for two purposes: an operational purpose and a transactional purpose." T/F

FALSE

"Summarized operational data is typically physically stored, while summarized analytical data is typically derived (calculated) rather than physically stored." T/F

FALSE

Every relation without partial functional dependencies is in 3NF. T/F

FALSE

Front-end applications are created in order to provide a mechanism for easy interaction between the database and the DBMS. T/F

FALSE

The term data refers to facts that are recorded and can be accessed. T/F

TRUE

Which of the following is NOT a possible cardinality constraint? a) Optional one b) Optional zero c) Optional many d) Mandatory one

b) Optional zero

"Updating, querying, and presenting data from databases for operational purposes is known as:" a) ETL b) OLAP c) OLTP d) Micro batches

c) OLTP

Minimum cardinality can be: a) One or many b) Zero or many c) Optional or mandatory d) Optional or many

c) Optional or mandatory

Data cleansing is a part of: a) OLAP b) Extraction c) Transformation d) Load

c) Transformation

Which of the following is NOT a part of the data warehouse requirements step? a) Requirements collection b) Requirements definition c) Conceptual modeling d) Logical modeling

d) Logical modeling

Which of the following is NOT true? In a relational database: a) Two tables can be a part of the same database b) Two tables can have the same number of columns c) Two tables can have the same number of rows d) Two tables can have the same names

d) Two tables can have the same names

If A, B, C, and D are columns of the table whose composite primary key is A, B while C and D are non-key columns then B --> D is a transitive functional dependency. T/F

FALSE

Indirect interaction requires that the end user knows how to issue commands to the specific DBMS. T/F

FALSE

It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes. T/F

FALSE

Metadata is a subset of data that is most recently entered. T/F

FALSE

The word online in the term OLAP refers to the use of the Internet or other networks. T/F

FALSE

Two columns of a relational table can have the same names. T/F

FALSE

The new version of a database is created following the same development steps as the initial version. T/F

TRUE

The term information refers to the data that is accessed by a user for some particular purpose. T/F

TRUE

The term operational information refers to the information collected and used in support of day-to-day operational needs. T/F

TRUE

Two columns of a relational table can have the same values. T/F

TRUE

Two entities can be related via multiple different binary relationships. T/F

TRUE

Which of the following statements would be used to drop a column from the table? a) ALTER TABLE b) CREATE TABLE c) DROP TABLE d) UPDATE

a) ALTER TABLE

Front-end applications facilitate: a) Indirect use b) Direct use c) Both d) Neither

a) Indirect use

Which of the following is a database use action? a) Modifying data b) Securing data c) Storing data d) Modeling data

a) Modifying data

Operational queries are typically issued: a) More often than analytical queries b) Less often than analytical queries c) Equally as often as analytical queries d) Never in a corporation that has users issuing analytical queries

a) More often than analytical queries

"In a typical, properly designed star schema, the number of records (rows) in any of the dimension tables is:" a) Larger than in the fact table b) Same as in the fact table c) Smaller than in the fact table d) No typical rule there is an even number of dimension tables with larger, smaller and same number of records as in the fact table

c) Smaller than in the fact table

What is the result of the following SQL statement? UPDATE employee SET salary = 50000 WHERE salary < 50000; a) The statement sets the salary for each employee to below 50,000 b) The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000 c) The statement increases salary to 50,000 for each employee whose salary is below 50,000 d) The statement sets the salary of each employee to 50,000

c) The statement increases salary to 50,000 for each employee whose salary is below 50,000

End users can vary in: a) Their level of technical sophistication b) The amount of data they need c) The frequency with which they access the database system d) All of the above

d) All of the above

Requirements can be refined and/or expanded following: a) Database use b) Logical modeling c) Database deployment d) All of the above

d) All of the above

Which of the following is a component of a database system? a) DBMS b) Database c) Front-end applications d) All of the above

d) All of the above

"If one of two identical relational tables has the last column moved to the first place, those two relational tables are no longer identical." T/F

FALSE

"In contrast to a narrow constituency of operational data, analytical data is used by a widespread set of users." T/F

FALSE

Databases of different scope are developed following different fundamental development steps. T/F

FALSE

Every 3NF database can be further streamlined by including designer-added tables and keys. T/F

FALSE

Operational databases are referred to as subject-oriented. T/F

FALSE

The logical database model is created prior to the conceptual database model. T/F

FALSE

The operational data sources include the data warehouses and data marts. T/F

FALSE

The process of transformation cannot involve standardizing different versions of the same data present in different data sources. T/F

FALSE

The relational model is the only way through which dimensionally modeled databases can be implemented. T/F

FALSE

The terms data and information should never be used as synonyms for each other. T/F

FALSE

A query retrieving the data from one relation can be used to populate another relation. T/F

TRUE

A relational schema is a visual depiction of the relational database model. T/F

TRUE

A typical organization maintains and utilizes a number of operational data sources. T/F

TRUE

A unary relationship can have one or many maximum cardinalities on either side. T/F

TRUE

A weak entity that has a 1:M identifying relationship with its owner must have a partial key. T/F

TRUE

An entity and its 1:M unary relationship are mapped as one relation. T/F

TRUE

ETL infrastructure has to account for and reconcile all of the differences in the metadata and the data between the operational sources and the target data warehouses. T/F

TRUE

Each instance of a weak entity must participate in one instance of the identifying relationship. T/F

TRUE

Which of the following is a part of a DDL statement? a) CREATE b) INSERT c) DELETE d) SELECT

a) CREATE

The type of interaction between the end user and the database that involves front-end applications is called direct interaction. T/F

FALSE

Which of the following best describes a business model? a) Typically a graphical depiction of the essential business process information. b) A sequence of business activities. c) An evaluation of potential business process improvements. d) None of the above.

a) Typically a graphical depiction of the essential business process information.

Maximum cardinality can be: a) One or many b) Zero or many c) Optional or mandatory d) Optional or many

a) One or many

"If a 1:M relationship is optional on the M side and mandatory on the 1 side, and if the table resulting from the 1 side has 3 records, then the table resulting from the M side CANNOT have less than ________ records." a) 0 b) 1 c) 2 d) 3

a) 0

"If an M:N relationship is optional on both sides, 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 ________ records." a) 0 b) 1 c) 3 d) 9

a) 0

Attribute B of Entity X is a: a) Composite attribute b) Multivalued attribute c) Derived attribute d) Unique composite attribute

a) Composite attribute

The difference in the scope of databases is reflected in the: a) Cost in time and resources required for each of the development steps b) Number of the development steps c) Level of importance of each of the development steps d) Order of the development steps

a) Cost in time and resources required for each of the development steps

A regular entity must have at least one of the following attributes: a) Unique attribute b) Composite attribute c) Multivalued attribute d) Derived attribute

a) Unique attribute

What is the result of the following SQL query? SELECT ename FROM employee WHERE esalary = (SELECT MAX(salary) FROM employee); a) The query displays the number that represents how many employees share the highest salary b) The query displays the salary of the employee (or employees) with the highest salary c) The query displays the name and the salary of the employee (or employees) with the highest salary d) The query displays the name of the employee (or employees) with the highest salary

d) The query displays the name of the employee (or employees) with the highest salary

Operational queries are typically issued: a) By fewer users than analytical queries b) By more users than analytical queries c) By an equal number of users as analytical queries d) By no users if the corporation has users issuing analytical queries

b) By more users than analytical queries

"When a data warehouse is normalized, its dependent data marts also must be normalized." T/F

FALSE

Which of the following allows reusing (instead of duplication) of dimensions? a) Time column b) Snowflaking c) Galaxy of stars d) Degenerate dimension

c) Galaxy of stars

The following attribute can contain more than one value for each entity instance. a) Unique attribute b) Composite attribute c) Multivalued attribute d) Derived attribute

c) Multivalued attribute

Which of the following is a modify operation? a) Entering new data in the relation b) Retrieving data from the relation c) Removing the data from the relation d) Changing the existing data in the relation

d) Changing the existing data in the relation

"In the case of so-called active data warehouses, the loads occur in ________ that happen continuously, ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data)." a) Dimensional modeling actions b) OLAP actions c) OLTP actions d) Micro batches

d) Micro batches

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) UPDATE

d) UPDATE

Which of the following is an invalid SQL keyword? a) Select b) SE_LECT c) selecT d) SeLeCt

b) SE_LECT

Information can be used for: a) Operational purposes only b) Analytical purposes only c) Both d) Neither

c) Both

Which of the following is an example of a daily operational procedure or task supported by an operational database? a) Deducting the correct amount of money from a customer's checking account upon an ATM withdrawal b) Issuing a correct bill to a customer who purchased an airline ticket c) Both d) Neither

c) Both

If A, B, C, and D are columns of the table whose composite primary key is A, B while C and D are non-key columns then C --> D is a transitive functional dependency. T/F

TRUE

Normalized data warehouse approach can be used for designing an enterprise-wide analytical data warehouse. T/F

TRUE

An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a: a) Weak entity with two owners b) Multivalued composite attribute c) Unary M:N relationship d) Weak entity with one owner

a) Weak entity with two owners

Which of the following requires that the end user knows how to issue commands to the specific DBMS? a) Indirect interaction b) Direct interaction c) Both d) Neither

b) Direct interaction

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, all other columns from the table employee, and the number 1.1 b) For each employee, the query will display the name and the salary increased by 10% 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, and all other columns from the table employee

b) For each employee, the query will display the name and the salary increased by 10%

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

b) Identifying relationship

How many columns will a relation resulting from mapping the Entity X have? a) 2 b) 3 c) 4 d) 5

c) 4

Independent data marts approach results in multiple unrelated ETL infrastructures. T/F

TRUE

"How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms." a) 3 b) 4 c) 115 d) 116

a) 3

Which of the following is an example of analytical information? a) Information about the amount of money in a checking account b) Information showing which airline routes in the United States have the most sales c) Information about the cost of a product d) Information showing the destination and origin of a particular airline route in the United States

b) Information showing which airline routes in the United States have the most sales

________ are in charge of implementing the database model as a functioning database using the DBMS software. a) Database analysts b) Database architects c) Database developers d) DBAs

c) Database developers

Which of the following is a possible type of relationship (maximum cardinality-wise)? a) One-to-one b) Zero-to-zero c) Zero-to-one d) Zero-to-many

a) One-to-one

Operational queries typically process: a) Larger amounts of data than analytical queries b) Smaller amounts of data than analytical queries c) Equal amounts of data as analytical queries d) Infinite amounts of data, incomparable to analytical queries

b) Smaller amounts of data than analytical queries

"If a 1:M relationship is mandatory on both sides, which of the following is true?" a) The resulting foreign key can have null (empty) values b) The resulting foreign key cannot have null (empty) values c) The resulting foreign key must have null (empty) values d) No foreign key is created as a result of mapping such a relationship

b) The resulting foreign key cannot have null (empty) values

Which of the following processes is typically the most time- and resource-consuming? a) Creating the data warehouse tables using the DBMS functionalities b) Creating the OLAP query c) Creating the ETL infrastructure d) Creating the data warehouse model

c) Creating the ETL infrastructure

Which of the following is NOT true? In a relational table: a) Two columns can have the same values b) All column names are different c) Two rows can have the same values d) All values in a column are from the same domain

c) Two rows can have the same values

The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated. a) Type 1 b) Type 2 c) Type 3 d) Type 0

c) Type 3