CIS 2109 Final Review

One of the most popular RAD methods is:
Prototyping.
The traditional methodology used to develop, maintain and replace information systems is called the:
Systems Development Life Cycle.
Data that describe the properties of other data are:
Metadata.
(True or False) An intranet utilizes Web-based technology to improve communication with parties outside of the organization.
False
A graphical system used to capture the nature and relationships among data is called a(n):
data model.
(True or False) A modern database management system automates more of the backup and recovery tasks than a file system.
True
________ are established between entities in a well-structured database so that the desired information can be retrieved.
Relationships
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
A workgroup database is stored on a central device called a(n):
server.
(True or False) A data warehouse contains summarized and historical information.
True
A user view is:
a logical description of some portion of the database.
CASE is a class of tools that:
automates the design of databases and application programs.
(True or False) A data model is a graphical system used to capture the nature and relationships among data.
True
(True or False) Cost and complexity are just two of the disadvantages of database processing.
True
All of the following are properties of metadata EXCEPT:
processing logic.
(True or False) Although personal databases improve productivity, one risk is that data cannot be shared with other users.
True
(True or False) A physical schema contains the specifications for how data from a conceptual schema are stored in a computer’s secondary memory.
True
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
RAD.
(True or False) An extranet uses Internet protocols to establish limited access to company data by the company’s customers and suppliers.
True
(True or False) Information is processed data.
True
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
relation.
A rule that CANNOT be violated by database users is called a:
constraint.
A data warehouse derives its data from:
various operational data sources.
(True or False) The term legacy system refers to a newly installed database management system.
False
(True or False) A constraint is a rule in a database system that can be violated by users.
False
(True or False) An enterprise data model describes the scope of data for only one information system.
False
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
entity.
The three-schema approach includes:
Internal, conceptual, and external.
(True or False) A relational database establishes the relationships between entities by means of a common field.
True
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
repository.
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
(True or False) SQL has been implemented only in the mainframe and midrange environments.
False
(True or False) A database is maintained and queried using the data mapping language (DML).
False
(True or False) A major benefit of SQL as a standard is reduced training costs.
True
Any create command may be reversed by using a ________ command.
drop
(True or False) One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.
True
(True or False) DCL is used to update the database with new records.
False
(True or False) A database table is defined using the data definition language (DDL).
True
(True or False) When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.
True
Which of the following questions is answered by the SQL statement?

Select Count (Product_Description) from Product_T;

