CIS 2109 Final Review – Flashcards

Unlock all answers in this set

Unlock answers
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.
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New