ISYS 2263 Exam 2 Practice Questions

As seen in the class activity with examples such as Bingham and Bing, when executing a SQL query in MS-Access, to retrieve all the records where LastName starts with "Bin", you use the following character with LIKE keyword for searching the matches. A. # B. "" (Empty String) C. % D. *

(((((())))))D. *

We executed the following code fragment in MS-Access during class activities. This code fragment is an example of a_________. SELECT Instructor.InstructorID, Instructor.InstructorLName, Instructor.InstructorFName FROM Instructor WHERE (((Instructor.InstructorLName)=[Enter Last Name]));

*

Which one or more of the following is TRUE about the following code fragment? SELECT SUM(salary) AS "Total Salary" FROM employees WHERE salary > 25000; This operates on the employees table This operates on the salary table The query returns the output as salary. It operates on "manager" column before aggregating record

*

Which options are FALSE about the SQL Statement below (one or more options)? CREATE TABLE inventory ( INV_ID INTEGER NOTNULL, INV_OPER_ID VARCHAR(30) NOTNULL ); A. INV_OPER_ID cannot accommodate IDs with 12 characters B. This is a valid DML Statement C. This creates three new columns - inventory, INV_ID and INV_OPER_ID in the database D. Data types will have no major validity issues during compilation E. This is not a valid SQL code example per the DML notations

*

Which of the following are (more than one) true about the following code? CREATE VIEW [Current Product List] As SELECT ProductID, ProductName FROM Products WHERE Discontinued = No; 1. The CREATE statement creates new table 'Current Product List' in the database 2. The WHERE command helps to select and display all discontinued products 3. It creates a dynamic subset of rows and columns based on matching the criteria 4. The query searches three columns in the database 5. It fetches results from ProductID and ProductName tables in the database

*1/2 points 3. It creates a dynamic subset of rows and columns based on matching the criteria 5. It fetches results from ProductID and ProductName tables in the database

Which of the following are reasons for silo effect becoming worser and leading to negative results? Choose two answers. 1. Globalization that led to larger organizations where no one can see the whole picture 2. Too much focus on process objectives instead of functional objectives 3. Too much focus on functional objectives instead of process objectives 4. People in different functional areas having clear understanding of which steps happen before and which steps happen next

1. Globalization that led to larger organizations where no one can see the whole picture 3. Too much focus on functional objectives instead of process objectives

Which of the following are examples of modules in SAP R/3 Application 1. Supply Chain Management (SCM) 2. Production Planning 3. Sales and Distribution 4. Customer Relationship Management (CRM) 5. Product Lifecycle Management (PLM)

1. Production Planning 3. Sales and Distribution

Per what you learned in the class, which of the following is TRUE about INSERT statement? 1. You can insert rows and columns from one table into another table, for example, when taking a subset of data to populate another table 2. Input of records that has some null attributes does require identifying the fields that actually get the data 3. It updates current values in one or more rows in a table 4. INSERT helps to insert duplicate values into the primary key field 5. INSERT is a data definition language statement because it creates new tables in the database

1. You can insert rows and columns from one table into another table, for example, when taking a subset of data to populate another table 2. Input of records that has some null attributes does require identifying the fields that actually get the data

Which of the following is TRUE about the SQL code snippet? CREATE TABLE OrderLine_T (OrderID NUMBER(11,0) NOT NULL, ProductID INTEGER, OrderedQuantity NUMBER(11,0) CONSTRAINT OrderLine_PK PRIMARY KEY (OrderID), CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T(OrderID), CONSTRAINT OrderLine_FK1 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID)); 1. A constraint is required on OrderLine column 2. A constraint is required on OrderedQuantity column 3. It contains one primary key and one foreign key 4. It contains one foreign key to link to other tables 5. It creates 4 columns in the database table - Order ID, ProductID, OrderedQuantity, OrderLine 6. A constraint is required on ProductID. 7. The OrderLine table is linked to two other tables

