Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Question 1:
In a database, the things for which information is stored and maintained are called:
fields.
measurements.
entities.
attributes.

Question 2.
Which option in Risk Solver Platform allows you to choose the number of times random values can be generated for the uncertain cells in the model?
Trials per Simulation
Simulations to Run
Only Run
Sim. Random Seed

Question 3.
What is a database?
A collection of related files
Simply a collection of data
A data file holding a single file
Flat files used to store data

Question 4.
During which phase in problem solving is a formal model often developed?
Analyzing the problem
Structuring the problem
Defining the problem
Implementing the solution

Question 5.
Which of the following is an example of a measure of continuous metrics?
Four errors revealed in an invoice
A delivery delayed by seven days
Weight and volume of a sheet of steel
Three incomplete orders on a day

Question 6.
Which of the following is a parameter in the Normal Distribution Dialog of the Risk Solver Platform?
Maximum value
Minimum value
Most likely value
Mean

Question 7.
Which of the following inputs of a decision model is an example of data?
Estimated consumer demand
Inflation rates
Costs
Investment allocations

Question 8.
Which of the following ways would × /100 - 73 be represented in an Excel spreadsheet?
10(2) * 5(3) / 100 ^ 73
10(2) ^ 5(3) / 100 - 73
10^2 * 5^3 / 100 - 73
10*2 ^ 5*3 / 100 - 73

Question 9.
Monte Carlo sampling differs from Latin Hypercube sampling in that the Monte Carlo sampling:
results in a more even distribution of output values.
uses the entire range of the distribution in a more consistent manner.
selects random variates independently over the entire range of possible values of the distribution.
uses an uncertain variable whose probability distribution is divided into intervals of equal probability.

Question 10.
Which of the following questions will prescriptive analytics help a company address?
How many and what types of complaints did they resolve?
What is the best way of shipping goods from their factories to minimize costs?
What do they expect to pay for fuel over the next several months?
What will happen if demand falls by 10% or if supplier prices go up 5%?

Question 11.
Identify the uncontrollable variable from the following inputs of a decision model.
Investment returns
Machine capacities
Staffing levels
Intercity distances

Question 12.
In the ________ method, the distance between groups is defined as the distance between the closest pair of objects, where only pairs consisting of one object from each group are considered.
Ward's linkage clustering
single linkage clustering
divisive clustering
average group linkage clustering

Question 13.
Divisive clustering method is different from agglomerative clustering methods in that divisive clustering methods:
can only have a pair of subjects in each cluster.
separate objects into a particular cluster in one step.
separate n objects successively into finer groupings.
can only have a single subject in each cluster.

Question 14.
________ is the ratio of the number of transactions that include all items in the consequent as well as the antecedent to the number of transactions that include all items in the antecedent.
Lift
Logit
Support for the association rule
Confidence of the association rule

Question 15.
The weights for determining the discriminant functions are determined by:
assessing the number of outliers that are present in each group.
calculating the distance between the two closest observations in each group.
measuring the closeness between predictor values of each set.
maximizing the between-group variance relative to the within-group variance.

Question 16.
In classification, which of the following would be considered as a categorical variable of interest for a credit approval decision for a requester?
Age of the requester
Income of the requester
Revolving balance of the requester
Reject or accept credit approval

Question 17.
Logistic regression is different from discriminant analysis in that logistic regression:
does not predict the weights.
sets observation into predefined classes.
does not depend on assumptions.
depends on assumptions such as normalization of independent variables.

Question 18.
Which of the following is true of association rule mining?
It develops analytic models to describe the relationship between metrics that drive business performance.
It identifies attributes that occur frequently together in a given data set.
It seeks to classify a categorical outcome into one of two or more categories.
It is a data reduction technique that reduces large information into smaller heterogeneous groups.

Question 19.
Which of the following is included in the data mining approach of data exploration and reduction?
Analyzing data to predict how to classify a new data element
Identifying groups in which the elements of the groups are in some way similar
Creating rules for target marketing based on association of variables
Developing analytic models to describe the relationship between metrics

Question 20.
The strength of the association rule, known as lift, is calculated as the ratio of the:
sum of the antecedents and the consequents to the antecedents.
antecedents to the consequents.
support to the confidence level.
confidence to expected confidence.

Question 21.
The ________ algorithm is a classification scheme that attempts to find records in a database that are similar to one we wish to classify.
linear regression
logistic regression
k-Nearest Neighbors
discriminant analysis

Question 22.
________ is a collection of techniques that seek to group or segment a collection of objects or observations into subsets, such that those within each subset are more closely related to one another than objects assigned to different subsets.
Association rule mining
Discriminant analysis
Cluster analysis
Logistic regression

Question 23.
Two-way data tables can evaluate only one output variable.
True
False

Question 24.
The accuracy of the model on the test data gives a realistic estimate of the performance of the model on completely unseen data.
True
False

Question 25.
In cluster analysis, the objects within clusters should exhibit a high amount of dissimilarity.
True
False

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92286736
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question?


Related Questions in DBMS

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Sqlwrite a select statement that returns one column from

SQL Write a SELECT statement that returns one column from the Vendor table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Format it as follows: last name, comma, first nam ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

Solve the following questions using oracle you are not

Solve the following questions using Oracle. You are not allowed to use the syntax of any DBMS other than Oracle. Make sure to upload an electronic copy of your solution to your CSC335 TRACE folder. Name the file hw4.sql. ...

Database design and development assignment -assessment task

Database Design and Development Assignment - Assessment task - 1. Normalization a) Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations m ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As