ISM 4210 FINAL

________ is the process of assigning pieces of application code to clients or servers.

Application partitioning

In the figure shown below, which of the following business rules would apply?

Each vendor can supply many parts to any number of warehouses, but need not supply any parts.

Which of the following is NOT an objective that drove the development and evolution of database technology?

The desire to require programmers to write all file handling functionality.

What will result from the following SQL Select statement? SELECT MIN(Product_Description) FROM Product_V; Group of answer choices

The first product description alphabetically in Product_V will be shown.

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

all rows of the Order_T Table regardless of matches with the Customer_T Table.

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

attributes.

All of the following are valid datatypes in Oracle 12c EXCEPT:

boolean

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

design

Which of the following can produce scalar and vector aggregates?

group by

Data quality is important for all of the following reasons EXCEPT:

it provides a stream of profit

An index on columns from two or more tables that come from the same domain of values is called a:

join index

Which Java method retrieves the next row of a cursor

next()

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

relation

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

subquery

The following figure shows a:

supertype/subtype hierarchy.

All of the following are disadvantages to cloud-based computing EXCEPT: Group of answer choices

the visibility of costs of data management is better.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

using the CASE key word in a statement.

An optimistic approach to concurrency control is called:

versioning

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

well-structured