1/2 points* It contains one primary key and one foreign key It creates 4 columns in the database table - Order ID, ProductID, OrderedQuantity, OrderLine The OrderLine table is linked to two other tables

Michael, Inc., a manufacturer of electric guitars, is a small firm with 50 employees. The table below shows the hourly wage distribution of the employees. Hourly Wages (In Dollars): Number of Employees 10 - 13: 8 14 - 17: 12 18 - 21: 20 22 - 25: 10 What percentage of the employees has hourly wages of less than $14?

16%

A recent issue of Fortune Magazine reported that the following companies had the lowest sales per employee among the Fortune 500 companies. Company Sales per Employee (In $1,000s) Sales Rank Seagate Technology 42.20 285 SSMC 42.19 414 Russel 41.99 480 Maxxam 40.88 485 Dibrell Brothers 22.56 470 How many variables are in the above data set?

2

A recent issue of a national magazine reported that in a national public opinion survey conducted among 2,000 college students, 56% were in favor of gun control, 40% opposed gun control, and 4% had no opinion on the subject. What is the sample in this survey?

2,000 college students

The following table shows the age distribution of a sample of 180 students at a local college. AGE DISTRIBUTION OF 180 STUDENTS AT A LOCAL COLLEGE Age of Students: Number of Students 15 - 19: 36 20 - 24: 44 25 - 29: 60 30 - 34: 38 35 - 39: 2 Of the students in the sample, what percentage is younger than 20 years of age?

20%

The following table shows the age distribution of a sample of 180 students at a local college. AGE DISTRIBUTION OF 180 STUDENTS AT A LOCAL COLLEGE Age of Students: Number of Students 15 - 19: 36 20 - 24: 44 25 - 29: 60 30 - 34: 38 35 - 39: 2 What percentage is at least 30 years of age? (1 decimal place)

22.2%

Michael, Inc., a manufacturer of electric guitars, is a small firm with 50 employees. The table below shows the hourly wage distribution of the employees. Hourly Wages (In Dollars): Number of Employees 10 - 13: 8 14 - 17: 12 18 - 21: 20 22 - 25: 10 How many employees receive hourly wages of at least $18?

30

After graduation ceremonies at a university, six graduates were asked whether they were in favor of (identified by 1) or against (identified by 0) abortion. Some information about these graduates is shown below. How many variables are in the data set?

4

A recent issue of a national magazine reported that in a national public opinion survey conducted among 2,000 college students, 56% were in favor of gun control, 40% opposed gun control, and 4% had no opinion on the subject. Based on the sample, what percentage of the population would you think have no opinion on the subject?

4%

When creating a database, which of the following are valid questions you need to ask at the definition stage? 1.What queries to build for visualizing database contents? 2.Which forms will I create? 3.What queries will I build? 4.What are the data types? 5.Which reports will I create? 6.What are the tables and fields in tables? 7.What is the schema? 8.Are there any other constraints?

4. What are the data types? 6. What are the tables and fields in tables? 7. What is the schema? 8. Are there any other constraints?

The following table shows the age distribution of a sample of 180 students at a local college. AGE DISTRIBUTION OF 180 STUDENTS AT A LOCAL COLLEGE Age of Students: Number of Students 15 - 19: 36 20 - 24: 44 25 - 29: 60 30 - 34: 38 35 - 39: 2 Based on this sample, what percentage of the students at the college do you estimate to be younger than 25 years of age? (1 decimal place)

44.4%

A recent issue of Fortune Magazine reported that the following companies had the lowest sales per employee among the Fortune 500 companies. Company Sales per Employee (In $1,000s) Sales Rank Seagate Technology 42.20 285 SSMC 42.19 414 Russel 41.99 480 Maxxam 40.88 485 Dibrell Brothers 22.56 470 How many observations are in the above data set?

5

