Exam 2 SQL

Transitive Dependency

A functional dependency between two or more nonkey attributes is called a:

Partial Functional

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency

Outer-Join

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

True

A join in which the joining condition is based on equality between values in the common column is called a(n) equi-join.

Equi-Join and Natural Join

A join in which the joining condition is based on equality between values in the common columns is called

Triggers

A named set of SQL statements that are considered when a data modification occurs are called:

Composite Key

A primary key that consists of more than one attribute is called a:

2NF

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

Referential Integrity Constraint

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Relation

A two-dimensional table of data is called a:

Self-Join

A type of join where a table is joined to itself is called a(n):

Subquery

A type of query that is placed within a WHERE or HAVING clause of another query is called a:

True

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Primary Key

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Foreign Key

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Is Not

Analyzing past financial performance and reporting _______ a factor of internal environment according to the COSO Enterprise Risk Management Framework.

Preventative

Approving customer credit prior to approving a sales order is an example of a _______ control

Benefits of XBRL

Both are _________ of ________: -Organizations can publish financial information only once, using standard XBRL tags -Tagged data is readable and interpretable by computers, so users don't need re-enter data into order to work with it

Join Operation

Causes two tables with a common domain to be combined into a single table or view

SOX 2002

Congress passed this federal law for the purpose of preventing financial statement fraud, to make financial reports more transparent and to strengthen the internal control of public companies

Physical Design

DDL is typically used during which phases of the development process?

Detective; Corrective

Duplicate checking of calculations is an example of a ________ control, and procedures to resubmit rejected transactions is an example of a ________ control

Shared

FranticHouse Partners, L.L.C., does home remodeling and repair. All employees are bonded, so the firm's risk exposure to employee fraud is

Where

In an SQL statement, which part states the conditions for row selection?

Process

Internal control is often referred to as a(n) ________, because it permeates an organization's operating activities and is an integral part of management activities

the same

One of the objectives of the segregation of duties is to make sure that different people handle different parts of ______ transaction

Internal Environment

The SEC and FASB are best described as external influences that directly affect an organization's

Before

The SELECT clause is processed ____ the ORDER BY clause

False

The natural join is very rarely used

Residual Risk

The risk that remains after management implements internal controls is

COSO ERM framework

This control framework's intent includes helping the organization to provide reasonable assurance that objectives are achieved and problems are minimized, and to avoid adverse publicity and damage to the organization's reputation

Distinct

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command

True

Triggers have three parts: the event, the condition, and the action

Many companies do not realize that data security is crucial to their survival

What is one reason why AIS threats are increasing?

1NF

When all multivalued attributes have been removed from a relation, it is said to be in:

All anomalies

Which of the following anomalies result from a transitive dependency?

Insertion, Deletion, and Modification

Which of the following are anomalies that can be caused by redundancies in tables?

Having

Which of the following finds all groups meeting stated conditions?

All of Above

Which of the following is a purpose of the SQL standard? -To specify syntax and semantics of SQL data definition and manipulation -To specify minimal and complete standards, which permit different degrees of adoption in products -To define the data structures and basic operations for SQL databases -All of the above

Indexes

______ are created in most RDBMSs to provide rapid random and sequential access to base-table data

DML

_______ is a set of commands used to update and query a database

Correlated Subqueries

________ use the result of the outer query to determine the processing of the inner query