Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg PDF

Preview

Summary

its mid-term information you can easily get through your midterm with this piece of information...

Description

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Quiz Submissions - Midterm Aashwath Uppal (username: uppal-a57) Attempt 1 Written: Oct 19, 2020 4:01 PM - Oct 19, 2020 5:17 PM Submission View Your test has been submitted successfully. Question 1 All of the following are functions of a DBMS Except: Data Transformation and Presentation Security Management Backup and Recovery Management Application Programming

Question 2 A tactical system would most likely be used by: The CIO of a company interested in the market trends to decide whether to open a new plant in a specific location A shop floor worker who picks inventory items from the warehouse to fulfill orders A manager who is interested in tracking weekly production A cashier using a Point of Sale System

Question 3 Which of these is the most important element in Information Systems?

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

1/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Centralized Database DBMS Valuable Information Individuals The telecommunication equipment connecting various components Question 4 When considering Data, Information and Knowledge, Knowledge refers to: Raw facts that are known to the user Awareness and understanding of how to use information Set of logically related tasks Collection of facts organized in such a way that they have value beyond the facts themselves

Question 5 Which of these statements below is true? The lower the level of management: The longer term the scope of a decision-making The less routine the manager�s activities The more graphical information used on reports The more detailed information is need to make decisions Question 6 In the table below, how many Characters does Linda's Last name have? FirstName

LastName

Address

Phone

CustomerNumber

James

Brown

78 Smithfield Drive

(214)3566756

645234476

Linda

Foster

23-446 Roman

(214)

245334978

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

2/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Street

4568742

Cameron

Patterson

(423)775996 Blanket Cove 3445

Jordan

Monclova

75 Clearwater street

(214)8745632

358753217

James

Garandall

24-446 Roman Street

(214) 4568742

789452101

886445234

6 1 0 8 5

Question 7 A report which is provided every Monday morning and shows names of only those salespersons that did NOT meet their quotas in the past week is a(n) Ad Hoc Report Exception Report Drill-Down Report Strategic Report

Question 8 What is a database?

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

3/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Software to arrange data on tables A system to manage information An organized collection of Data The location where data is stored

Question 9 The CEO of an organization who needs to see information related to the overall status of the organization in one single screen at any time would find this information in: On demand Report Scheduled Report Drill-down report Dashboard Report

Question 10 What is the purpose of a Query Language in DBMS? Defines each field and record Allows MS Access to build tables Enables the user to build an end user view Schema Used to extract data that satisfy certain criteria from a database Question 11 A DB schema is useful for:

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

4/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Providing access to specific parts of the Database to specific groups of users Normalizing the database Creating queries that allow for the relationships among tables to be accounted for Modeling the three-dimensions of entities

Question 12 Using the table below, if the intended value is “Economics”, which of the SQL statements below should be executed?

SELECT MAJOR FROM STUDENTS WHERE CNO = 1803 SELECT STUDENTS FROM MAJOR WHERE CNO = 1803 SELECT STUDENTS WHERE CNO = 1803 AND MAJOR = "Economics" SELECT CNO FROM MAJOR WHERE MAJOR = “Economics” SELECT CNO FROM STUDENTS WHERE MAJOR AND CNO = 1803

Question 13 In a Data dictionary you would find:

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

5/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

The meaning of the relationships that each of the entity has Information about each of the Database tables and detailed description of the attributes for each table The definition of each of the entities that form the database Information on the type of data stored in the database

Question 14 What does SQL refer to? A Database management system to generate reports System quick links used to define the data dictionary A standard computer language used to provide instructions to a database A Summary quarter Ledger

Question 15 The chart of accounts is: An integrated transaction processing system to feed the general ledger A flowchart modelling all of the transactions in the accounting system All of the entries in the journal for a particular reporting period A categorized list of all the general ledger accounts in the organization

Question 16 Accounting and Finance are considered Functional Areas of the organization. The following statement is:

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

6/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

False – They Can’t be considered functional areas as they are not part of the conversion Cycle of the organization False - They are not functional areas as their main purpose is mainly administrative False – Transactional information managed in these areas is there to support other real functional areas True

Question 17 One of the characteristics of valuable information is "Flexibility" this means that: The system should allow for information to be updated as reality represented by the information changes Information should be stored across multiple locations Anyone in the organization should have the ability to update information The fields containing the characteristics of the entity being represented should be of variable length

Question 18 The following are activities in an information system except: Process information by manipulating, organizing and making calculations on data Classify information according to the level of value it has Provide information to organizational members when required Collect information by providing a way to input information into the system

Question 19

Based on the DB table below, FirstName , Address , Phone , and CustomerNumber are:

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

7/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

FirstName

LastName

Address

James

Brown

Linda

Foster

78 Smithfield Drive 23-446 Roman Street

Cameron

Patterson

Jordan

Monclova

James

Garandall

996 Blanket Cove 75 Clearwater street 24-446 Roman Street

Phone (214)3566756 (214) 4568742 (423)7753445 (214)8745632 (214) 4568742

CustomerNumber 645234476 245334978 886445234 358753217 789452101

Attributes Records Data items Files Entities

Question 20 Which of these statements is NOT true? The higher the level of management: The less routine the manager’s activities The more detailed information is needed to make decisions The longer term the scope of decision-making The more graphical information used on reports

Question 21 The following are characteristics of information needs for decision making at the strategic level except:

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

8/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Emphasis of future perspective of the information Long term perspective of the information needed Significant use of external information High level of detail in the information used

Question 22 Read the scenario below to answer the question:

An employment agency receives work applications on a daily basis. Applicants fill out forms on a computer and click on a button to submit them once done. The agency does not evaluate any applications until the end of the day, when a computer program runs to do profile matching for all the applications for jobs entered during the day, and then determines the type of job a candidate may be suitable for. The type of processing done for this situation is: Manual Processing Batch Processing Automatic Processing Online Processing

Question 23 Which of the following statements is true? The general Ledger is a Strategic system in the area of finance The general ledger captures all the external information required to properly classify accounting transactions The general ledger contains data used to produce financial reports in the company The general ledger prevents the need to adjust entries on Journals

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

9/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Question 24 An ETL (Extract, Transact, Load) process is: A process to create a Database A process to store data into a Data Warehouse A process to create a datamart A process to Normalize a Database A process generate a report

Question 25 For a payroll system an employee “Clocking in” is a transaction. The above statement is: False – Clocking in will not cause any financial changes, so it is not a transaction False – Payroll systems are not transaction processing systems False – Transactions need to be events in the environment, not actual information recorded True – An event that will eventually be causing changes to data is a transaction

Question 26 In the below Table, what would be a "Record"? FirstName

LastName

Address

Phone

James

Brown

78 Smithfield Drive

(214)3566756

645234476

Linda

Foster

23-446 Roman Street

(214) 4568742

245334978

Patterson

(423)775996 Blanket Cove 3445

Cameron

CustomerNumber

886445234

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

10/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Jordan

Monclova

James

Garandall

75 Clearwater street

(214)8745632

358753217

24-446 Roman Street

(214) 4568742

789452101

The First Name, Last Name, Address, Phone Number, and Customer number for a customer The table of customers in a database The collection of Customer Entities stored on this database The Customer Number Having the largest amount of data in the world

Question 27 Ms. Betty George is the Sales manager for Sterling Surgical Supplies Inc (SSSI) and was asked by her CEO to create a report showing the SSSI sales forecast for the next 3 years in all of Europe. IN which managerial level is this report used? Finance Tactical Operational/TPS Strategic Question 28 When we refer to the term Feedback in an information system we are referring too: Information from the system that is used to make changes to input or processing activities Production of useful information, usually in the form of documents and reports Converting data into useful outputs Activity of gathering and capturing raw data Question 29 https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

11/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Which of the following is the correct order (from smallest to biggest)? bit, file, field, Record, Database byte, bit, record, file, database byte, field, file, database character, bit, record, databse bit, record, byte, database Question 30 Where does Big Data Come from? External Sources, Internal Sources, Forecasted Data, Dashboards Artificial Intelligence, Business Intelligence, Strategic Reports, Data Mining Data Warehouses, Data Marts, ETLs, Various Spreadsheets Public Data, Archives, Sensors, Social media, TPS, Machine Logs

Database Modeling Read the following scenario and answer the questions below. The database will contain flight information of an airline . It maintains Information about flights, pilots, and assignments of pilots to flights. Each flight has a unique flight number, a departure city, a destination city, a departure time, and an arrival time. Each pilot has a unique employee ID, a name, and an experience level. Pilots are assigned to certain flights on particular days of the year. A pilot could be assigned to more than one flight in one day. Sample data below: Flight Number 6242 departs Toronto at 8:00 AM, and Arrives in Vancouver at 9:00 AM. Flight 6289 Leaves Winnipeg at 7:55AM, and Arrives in Regina at 8:40AM, and Flight 6254 Leaves Calgary at 8:00AM, and Arrives in Kelowna at 9:15AM. John Johnson (Born May 1st, 1975) is a pilot with 10 Years of Experience, who has been assigned the Flight from Toronto to Vancouver on September 5, 2016. Janice Chow (Born July 18 th, 1977) is a pilot with 8 years of experience who will pilot the plane from Winnipeg to Regina on September 6, 2016, and Fiorella Chielini (Born November 3rd, 1980) has 3 years of experience, and was the captain of flight 6254 on September 7, 2016.

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

12/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Question 31 Which of the following correctly stores the provided data in dababase tables?

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

13/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Question 32 What would a primary Key be for the 1. Pilots, 2. Flights, and 3. Assignments Table? ( in that order) 1. Flight Number, 2. Employee ID, 3.compound PK of Employee, Flight, and Date 1. FlightNo 2. Employee 3. Date 1. FlightNo 2. Flight 3. Pilot 1. Compound PK of Departure and Arrivaltime, 2. Flight 3. FirstName

Question 33 Which the most Appropriate Entity-Relationship Diagram for this?

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

14/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

15/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

Question 34 A worker did not show up for work, so the manager needs to go to the production floor, and perform the activity of scanning all finished products into the system before they are sent to the warehouse. The organizational level in which this activity is performed is: Tactical Human Resources Strategic Manufacturing Operational

Question 35 A ___sql___ includes the name, data type, and length for each attribute in a database Question 36 https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

16/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

The DBMS Function of Transaction Management Refers to: Setting up the transaction processing cycle of data Managing the events that the DBA sets up for the system Allowing for payments to the DBA to be processed Allowing for data entry, updates, deletion

Question 37 The importance of Transaction Processing Systems (TPS) is that They produce reports that managers are able to use at various levels of the organization They support the accounting function of the organization, which is the most important function of a business They allow businesses to automate the decision-making process They capture information at the lowest level of detail, and this is what makes it possible for Tactical and Strategic systems to produce various types of reports

Question 38 Financial Condition formulas such as Cash ratio, Current Ratio, or Operating Ratio would be run in which level of the organization? Strategic Managerial Tactical Operational

Question 39 What is a Compound Primary Key? https://nexus.uwinnipeg.ca/d2l/lms/quizzing/user/quiz submissions attempt.d2l?isprv=0&qi=16590&ai=457080&isInPopup=0&cfql=0&ou=31076

17/24

10/19/2020

: Quiz Submissions - Midterm - Introduction to Information Systems - University of Winnipeg

A unique attribute type used to identify a single instance of an entity An attribute that appears as a non-primary key in one entity and as a primary key attribute in another entity A unique combination of attribute types used to identify a single instance of an entity Specific value of an attribute Question 40 The name, data type, and length for each attribute in a database can be found in: The entity Data Dictionary Data Field A backup of the DB Question 41 When Data is organized in a way that it acquires value beyond the raw facts, it is becomes: Knowledge System Database Information