A recent issue of Fortune Magazine reported that the following companies had the lowest sales per employee among the Fortune 500 companies. Company Sales per Employee (In $1,000s) Sales Rank Seagate Technology 42.20 285 SSMC 42.19 414 Russel 41.99 480 Maxxam 40.88 485 Dibrell Brothers 22.56 470 How many elements are in the above data set?

5

A recent issue of a national magazine reported that in a national public opinion survey conducted among 2,000 college students, 56% were in favor of gun control, 40% opposed gun control, and 4% had no opinion on the subject. Based on the sample, what percentage of the population would you think is in favor of gun control? Please enter a number for your answer

56%

After graduation ceremonies at a university, six graduates were asked whether they were in favor of (identified by 1) or against (identified by 0) abortion. Some information about these graduates is shown below. How many elements are in the dataset?

6

Michael, Inc., a manufacturer of electric guitars, is a small firm with 50 employees. The table below shows the hourly wage distribution of the employees. Hourly Wages (In Dollars): Number of Employees 10 - 13: 8 14 - 17: 12 18 - 21: 20 22 - 25: 10 What percentage of the employees has hourly wages of at least $18?

60%

A. B. C. D.

A. B. C. D.

Which of the following is not associated with collecting big data? A. Business Analytics tools B. Social media networks C. Transactions D. Automation of operations and devices

A. Business Analytics tools Business Analytics tools only help to analyze big data. They are not the reason for its proliferation.

__________________exists when different versions of the same data appear in different places. A. Data inconsistency B. Data integrity C. Data security D. Data quality

A. Data inconsistency

Which of the following is false about enterprise systems? A. Enterprise systems are in fact not ideal because they increase the negative effects of silo effect and lead to reduced effectiveness in organizations B. They integrate all functional areas together to enhance visibility of information and effectiveness C. These modern information systems help to communicate, coordinate and collaborate with employees across the world when the company has operations globally. D. Enterprise systems reduce delays and inventories and thereby increase profitability and competitive advantage

A. Enterprise systems are in fact not ideal because they increase the negative effects of silo effect and lead to reduced effectiveness in organizations

Accurate, relevant, and timely information is the key to ____. A. Good decision making B. Data management C. Knowledge D. Understanding

A. Good decision making

Which two of the following are FALSE about the following SQL code? SELECT * FROM Customers ORDER BY Country ASC, CustomerName DESC; A. It sorts columns by Country and then by CustomerName B. It operates on the Customers and Country Tables C. It displays only the data from the Country and CustomerName columns D. It sorts rows by Country and then by CustomerName

A. It sorts columns by Country and then by CustomerName B. It operates on the Customers and Country Tables C. It displays only the data from the Country and CustomerName columns

When fetching data from two tables, the _______________________ command is used in FROM clause before doing an equality check on common columns using the identifier keys.(SQL) A. JOIN B. CONCATENATE C. COMBINE D. MERGE

A. JOIN

In the University database at the UofA, your student IDs stored as, say, 1001, 2002, 3003, 4004 are examples of: A. Nominal B. Ratio C. Interval D. Ordinal

A. Nominal

Which of the following is false about the three types of ERP Data? A. Organizational Data frequently changes with every sale in a store like Walmart B. Master Data is long term data to represent entities associated with various processes C. Transaction data is generated with execution of process steps such as sales occurring in Walmart stores D. Financial Data is a type of Master Data

A. Organizational Data frequently changes with every sale in a store like Walmart

Any foreign key field must agree with the primary key that is referenced by the foreign key. In other words, for every foreign key, there exists a primary key in another table used as a foreign key in the current table. This is a definition of: (SQL) A. Referential Integrity B. Relational Integrity C. Relational database D. Connective Query

A. Referential Integrity

Which of the following is FALSE about challenges in ERP implementations? A. Staffing is not expensive in ERP implementations B. ERP implementations are expensive C. ERP implementations are complex and often run into years D. ERP implementations create job conflicts

A. Staffing is not expensive in ERP implementations

