ISM 4210 Exam 2

Which is the wildcard operator in SQL statements

*

______is the process of assigning pieces of application code to clients or servers

Application partitioning

When identifying the parts of the packaged data model that apply to your organization, one should first start with

entities

Advantages of stored procedures

1) Thinner client 2) Performance improves for compiled SQL statements 3) Network traffic decreases

E.F. Codd developed the relational model in the

1970s

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

A Join Operation

What will be returned when the following SQL statement is executed? SELECT driver_no,count(*) as num_deliveries FROM deliveris GROUP BY driver_no;

A listing of each driver as well as the number of deliveries that her or she has made

Which of the following statements is true about the figure shown below

A rental unit can be an apartment, house or just a rental unit, it may not be more than one at the same time

The following statement is an example of: CREATE TABLE Customer_t( CustNmbr number(11,0), CustNmbr number(6,2), CutStart date, CutStart date, PERIOD for Custperiod(CustStar,CustEnd));

An Application Time Period Table

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

Attributes

The ________ DBA vies shows information about all users of the database in Oracle

DBA_USERS

A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is

Data Profiling

The role responsible for administering database security is

Database Administration

With ______, the databse itself is lost, destroyed, or cannot be read

Database Destruction

Which of the following functions do cost/benefit models?

Database Planning

A data management platform service is called

Database-as-a-service

The value a field will assume unless the user enters an explicit value for an instance of that field is called a

Default Value

An Attribute of an entity that is computed is a(n)

Derived Attribute

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

Derived Table

Specifying how data from a logical schema are stored in secondary memory is part of the

Design

A _______ addresses whether an instance of a super type may simultaneously be a member of two or more sub types

Disjointness Constraint

Any create command may be reversed by using a(n) _________ command

Drop

Database development begins with ___________, which establishes the range and general contents of organizational databases.

Enterprise data modeling

_______ takes a value of TRUE is a sub query returns an intermediate results table which contains one or more rows

Exists

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the

Explain Plan

A command use in oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the

Explain plan

The first part of a SQL query to be read is the _________ statement

FROM

The first part of an SQL query to be read is the __________ statement

FROM

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, as well as many DBMS function is called a

Fat Client

A(n) _____________ is a technique for physically arranging the records of a file on a secondary storage devices

File Organization

The normal form which deals with multi valued dependencies is called

Fourth normal form

SQL-invoked routines can be

Functions or procedures

One major disadvantage of JSP is

HTML, Java code and SQL code are mixed together

Relational Databases establish the relationships between entities by using field(s) in one entity that

Have values in common with the other entity, thereby creating a virtual link between them

A file organization where files are not stored in any particular order

Heap File organization

Distributing the rows of data into separate files is called

Horizontal Partitioning

Business policies and rules govern all of the following except: 1) Removing Data 2) Creating Data 3) Managing Employees 4) Updating Data

Managing employees

_______ anomalies can be caused by editing data in tables

Modification

A requirement to begin designing physical files and databases is

Normalized relations

Understanding the steps involved in transforming EER diagrams into relations is important because

One must be able to check the output of a CASE tool

To get all the customers from Hawaii sorted together, which of the following would be used?

Order By

In the ________ approach, one consolidated record is maintained from which applications draw data

Persistent

In the ____________ approach, one consolidated record is maintained from which all applications draw data

Persistent

The W3C standard for Web privacy is called

Platform for Privacy Preferences

With the database approach, data descriptions are stored in a central location know as a

Repository

A single value returned from an SQL query that includes an aggregate function is called an

Scalar Aggregate

Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called

Schema on write

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process, and output electronic data in a secure manner is called

Smart card

One simple task of a data quality audit is to

Statically profile all files

Which is an entity that exists independently of other entity types

Strong

The most common types of entities are

Strong entities

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

Subquery

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

Subquery

________ specify computer systems requirements

Systems Analysts

A candidate key must satisfy all of the following conditions except

The key must indicate the row's position in the table

A PC configured to handle User interfaces with limited local storage is called a(n):

Thin Client

A sequence steps that constitutes a well-defined business activity is called a

Transaction

Forward recovery is faster than restore/rerun because

Transactions do not have to be repeated

A Functional dependency between two or more nonkey attributes is called a

Transitive Dependency

A generic or template data model that can be reused as a starting point for a data modeling project is called an

Universal data model

Because applications are often developed independently in file processing systems

Unplanned duplicate data files are the rule rather than the exception

A transaction is considered isolated when

any changes in the database are not revealed to the user until the transaction is complete

The preferred method of fixing an aborted transaction is

backing out the transaction

User defined data types

can have defined functions and methods

A materialized view is/are

copies or replica of data based on queries

The total quiz points for a student for an entire semester is a ________ attribute

derived

A nonkey attribute is also called a(n)

descriptor

Requiring a CustomerID to exists in a Primary table before it can exist in a foreign table is an example of

referential integrity

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

referential integrity constraint

A PC configured to handle user interfaces with limited local storage is called a(n)

thin client

A(n) _________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks for a transaction are acquired before any release

two-phase lock

A relation that contains minimal redundancy and allows easy use is considered to be

well-structured