How many products have product descriptions in the Product Table?
Which of the following is true of the order in which SQL statements are evaluated?
The SELECT clause is processed before the ORDER BY clause.
Which of the following is a technique for optimizing the internal performance of the relational data model?
Clustering data
(True or False) When creating a table, it is not important to consider foreign key primary key mates.
False
What three clauses are contained in most SQL retrieval statements?
The SELECT clause, which lists the columns and calculated expression from base tables. The FROM clause, which identifies tables and views which we want to gather data from in the query. Finally, the WHERE clause, which is used to specify conditions for selection of rows in the result set.
________ is a set of commands used to control a database, which includes security.
DCL
Which of the following finds all groups meeting stated conditions?
Having
When creating tables, it’s important to decide which columns will allow null values before the table is created.
True
Which of the following is the wildcard operator in SQL statements?
*
What steps should be followed when preparing to create a table?
When preparing to create a table, one should:
1. Identify the appropriate data type and length for each attribute
2. Identify the columns that should accept null values
3. Identify that columns that need to be unique
4. Identify all primary-foreign key mates
5. Determine default values
6. Identify any columns for which domain constraints, such as check, need to be stated
7. Create the table and any indexes using create table and create index statements
Which of the following will produce the minimum of all standard prices?
Select min(standard_price) from Product_V;
________ is a set of commands used to update and query a database.
DML
(True or False) Adding the DISTINCT keyword to a query eliminates duplicates.
True
(True or False) The ALTER TABLE command is used to change a table definition.
True
(True or False) The DROP command deletes rows from a table individually or in groups.
False
(True or False) A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.
False
In an SQL statement, which of the following parts states the conditions for row selection?
Where
(True or False) The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.
True
The HAVING clause and the WHERE clause perform the same operation.
False
Multiple values returned from an SQL query that includes an aggregate function are called:
vector aggregates.
A single value returned from an SQL query that includes an aggregate function is called a(n):
scalar aggregate.
A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):
natural join.
(True or False) An equi-join is a join in which one of the duplicate columns is eliminated in the result table.
False
(True or False) A join in which the joining condition is based on equality between values in the common column is called a(n) equi-join.
True
A join in which the joining condition is based on equality between values in the common columns is called a(n):
both equi-join and natural 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):
outer join.
A type of join where a table is joined to itself is called a(n):
self-join.
(True or False) An SQL query that implements an outer join will return rows that do not have matching values in common columns.
True
(True or False) A natural join is the same as an equi-join, except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated.
True
A type of query that is placed within a WHERE or HAVING clause of another query is called a:
subquery.
The UNION clause is used to:
combine the output from multiple queries into a single result table.
A join in which the joining condition is based on equality between values in the common columns is called a(n):
both equi-join and natural join.
(True or False) Joining tables or using a subquery may produce the same result.
True
(True or False) In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.
True
SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.
subquery
One major advantage of the outer join is that:
information is not lost.
(True or False) A catalog is the structure that contains object descriptions created by a user.
False
(True or False) A database is maintained and queried using the data mapping language (DML).
False
A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship.
ternary
A fact is an association between two or more:
terms.
(True or False) A time stamp is a time value that is associated with a data value.
True
(True or False) A simple attribute can be broken down into smaller pieces.
False
(True or False) A fact is an association between two or more terms.
True
An attribute that can be broken down into smaller parts is called a(n) ________ attribute.
composite
A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.
cardinality constraint
An attribute of an entity that must have a value for each entity instance is a(n):
required attribute.
(True or False) A business rule is a statement that defines or constrains some aspect of the business.
True
A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.
mandatory one
(True or False) A business rule is a statement of how a policy is enforced or conducted.
False
(True or False) A single occurrence of an entity is called an entity instance.
True
A person’s name, birthday, and social security number are all examples of:
attributes.
A relationship between the instances of a single entity type is called a(n) ________ relationship.
unary
A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.
many-to-many
A time stamp is a time value that is associated with a data value.
True
The logical representation of an organization’s data is called a(n):
entity-relationship model.
(True or False) It is not permissible to associate attributes with relationships.
False
(True or False) The degree of a relationship is the number of attributes that are associated with it.
False
(True or False) A ternary relationship is equivalent to three binary relationships.
False
For the relationship represented in the figure below, which of the following is true?
A department can have more than one employee.
An entity type whose existence depends on another entity type is called a ________ entity.
weak
An entity type name should be all of the following EXCEPT:
as short as possible.
The common types of entities are:
Strong, Weak, and Associative.
(True or False) It is desirable that no two attributes across all entity types have the same name.
True
(True or False) Data modeling is about documenting rules and policies of an organization that govern data.
True
Data modeling may be the most important part of the systems development process because:
data characteristics are important in the design of programs and other systems components.
Customers, cars, and parts are examples of:
entities.
Which of the following is a generic entity type that has a relationship with one or more subtypes?
Supertype
(True or False) A member of a subtype does NOT necessarily have to be a member of the supertype.
False
(True or False) A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project.
True
(True or False) An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.
True
(True or False) Specialization is the reverse of generalization.
True
A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.
completeness
(True or False) Generalization is a top-down process.
False
(True or False) In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.
True
An entity cluster can be formed by:
– Abstracting a supertype and its subtype.
– Combining directly related entity types and their relationships.
– Combining a strong entity and its weak entities.
A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.
disjointedness constraint
(True or False) A subtype can become a supertype if the subtype has other subtypes beneath it.
True
(True or False) EXISTS takes a value of false if the subquery returns an intermediate result set.
False
A join operation:
causes two tables with a common domain to be combined into a single table or view.
(True or False) A function has only input parameters but can return multiple values.
False
A ________ is a temporary table used in the FROM clause of an SQL query.
derived table
The MERGE command:
allows one to combine the INSERT and UPDATE operations.
(True or False) Joining tables or using a subquery may produce the same result.
True
(True or False) In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.
True
(True or False) A correlated subquery is executed once for each iteration through the outer loop.
True
A two-dimensional table of data sometimes is called a:
relation.
A domain definition consists of the following components EXCEPT:
integrity constraints.
An alternative name for an attribute is called a(n):
alias.
(True or False) Data structures include data organized in the form of tables with rows and columns.
True
(True or False) A foreign key is a primary key of a relation that also is a primary key in another relation.
False
All of the following are the main goals of normalization EXCEPT:
maximize storage space.