Which of the following is a critical success factor of ERP implementation? A. Strong leadership B. Users resist change C. Lack of executive leadership D. Lack of planning E. Top class CEOs with IT skills

A. Strong leadership

A ___________________ is a characteristic of a field that determines what type of data it can hold. A. data type B. column characteristic C. designated boolean D. parameter query

A. data type

The highway patrol is interested in determining the average speed of all automobiles traveling on interstate 75. To accomplish this task, the speed of every tenth car passing a particular point on interstate 75 is recorded. What is the population for this study (all automobiles traveling on interstate 75 or every tenth car)?

All automobiles traveling on the interstate

Whenever you execute a query to retrieve data from a database table by using SELECT statements, the following feature helps you in manipulating the column titles to something that is more legible than pre-defined information. Note: As you have seen, the query places the outputs in a structure which looks similar to a table. A. Semantic Column Redefining B. Column Aliasing C. Interpretative Column Renaming D. Semantic Column Renaming

B. Column Aliasing

ERP implementation failures are caused by A. Trying to do everything per a project plan with necessary money allocated to implement the project B. Failure to involve affected employees C. Correctly estimating the complexity of planning, development and training necessary D. Correctly relying on vendors and consulting firms

B. Failure to involve affected employees

In MS-Access terminology,_________________________ is a table component that contains a category of information that pertains to all records. A. Category B. Field C. View D. Query

B. Field (Column)

A workgroup database is a(n)____ database. A. Single-user B. Multiuser C. Enterprise D. Distributed

B. Multiuser

The set of measurements (values) collected for a particular element is called: A. Metrics B. Observations C. Records D. Variables

B. Observations

End-user data is ____. A. Raw facts about the end-user B. Raw facts of interest to the end-user C. Accurate, relevant and timely information D. Data about data

B. Raw facts of interest to the end-user

In the production process, what step must be complete before production is authorized? A. Create product B. Request production C. Issue raw materials D. Prepare shipment E. None of these

B. Request production

The WHERE Command restricts the selection of_______________based on a conditional expression A. Values B. Rows C. Columns D. Primary Keys

B. Rows

The tendency for departments or divisions to compartmentalize themselves and only be concerned with the departmental or division s tasks or role is known as ________________. A. Isolation syndrome B. Silo effect C. Enterprise system D. Functional effect E. Silo process deficiency

B. Silo effect

____ data are the result of formatting to facilitate storage, use and generation of information. A. Historical B. Structured C. Semistructured D. Unstructured

B. Structured

A ___________________is a storage container for data. A. Query B. Table C. View D. Report

B. table

The database structure in a DBMS is stored as a ____. A. File B. Set of key/value pairs C. Collection of files D. Collection of queries

C. Collection of files

Which of the following is true about the given SQL code? (SQL) SELECT * FROM customers WHERE EXISTS (SELECT * FROM orders WHERE customers.customer_id = orders.customer_id); A. It selects a few columns from the Customer table and a few columns from the Orders table and filters them based on Primary Key, Foreign Key relationship B. CustomerID is the primary key in the Orders table being used to join two tables i.e. Customers and Orders C. It selects all Customer and Order information based on primary key and foreign keys relationships that help connect the record level data. D. The WHERE command selects the columns based on conditional expression E. CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

C. It selects all Customer and Order information based on primary key and foreign keys relationships that help connect the record level data. E. CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

When you are executing SQL statements specifically in MS-Access database as seen in the course, which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces. A. Like "*704" B. Like "704%" C. Like "704*" D. Like "%704"

C. LIKE "704*"

Which is not a benefit of having an ERP system? A. Information and processes are integrated B. Single storage of data C. Processes are no longer visible and stay hidden D. Support of global business E. None of these

C. Processes are no longer visible and stay hidden

In the procurement process, once the materials have been received, what is the next step in the process? A. Create purchase requisition B. Create and send purchase order C. Receive invoice D. Send payment E. None of these

C. Receive invoice

