question

One of the most popular RAD methods is:

answer

Prototyping.

question

The traditional methodology used to develop, maintain and replace information systems is called the:

answer

Systems Development Life Cycle.

question

Data that describe the properties of other data are:

answer

Metadata.

question

(True or False) An intranet utilizes Web-based technology to improve communication with parties outside of the organization.

answer

False

question

A graphical system used to capture the nature and relationships among data is called a(n):

answer

data model.

question

(True or False) A modern database management system automates more of the backup and recovery tasks than a file system.

answer

True

question

________ are established between entities in a well-structured database so that the desired information can be retrieved.

answer

Relationships

question

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

answer

user view

question

A workgroup database is stored on a central device called a(n):

answer

server.

question

(True or False) A data warehouse contains summarized and historical information.

answer

True

question

A user view is:

answer

a logical description of some portion of the database.

question

CASE is a class of tools that:

answer

automates the design of databases and application programs.

question

(True or False) A data model is a graphical system used to capture the nature and relationships among data.

answer

True

question

(True or False) Cost and complexity are just two of the disadvantages of database processing.

answer

True

question

All of the following are properties of metadata EXCEPT:

answer

processing logic.

question

(True or False) Although personal databases improve productivity, one risk is that data cannot be shared with other users.

answer

True

question

(True or False) A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

answer

True

question

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

answer

RAD.

question

(True or False) An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.

answer

True

question

(True or False) Information is processed data.

answer

True

question

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

answer

relation.

question

A rule that CANNOT be violated by database users is called a:

answer

constraint.

question

A data warehouse derives its data from:

answer

various operational data sources.

question

(True or False) The term legacy system refers to a newly installed database management system.

answer

False

question

(True or False) A constraint is a rule in a database system that can be violated by users.

answer

False

question

(True or False) An enterprise data model describes the scope of data for only one information system.

answer

False

question

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):

answer

entity.

question

The three-schema approach includes:

answer

Internal, conceptual, and external.

question

(True or False) A relational database establishes the relationships between entities by means of a common field.

answer

True

question

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

answer

repository.

question

Because applications are often developed independently in file processing systems:

answer

unplanned duplicate data files are the rule rather than the exception.

question

(True or False) SQL has been implemented only in the mainframe and midrange environments.

answer

False

question

(True or False) A database is maintained and queried using the data mapping language (DML).

answer

False

question

(True or False) A major benefit of SQL as a standard is reduced training costs.

answer

True

question

Any create command may be reversed by using a ________ command.

answer

drop

question

