ISYS 2263 Test #2

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

False

A query can display data from one and only one table in an ordered manner based on the question pre-defined by the user. True False

False

DELETE TABLE FROM CUSTOMERORDERS_T is one Command which completely removes a table from your table schema that you created earlier. True False

False

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

False

In MS-Access, a query you build can display BOTH detail and summary information simultaneously. True False

False

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

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

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

True

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

True

The WHERE Command restricts the selection of_______________based on a conditional expression Rows Columns Values Primary Keys

Rows

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

Table

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. a. What is the sample in this survey?

2,000 college students

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. sex age abortion issue class rank f 30 1 232 m 22 1 118 f 14 0 403 f 34 1 167 m 28 1 45 a. 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. a. Based on the sample, what percentage of the population would you think have no opinion on the subject?

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. a. 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

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? Inter-organizational Systems Support Integrated Information and Clear Visibility of Information Compliance Audit Trail

Audit Trail

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

Business Analytics tools

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

COUNT

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

CREATE SCHEMA

__________________exists when different versions of the same data appear in different places. 1. Data quality 2. Data inconsistency 3. Data integrity 4. Data security

Data inconsistency

When creating a database, which of the following are valid questions you need to ask? Do the fields need to have domains? What are the data types? What queries will I build? Which forms will I create? Which reports will I create? What is the schema? Are there any other constraints? What are the tables and fields in tables?

Do the fields need to have domains? What are the data types? What is the schema? Are there any other constraints? What are the tables and fields in tables?

In a table,__________________________is a range of possible values a field can take. Note that field means column in Access terminology. Choice Options Range Domain Choice Set

Domain

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

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

ERP is more of a technical change

ERP is an acronym for ________________. a. Everyone Resource Projects b. Excellent Requirements Planning c. Enterprise Requirements Projects d. Enterprise Resource Planning

Enterprise Resource Planning

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

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

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

Failure to involve affected employees

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 are dropping tables from a database, the order of dropping is not a consideration because you anyway decided to drop some of the irrelevant tables from your original schema because they are not helpful for your analysis. True False

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. True False

False

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

Field

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

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

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

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

Which of the following is true about the given SQL code? SELECT * FROM customers WHERE EXISTS (SELECT * FROM orders WHERE customers.customer_id = orders.customer_id); CustomerID is the primary key in the Orders table being used to join two tables i.e. Customers and Orders The WHERE command selects the columns based on conditional expression It selects a few columns from the Customer table and a few columns from the Orders table and filters them It selects all columns from the Customer table as well as the Orders table and filters them CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

It selects a few columns from the Customer table and a few columns from the Orders table and filters them CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

Which of the following is TRUE about the following SQL code? SELECT * FROM Customers ORDER BY Country ASC, CustomerName DESC; It sorts columns by Country and then by CustomerName It displays data from only the Country and CustomerName columns It sorts rows by Country and then by CustomerName It operates on the Customer and Country Tables

It sorts rows by Country and then by CustomerName

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. CONCATENATE MERGE COMBINE JOIN

JOIN

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces. Find "704*" Like "704*" Like *704* IfequaltoorLike (704*)

Like "704*"

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

Management Accounting

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

Nominal

The set of measurements (values) collected for a particular element is called: Metrics Observations Records Variables

Observations

To distinguish one row i.e. one record from another, tables contain: Primary Key Referential Integrity One-to-One relationships Existence dependence

Primary Key

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

Processes are no longer visible and stay hidden

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

Production Planning Sales and Distribution

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: Relational database Relational Integrity Referential Integrity Connective Query

Referential Integrity

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

Report

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

Silo effect

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

Staffing is not expensive in ERP implementations

____ data are the result of formatting to facilitate storage, use and generation of information. a. Historical b. Semistructured c. Structured d. Unstructured

Structured

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)); The OrderLine table is linked to two other tables It creates 6 columns in the database table A constraint is required on ProductID. It contains one foreign key to link to other tables It contains one primary key and one foreign key

The OrderLine table is linked to two other tables A constraint is required on ProductID.

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; The data fetched by the execution works based on two columns in the database The WHERE command helps to select and display all discontinued products The code will execute to fetch results from the ProductID and ProductName tables in the database The CREATE statement of SQL creates new tables in the database based on successful execution of the code It creates a dynamic subset of rows and columns based on matching the criteria

The data fetched by the execution works based on two columns in the database It creates a dynamic subset of rows and columns based on matching the criteria

Which of the following is false about the SQL statement below? CREATE TABLE inventory ( INV_ID INTEGER INV_OPER_ID VARCHAR(30) ); It creates two column table in the database This is not a valid SQL code This is a DML statement The data types defined have no issues

This is a DML statement

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

True

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

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

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. a. What is the population for this study (all automobiles traveling on interstate 75 or every tenth car)?

all automobiles traveling on interstate 75

The database structure in a DBMS is stored as a ____. a. file b. collection of queries c. set of key/value pairs d. collection of files

collection of files

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

data type

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. database management b. database system c. management system d. database management system

database system

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. a. What constitutes the sample (all automobiles traveling on interstate 75 or every tenth car)?

every tenth car

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

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. True False

false

A ____ is a collection of related records. a. file b. field c. column d. database

file

Accurate, relevant, and timely information is the key to ____. a. knowledge b. good decision making c. understanding d. data management

good decision making

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

information

A workgroup database is a(n)____ database. a. multiuser b. single-user c. enterprise d. distributed

multiuser

abortion issue 1 1 0 1 0 Are arithmetic operations appropriate for the variable "abortion issue"?

no

The following information regarding a sample of seven students is provided. identification number 1234 2942 4848 2946 7876 Which measurement of scale is used for the identification number variable?

nominal

sex M F M M F M Which measurement of scale is used for the sex variable?

nominal

class rank 1 2 80 23 18 Which measurement of scale is used for the class rank variable?

ordinal

classification junior senior freshmen freshmen senior sophomore Which measurement of scale is used for the classification variable?

ordinal

Carlos has developed a database for his organic farm. The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants. Carlos would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run. Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs? top values query crosstab query parameter query pattern match query

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. a. Is speed a categorical or a quantitative variable?

quantitative variable

End-user data is ____. a. raw facts of interest to the end-user b. raw facts about the end-user c. accurate, relevant and timely information d. data about data

raw facts of interest to the end-user

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

receive invoice

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

request production

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

strong leadership