Which of the following is a feature in ERP that helps to prevent fraud when someone intends to willfully tamper financial transactions in the system? A. Compliance B. Inter-organizational Systems Support C. Integrated Information and Clear Visibility of Information D. Audit Trail

D. Audit Trail

The number of occurrences of an expression i.e. number of rows with non-null values is determined using the ____ aggregate function. A. AVERAGE B. SUM C. MAX D. COUNT

D. COUNT

The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. A. Management system B. Database management system C. Database management D. Database system

D. Database system

In a table,__________________________is a range of possible values a field can take. Note that field means column in Access terminology. One advantage of using this feature in database design is that it allows to show values in drop downs in the user interface design, for example, course grades. A. Domain Selections B. Data Range C. Domain Range Options D. Domain

D. Domain

ERP is an acronym for ________________. A. Everyone Resource Projects B. Excellent Requirements Planning C. Enterprise Requirements Projects D. Enterprise Resource Planning

D. Enterprise Resource Planning

A ____ is a collection of related records. A. Database B. Field C. Column D. File

D. File

Which one of the following is not a result of investing in an enterprise system? A. Increased profitability due to process efficiencies B. Increased productivity due to process efficiencies C. Competitive edge by bringing in visibility of operations D. Freedom to departments to have their own data collection and store it in their own department formats E. Integrated processes that align data, execution and people

D. Freedom to departments to have their own data collection and store it in their own department formats

Which one of the following business processes focuses on internal reporting to manage costs and revenues? A. Production Planning B. Internal Book Keeping C. Financial Accounting D. Management Accounting

D. Management Accounting

To distinguish one row i.e. one record from another, tables contain: A. Relational Row Independence Specifications B. Row Integrity Specifications C. Existence Independence Specifications D. Primary Key Specifications

D. Primary Key Specifications

Which of the following is not true about ERP? A. ERP covers all business processes B. Data is shared amongst functional areas C. Eliminates standalone data and its redundancies D. Supports Strategic, Management, Transaction needs of an organization E. ERP applications are mainly for integrating external partners

E. ERP applications are mainly for integrating external partners

Which of the following is not a challenge in implementing ERP? A. ERP systems are expensive B. Implementation processes are not simple even if you have good IT departments C. Implementation effort depends on the size of the company D. ERP realigns jobs and culture E. ERP is more of a technical change

E. ERP is more of a technical change

The highway patrol is interested in determining the average speed of all automobiles traveling on interstate 75. To accomplish this task, the speed of every tenth car passing a particular point on interstate 75 is recorded. What constitutes the sample (all automobiles traveling on interstate 75 or every tenth car)?

Every tenth car

DELETE TABLE FROM CUSTOMERORDERS_T is one Command which completely removes a table from your table schema that you created earlier. (T/F)

False

SQL is a non-procedural language and it gives you flexibility to focus on what the program should do rather than what sequence of tasks. Because of this non-procedural advantage of SQL, when you drop the tables which are not helpful for your analysis, the order of dropping need not be considered. This is because SQL allows you to focus on what the program should do. SQL will handle the ordering and sequence of tasks. Your job as data analyst is to identify the tables to drop based on their lack of value in your business tasks. true/false

False

True or False: ERP is beneficial because it integrates information but the downside is that it does not eliminate stand-alone functional systems

False

True or False: In experimental studies, the variable of interest is not controlled

False

True or False: The proliferation of big data and the drivers behind using big data is due to the technologies available today to collect data from various structured and unstructured sources. Competition among the companies is not a reason for the proliferation of big data

False

True or False: When the data is collected at the same or approximately the same point in time, i.e., collected only once, it is called as time-series data.

False

True or False:A primary key is non-unique identifier of a record in the table.

False

When you are creating tables in the database during schema creation stage of your database management project, you should not create queries for table creation. One of the uses of queries you noted in this course is that they are pre-defined by users and display data by creating a view on the main data table. Queries are good for repetitive usage to display data. Hence, it is not a good practice to use them for table creation which is data definition language (DML) based activity you execute in the beginning. It is better to always stay away from table level operations using queries. Note: We discussed about source tables in Excel, Tableau, SQL and Access. True/False

False

_____________________ is the result of processing raw data to reveal its meaning.

Information

After graduation ceremonies at a university, six graduates were asked whether they were in favor of (identified by 1) or against (identified by 0) abortion. Some information about these graduates is shown below. Are arithmetic operations appropriate for the variable "abortion issue"?

No

After graduation ceremonies at a university, six graduates were asked whether they were in favor of (identified by 1) or against (identified by 0) abortion. Some information about these graduates is shown below. Which measurement of scale is used for the sex variable?

Nominal

Which measurement of scale is used for the identification number variable?

Nominal

Which measurement of scale is used for the class rank variable?

Ordinal

Which measurement of scale is used for the classification variable?

Ordinal

In the practice examples, you were searching for records matching a criteria you specified. You searched for Bingham or Bing by hard coding the search criteria into the SQL statement. You have also seen another example where you did it differently to allow the system to show a dialog box for you to enter an input and search by the input which was more flexible. It is like keyword search in Google to act on that column of information. When doing this activity, you were using the feature of MS-Access which is ________________________________

Parameter query

The highway patrol is interested in determining the average speed of all automobiles traveling on interstate 75. To accomplish this task, the speed of every tenth car passing a particular point on interstate 75 is recorded. Is speed a categorical or a quantitative variable?

Quantitative

A_______________helps to view, format and summarize information in your database. A. Attribute B. Query C. Report D. Field

Report

A recent issue of Fortune Magazine reported that the following companies had the lowest sales per employee among the Fortune 500 companies. Company Sales per Employee (In $1,000s) Sales Rank Seagate Technology 42.20 285 SSMC 42.19 414 Russel 41.99 480 Maxxam 40.88 485 Dibrell Brothers 22.56 470 Which variable is the categorical variable in the above dataset?

Sales Rank

A recent issue of Fortune Magazine reported that the following companies had the lowest sales per employee among the Fortune 500 companies. Company Sales per Employee (In $1,000s) Sales Rank Seagate Technology 42.20 285 SSMC 42.19 414 Russel 41.99 480 Maxxam 40.88 485 Dibrell Brothers 22.56 470 Which variable is the quantitative variable in the above dataset?

Sales per Employee

True or False: A business process is a sequence of activities in organizations triggered by some event and to produce desired outcomes

True

True or False: The primary focus of ERP systems is to integrate with partners and customers

True

True or False: When data storage characteristics are changed without affecting the program's ability to access data, it is called data independence

True

The ________ clause is used to list the attributes desired in the result of a query. a) Where b) Select c) From d) Distinct

b) Select

The query given below will not give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name, dept name, salary * 1.1 WHERE instructor; a) Salary*1.1 b) ID c) Where d) Instructor

c) Where

The_________________________ SQL command defines the portion of database owned by the particular user.

create schema

From the examples you executed in the class, a query can display data from one and only one table in an ordered manner based on the question pre-defined by the user. To retrieve data from multiple tables using the keys and relationships, you need to create a parameter query. This parameter query helps to connect across multiple tables, pre-define the question and take advantage of created table connections to retrieve answers to the question. true/false

false

You know that a primary key is not mandatory but recommended per the best practices in database design. Let us say you created two tables - Table 1 and Table 2. The foreign key in Table 2 always references Table 1. It is acceptable to define the foreign key column in Table 2 without NOT NULL constraint. It is enough if the primary key column in Table 2 is defined with NOT NULL constraint. However, because the tables are connected, it is mandatory that any primary keys and foreign keys in Table 1 should be NOT NULL because Table 2 depends on Table 1. True/False

false

A_____________________database is a type of database that stores information in multiple tables but appears to the user as if it is getting data only from one table.

relational

In the database tables, latest records of the incoming data will be found at the bottom of the tables. true/false

true