(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.

answer

True

question

(True or False) DCL is used to update the database with new records.

answer

False

question

(True or False) A database table is defined using the data definition language (DDL).

answer

True

question

(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.

answer

True

question

Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;

answer

How many products have product descriptions in the Product Table?

question

Which of the following is true of the order in which SQL statements are evaluated?

answer

The SELECT clause is processed before the ORDER BY clause.

question

Which of the following is a technique for optimizing the internal performance of the relational data model?

answer

Clustering data

question

(True or False) When creating a table, it is not important to consider foreign key primary key mates.

answer

False

question

What three clauses are contained in most SQL retrieval statements?

answer

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.

question

________ is a set of commands used to control a database, which includes security.

answer

DCL

question

Which of the following finds all groups meeting stated conditions?

answer

Having

question

When creating tables, it's important to decide which columns will allow null values before the table is created.

answer

True

question

Which of the following is the wildcard operator in SQL statements?

answer

*

question

What steps should be followed when preparing to create a table?

answer

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

question

Which of the following will produce the minimum of all standard prices?

answer

Select min(standard_price) from Product_V;

question

________ is a set of commands used to update and query a database.

answer

DML

question

(True or False) Adding the DISTINCT keyword to a query eliminates duplicates.

answer

True

question

(True or False) The ALTER TABLE command is used to change a table definition.

answer

True

question

(True or False) The DROP command deletes rows from a table individually or in groups.

answer

False

question

(True or False) A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

answer

False

question

In an SQL statement, which of the following parts states the conditions for row selection?

answer

Where

question

(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.

answer

True

question

The HAVING clause and the WHERE clause perform the same operation.

answer

False

question

Multiple values returned from an SQL query that includes an aggregate function are called:

answer

vector aggregates.

question

A single value returned from an SQL query that includes an aggregate function is called a(n):

answer

scalar aggregate.

question

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

answer

natural join.

question

(True or False) An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

answer

False

question

(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.

answer

True

question

A join in which the joining condition is based on equality between values in the common columns is called a(n):

answer

both equi-join and natural join.

question

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

answer

outer join.

question

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

answer

self-join.

question

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

answer

True

question

(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.

answer

True

question

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

answer

subquery.

question

The UNION clause is used to:

answer

combine the output from multiple queries into a single result table.

question

A join in which the joining condition is based on equality between values in the common columns is called a(n):

answer

both equi-join and natural join.

question

(True or False) Joining tables or using a subquery may produce the same result.

answer

True

question

(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.

answer

True

question

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

answer

subquery

question

One major advantage of the outer join is that:

answer

information is not lost.

question

(True or False) A catalog is the structure that contains object descriptions created by a user.

answer

False

question

(True or False) A database is maintained and queried using the data mapping language (DML).

answer

False

question

A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship.

answer

ternary

question

A fact is an association between two or more:

answer

terms.

question

(True or False) A time stamp is a time value that is associated with a data value.

answer

True

question

(True or False) A simple attribute can be broken down into smaller pieces.

answer

False

question

(True or False) A fact is an association between two or more terms.

answer

True

question

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

answer

composite

question

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

answer

cardinality constraint

question

An attribute of an entity that must have a value for each entity instance is a(n):

answer

required attribute.

question

(True or False) A business rule is a statement that defines or constrains some aspect of the business.

answer

True

question

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

answer

mandatory one

question

(True or False) A business rule is a statement of how a policy is enforced or conducted.

answer

False

question

(True or False) A single occurrence of an entity is called an entity instance.

answer

True

question

A person's name, birthday, and social security number are all examples of:

answer

attributes.

question

A relationship between the instances of a single entity type is called a(n) ________ relationship.

answer

unary

question

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.

answer

many-to-many

question

A time stamp is a time value that is associated with a data value.

answer

True

question

The logical representation of an organization's data is called a(n):

answer

entity-relationship model.

question

(True or False) It is not permissible to associate attributes with relationships.

answer

False

question

(True or False) The degree of a relationship is the number of attributes that are associated with it.

answer

False

question

(True or False) A ternary relationship is equivalent to three binary relationships.

answer

False

question

For the relationship represented in the figure below, which of the following is true?

answer

A department can have more than one employee.

question

An entity type whose existence depends on another entity type is called a ________ entity.

answer

weak

question

An entity type name should be all of the following EXCEPT:

answer

as short as possible.

question

The common types of entities are:

answer

Strong, Weak, and Associative.

question

(True or False) It is desirable that no two attributes across all entity types have the same name.

answer

True

question

(True or False) Data modeling is about documenting rules and policies of an organization that govern data.

answer

True

question

Data modeling may be the most important part of the systems development process because:

answer

data characteristics are important in the design of programs and other systems components.

question

Customers, cars, and parts are examples of:

answer

entities.

question

Which of the following is a generic entity type that has a relationship with one or more subtypes?

answer

Supertype

question

(True or False) A member of a subtype does NOT necessarily have to be a member of the supertype.

answer

False

question

(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.

answer

True

question

(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.

answer

True

question

(True or False) Specialization is the reverse of generalization.

answer

True

question

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.

answer

completeness

question

(True or False) Generalization is a top-down process.

answer

False

question

(True or False) In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.

answer

True

question

An entity cluster can be formed by:

answer

- Abstracting a supertype and its subtype. - Combining directly related entity types and their relationships. - Combining a strong entity and its weak entities.

question

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

answer

disjointedness constraint

question

(True or False) A subtype can become a supertype if the subtype has other subtypes beneath it.

answer

True

question

(True or False) EXISTS takes a value of false if the subquery returns an intermediate result set.

answer

False

question

A join operation:

answer

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

question

(True or False) A function has only input parameters but can return multiple values.

answer

False

question

A ________ is a temporary table used in the FROM clause of an SQL query.

answer

derived table

question

The MERGE command:

answer

allows one to combine the INSERT and UPDATE operations.

question

(True or False) Joining tables or using a subquery may produce the same result.

answer

True

question

(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.

answer

True

question

(True or False) A correlated subquery is executed once for each iteration through the outer loop.

answer

True

question

A two-dimensional table of data sometimes is called a:

answer

relation.

question

A domain definition consists of the following components EXCEPT:

answer

integrity constraints.

question

An alternative name for an attribute is called a(n):

answer

alias.

question

(True or False) Data structures include data organized in the form of tables with rows and columns.

answer

True

question

(True or False) A foreign key is a primary key of a relation that also is a primary key in another relation.

answer

False

question

All of the following are the main goals of normalization EXCEPT:

answer

maximize storage space.

CIS 2109 Final Review – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards