What is a database

Assignment Help Database Management System
Reference no: EM131477999

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

Reference no: EM131477999

Questions Cloud

Equal masses of the first and third are mixed : Find the equilibrium temperature when equal masses of the first and third are mixed.
How corporate structure impacts effectiveness of governance : Corporate structure and how it impacts the effectiveness of governance. Concerns to consider when developing and strengthening a team culture.
Find the density of the oil : The scale now reads 275 N. Find the density of the oil.
Determine how long data should be retained : Data classification labels determine how long data should be retained and the labels also determine how quickly the data should be recovered when lost.
What is a database : Which of the following is a parameter in the Normal Distribution Dialog of the Risk Solver Platform?
Outline the differences between solids : Outline the differences between solids, liquids and gases in terms of
Explain what are some project pitfall you will want to watch : Read the project case for this assignment. What are some project pitfalls you will want to watch out for as you execute this project?
Calculate maximum length that circuit-board trace carrying : Phase shift due to finite length of circuit conductors. On a particular type of circuit board, Calculate the maximum length that circuit-board trace carrying
Larger linear momentum and by what factor : Which one has the larger linear momentum and by what factor? Why?

Reviews

Write a Review

Database Management System Questions & Answers

  Draw the er diagram above scenario by illustrating the

Consider the following requirements for an airline ticketsbooking system. The system is composed of manyairlines. Each airline is identified by a code, name and headquarter’s address. An airline has different mileprograms, identified by a type- code,..

  Use an entity relationship diagram to define the structure

Use an entity relationship diagram to define the structure of the system.

  Identify fundamental concepts of database management systems

Identify the fundamental concepts of Database Management systems. Explain the primary defining feature of a database management system.

  Find all of the strong association rules

Find all of the strong association rules. Provide support, c onfidence, and lift for all the rule. Provide the reasons why the rules you selected are interesting.

  Find all governors general of australia

Find all Governors General of Australia who were Barons at the time and Restrict your query to Governors General who were Barons at the time of their appointment

  Given the following sample database diagram do the

given the following sample database diagram do the followingcreate the needed tables in the sql server environment just

  Design tool for relational databases

Entity relationship model is in wide use as a design tool for relational databases. Why do you think designers have chosen this model, and what makes it an effective design tool?

  Create a query using the simple query wizard

Start Access. Open the downloaded Access file named exploring_a02_grader_h1. Create a new table in Datasheet view using the name Donations. Switch to Design View and change ID to DonationID. Add the following field names to the table: DonorID, Plan..

  Create an entity-relationship diagram and design

create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices

  Importing namespace system. io. import system. io

Create an application that stores people's names and birthdays in a file (Fig. 23.40). The user creates a file and inputs each person's first name, lastname and birthday on the Form. The information is then written to the file.

  Create a spreadsheet and import the tables

Demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets and Data Validation Check

  Write a function checksmaller

Write a function 'Max' that takes an int array and the size of the array as input and returns the largest element of the array. The function should look like the following.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd