ISYS 2263 - Test 2 SQL & MS Access (Practice Exam & Quiz)

A primary key is non-unique identifier of a record in the table. (T/F) (*SQL*)

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. (T/F) (*SQL*)

False

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

False

ERP is beneficial because it integrates information but the downside is that it does not eliminate stand-alone functional systems. (T/F)

False

In MS-Access, a query you build can display BOTH detail and summary information simultaneously. (T/F) (*SQL*)

False

In experimental studies, the variable of interest is not controlled.(T/F)

False

The primary focus of ERP systems is to integrate with partners and customers (T/F)

True

When data storage characteristics are changed without affecting the program's ability to access data, it is called data independence. (T/F)

True

When creating a database, which of the following are valid questions you need to ask?(*SQL*) Answers: 1. Do the fields need to have domains? 2. What are the data types? 3. Are there any other constraints? 4. What are the tables and fields in tables? 5. Which forms will I create? 6. What is the schema? 7. What queries will I build? 8. Which reports will I create?

1. Do the fields need to have domains? 2. What are the data types? 3. Are there any other constraints? 4. What are the tables and fields in tables? 6. What is the schema?

Which of the following is TRUE about INSERT statement? (*SQL*) 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

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 of this survey?

2,000 college students

Which of the following is TRUE about the SQL code snippet? (*SQL*) 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)); Answers: 1. It contains one primary key and one foreign key 2. The OrderLine table is linked to two other tables 3. It creates 6 columns in the database table 4. It contains one foreign key to link to other tables 5. A constraint is required on ProductID.

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

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

3. It sorts rows by Country and then by CustomerName

Which of the following are (more than one) true about the following code?(*SQL*) CREATE VIEW [Current Product List] As SELECT ProductID, ProductName FROM Products WHERE Discontinued = No; Answers: 1. The CREATE statement of SQL creates new tables in the database based on successful execution of the code 2. The code will execute to fetch results from the ProductID and ProductName tables in the database 3. The data fetched by the execution works based on two columns in the database 4. It creates a dynamic subset of rows and columns based on matching the criteria 5. The WHERE command helps to select and display all discontinued products

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

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); Answers: 1. The WHERE command selects the columns based on conditional expression 2. It selects a few columns from the Customer table and a few columns from the Orders table and filters them 3. CustomerID is the primary key in the Orders table being used to join two tables i.e. Customers and Orders 4. It selects all columns from the Customer table as well as the Orders table and filters them 5. CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

4. It selects all columns from the Customer table as well as the Orders table and filters them 5. CustomerID is the foreign key in the Orders table being used to join two tables i.e. Customers and Orders

In a table,__________________________is a range of possible values a field can take. Note that field means column in Access terminology. (*SQL*) A. Domain B. Choice Set C. Choice Options D. Range

A. Domain

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

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

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

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

A. Like "704*"

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

A. Production Planning E. 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: (*SQL*) A. Referential Integrity B. Relational Integrity C. Relational database D. Connective Query

A. Referential Integrity

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

A. Structured (*SQL*)

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

A. data type

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 of the following is a critical success factor of ERP implementation? Answers: 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

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 occuring 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

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 interstate 75

The database structure in a DBMS is stored as a ____. A. file B. collection of files C. collection of queries D. set of key/value pairs

B. Collection of Files

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

B. Data Inconsistency

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.(*SQL*) A. Category B. Field C. View D. Query

B. Field (Column)

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

B. Nominal

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

B. Observations

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

B. Report

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

B. Rows

A ___________________is a storage container for data.(*SQL*) A. Query B. Table C. View D. Report

B. Table

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? (*SQL*) A. top values query B. parameter query C. crosstab query D. pattern match query

B. parameter query

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

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

A ____ is a collection of related records. A. database B. field C. file D. column

C. File

To distinguish one row i.e. one record from another, tables contain:(*SQL*) A. One-to-One relationships B. Existence dependence C. Primary Key D. Referential Integrity

C. Primary Key

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

C. Staffing is not expensive in ERP implementations

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

C. This is a DML statement

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 management system C. database system D. management system

C. database system

A workgroup database is a(n)____ database. A. single-user B. distributed C. multiuser D. enterprise

C. multiuser

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

C. raw facts of interest to the end-user

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

CREATE SCHEMA

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. Integrated Information and Clear Visibility of Information C. Inter-organizational Systems Support 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. (*SQL*) A. AVERAGE B. SUM C. MAX D. COUNT

D. COUNT

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

D. Enterprise Resource Planning

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

Which of the following is not true about ERP? Answers: 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

Know "ELEMENTS" definition

Elements Definition

Which of the following is false about enterprise systems?

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

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

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. (T/F) (*SQL*)

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

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.(T/F)

False

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

Information or info

Identification Numbers: 1234, 8978, 6578, 2345, etc.... Which measurement of scale is used for the identification number variable?

Nominal

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

Nominal

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. (Class rank: 1,2,3,20,4,8) Which measurement of scale is used for the class rank variable?

Ordinal

Which measurement of scale is used for the classification variable? (Senior, Junior, Sophomore, Freshman)

Ordinal

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 quantitative variable?

Quantitative Variable

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.(*SQL*)

Relative

SQL - MS Access

SQL - MS Access

A business process is a sequence of activities in organizations triggered by some event and to produce desired outcomes(T/F)

True

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

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? Answers: a. create purchase requisition b. create and send purchase order c. receive invoice d. send payment e. none of these

c. receive invoice

Which one of the following is not a result of investing in an enterprise system? Answers: 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 of the following is not a challenge in implementing ERP? Answers: 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