BUSA 521 Comprehensive Exam

A primary key field that uses two or more fields is known as a

• single primary key

• composite primary key

• foreign key

• candidate key

A virtual table in a database is known as a

• table

• view

• record

• field

Which clause is used to filter aggregate data?

• where

• having

• group by

• from

An analyst finds that the number of cyber security breaches (x) can influence a company's stock price per share (y) in the following way:

y= -2x + 5.5

The analyst also finds that R-squared value of this regression model is 0.315

The analyst finds that two cyber security breaches happened in a company. What is the estimated stock price per share of that company according to the regression model?

• 1

• 2

• 3

• 1.5

The constraints X1 >_ 0 and X2 >_ 0 are referred to as

• positivity constraints

• optimality conditions

• left hand sides

• non-negativity conditions

The reason an analyst creates a regression model is

• to determine the errors in the data collected

• to predict a dependent variable value given specific independent variable values

• to predict an independent variable value given specific dependent values

• to verify the errors are normally distributed

Person is identified by SSN, name, and address. Each person can marry multiple
persons in his/her life. However, only one person is married with another person at one time.
Create ERD for this scenario.

• 
• 

Which statement is NOT correct regarding the linear regression analysis?

• The regression analysis can help analysts understand how independent variables influence the
  dependent variable

• Using the customer’s gender as a dummy variable to predict the customer’s spending is to compare
  the difference between the female customer’s spending and the male customer’s spending.

• If the residual plots randomly and independently distribute around the zero line, an analyst can use
  the regression model from the sample to infer the relationship between independent variables and
  the dependent variable of the population.

• The level of significance indicates the minimum risk an analyst is willing to take to accept the
  regression model while it is not correct.

An analyst finds that the number of cyber security breaches (x) can influence a
company’s stock price per share (y) in the following way:
y = -2 x + 5.5
The analyst also finds that the R-squared value of this regression model is 0.315
What is the R-squared explained?

• The R squared value tells you if there is a negative relationship

• The R squared value tells you if there is a positive relationship

• The R squared value tells you if there is a significant relationship

• The R squared value tells you if there is a significant difference

• None of these

Which activity is NOT in a project’s planning stage?

• Planning the scope of the project

• Planning a Work Breakdown Structure (WBS)

• Planning activities

• Closing the project