# Analysis Tools

Lead Author(s): **Saylor Academy**

Source: **Saylor**

Student Price: **FREE**

A question pack on design decisions in engineering.

This content is licensed under the Creative Commons Attribution 3.0 Unported License.

Estimates of risk can be made by ______________.

logic

statistical analysis

frequency

judgment

All of the above

In database for Decision Supporting Systems, a data model ______________.

is a representation of the structure of a database

describes the categories of things that can exist in the database

are the things in each category that exist in the actual database at a given time

describes the database at a given time

describes the relationships that it can hold among entities

In database for Decision Supporting Systems, a schema ______________.

is a representation of the structure of a database

describes the categories of things that can exist in the database

are the things in each category that exist in the actual database at a given time

describes the database at a given time

describes the relationships that it can hold among entities

In database for Decision Supporting Systems, instance ______________.

is a representation of the structure of a database

describes the categories of things that can exist in the database

is the thing in each category that exists in the actual database at a given time

describes the database at a given time

describes the relationships that it can hold among entities

In dynamic programming, problems are divided into a number of ______________.

decision stages

constraints

nodes

objectives

none of the above

In dynamic programming, the output to stage n‑1 becomes the input to ______________.

stage n

stage n‑2

stage n+1

stage n+2

none of the above

In multiobjective optimization, a noninferior solution Y for a given set of input X is ______________.

a solution that maximizes all objectives

a solution that minimizes all objectives

a solution such that no other feasible solution for the same input set X is better on all individual objectives

a solution such that no other feasible solution for the same input set X is worse on all individual objectives

None of the above

In multiobjective optimization, the advantages of the weighting method include the following(s):

Less computing resources are required as compared with the constraint method.

A feasible solution always exists.

A complete description of the noninferior solutions is provided.

A and B

A, B, and C

In multiobjective optimization, the constraint method ______________.

optimizes the weighted sum of the objectives, subjected to constraints on inputs

optimizes one objective while representing all other objectives as constraints

optimizes multiple objectives while representing one objective as constraints

optimizes the objectives, subjective to a weighted sum of the constraints

None of the above

In multiobjective optimization, the weighting method ______________.

optimizes the weighted sum of the objectives, subjected to constraints on inputs.

optimizes one objective while representing all other objectives as constraints

optimizes multiple objectives while representing one objective as constraints

optimizes the objectives, subjective to a weighted sum of the constraints

None of the above

In relational database, a ______________ operation forms a new table by combining records from two tables that match on a common attribute.

“select”

“project”

"join”

“union”

“difference”

In relational database, a ______________ operation forms a new table containing all rows in the first table but not in the second (tables must match on all attributes).

“select”

“project”

“join”

“union”

“difference”

In ______________ , feasible space consists of integer variables.

linear programming

nonlinear programming

integer programming

goal programming

dynamics programming

Linear programming assumes ______________ .

certainty

linearity

additivity

divisibility

all of the above

The risk avoider ______________.

prefers uncertain amounts that have an expected value equal to the certain amount

prefers certain amounts over uncertain amounts with the same expected value

is indifferent, or has a tie in terms of preference, between the two

all of the above

none of the above

Utility theory ______________.

incorporates our attitude toward risk into the decision‑making process

measures risk

is a decision support tool that uses a tree‑like graph or model of decisions and their possible consequences

all of the above

none of the above

Which of the following constraints is typical for a resource‑allocation problem?

$>$=

<=

=

none of the above

all of the above

Which of the following is a method for solving a multiobjective optimization problem?

Weight sum

Weighted exponential sum

Lexicographic

Tchebycheff

All of the above

Which of the following is not a component of a linear programming model?

Decisions

Excel spreadsheet

Data

Measures of performance

Constraints

______________ cannot fit naturally into a relational model.

Complex constraints

Uncertainty about values of attributes

Subtypes that share some but not all structure and features of parent type

Context‑dependent structure

All of the above

Company A produces two products X and Y. Each X requires 4 units of material C and each Y requires 7 units of material C. The total amount of material C available for each month is 5000. Let x and y be the number of X and Y produced in a month. If we want to optimize products of X and Y, what is the appropriate constraint on material C?

4x+7y > 5000

4x+7y <= 5000

7y > 5000

4x > 5000

4x = 7y

Hotel A is a one‑star hotel, located 0.7 miles from the beach and costs $12 a night. Hotel B is a three‑star hotel, located 0.2 miles from the beach and costs $1,500 a night. Hotel C is a two‑star hotel, located 0.5 miles from the beach and costs $1,000 a night. Hotel D is a three‑star hotel, located 0.6 miles from the beach and costs $2,000 a night. Hotel E is a two‑star hotel, located 1.5 miles from the beach, and costs $1,100 a night. We want to find a hotel that has the most stars, closer to the beach, and less expensive. Find the Pareto optimal solution.

Hotel A

Hotel B

Hotel C

Hotel D

Hotel E

Solve the following optimization problem: Maximize Y, which is subjected to the following constraints: (i) X – 2Y ≥‑1, (ii) X ≤ 2, (iii) X ≥ 0 and (iv) Y ≥ 0. Find the optimum.

X = 2, Y = 1.5

X = 2, Y = 1

X = 0, Y = 0

X = 1, Y = 2

X = 0, Y = 1

Content on this site is licensed under a Creative Commons Attribution 3.0 Unported License .

Saylor Academy and Saylor.org® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Designer: Thi Dang