Technology Midterm
Information system strategies for dealing with competitive forces
Low cost leadership: walmarts continuous replenishment system Product differentiation: google assistant Focus on market niche: hilton's hotels OuQ system Strengthen customer and supplier intimacy : toyota, amazon
Computer hardware platforms
Mainframe: IBM-one vendor Desktop PC's: first computer hardware platform Mobile Computing Devices: second computer hardware platform
Which of the following is NOT a relational DBMS? MongoDB Microsoft Access Oracle Database MySQL
MongoDB
Current trends in computer hardware platform
New mobile digital computing program ex) smartphones, tablets, wearable devices Consumerization of IT ex) BYPD Cloud Computing ex) AWS
Which of the following is NOT one of the disadvantages of BYOD? Technical issues on integrating mobile devices into pre‐existing IT system Need help from the IT department for technical issues on their own devices No need to spend firm funds on the mobile devices Hacking and unauthorized access to firm information
No need to spend firm funds on the mobile devices
__________ is a technology used to analyze and manage big data. NoSQL SQL Microsoft Access Relational DBMS
NoSQL
Data management and storage
Oracle and Microsoft
The logical view of a database __________. Displays the organization and structure of data on the physical storage media Enables users to manipulate the logical structure of the database Allows the creation of supplementary reports Presents data as they would be perceived by end users
Presents data as they would be perceived by end users
Converting raw data into a more meaningful form is called __________. Processing Capturing Inputting Organizing
Processing
Which of the following is NOT one of the benefits from analyzing smartphone location data? Analyzing traffic patterns Facilitating payments Creating targeted advertising Protecting personal data
Protecting personal data
During the pandemic, what were some benefits to working online?
Reduce commuting time. lower overhead cost, increase productivity
The most popular type of DBMS today?
Relational DBMS
Which of the most popular type of DBMS today? Relational DBMS Non-relational DBMS Object-oriented DBMS Hierarchical DBMS
Relational DBMS
__________ means that you accept the potential costs and obligations for the decisions you make. Accountability Liability Responsibility Due process
Responsibility
Operating system platforms
Server operating system: Unix, Linux Client operating systems: MS Windows, Android, IOS
Which of the following industries has the lowest barrier to entry? Airline Solar energy Computer chip Small retailer
Small retailer
What two types of data does Big Data have?
Structured and unstructured
Nowadays many consumers use iPad or Amazon Echo to listen to music instead of using a CD player. This is an example of __________ in Porter's model's competitive forces. Substitute products Suppliers Customers New market entrants
Substitute products
Accountability definition
The mechanism to determine who took action and who is responsible for
Which of the following statements about Porter's competitive forces model is not true? There are many competitors when an industry has very low barriers to entry. The power of customers grows if they can easily switch to a competitor's products and services. Porter's competitive forces model is the most widely used model for understanding competitive advantage. To control pricing and quality more, a firm should have one supplier.
To control pricing and quality more, a firm should have one supplier.
How does Rational DBMS represent data?
Two dimensional tables ex) microsoft access
Which of the following is NOT one of the client operating system? Android Microsoft Windows Google Chrome OS Unix
Unix
What are the 3Vs of big data?
Volume, Variety, Velocity
A case of shipping wars among amazon, fedex, and ups is an example of a firm using information systems to ____
achieve low cost leadership
Information Systems Definition
are interrelated components that collect, process, store and distribute information to support decision making
which of the following is NOT one of the technologies for brick and mortar retailed to compete with online retailers? cloud computing smartphone app object recognition camera digital shelving
cloud computing
The logical view of DBMS presents what?
data as they would be perceived by end users
Capabilities of DBMS
data definition, data dictionary, data manipulation language, report generation
What does DBMS stand for?
database management system
What is the block chain?
distributed database verify transactions with encryption used for financial transactions like bitcoin
firm use____ to converted with consumers and show a greater willfulness to listen to consumers
What are the two candidate ethical principles?
golden rule no free lunch rule
The physical view of DBMS shows data?
how data are actually organized and structured on physical storage media
Which of the following is not one of the major new changes in management information systems? e-commerce expansion organization it innovations management change
organization
Five components of Porter's Model
-Traditional competitors -New market entrants -Substitute products and services -Customers -Suppliers
New Major Change in Management information Systems?
-it innocations: cloud computing AI -new business models: online videos like nertflix -e commerce expansion: youtube -management change: going mobile -changes in firms and organizations: employess taking on multiple roles and collaborating
Five Moral Dimensions of the Information Age
1. Information rights and obligations 2. Property rights and obligations 3. Accountability and control 4. System quality 5. Quality of life
Data Definition
streams of raw facts
What do non relational (NoSQL) databases handle?
the big data
Liability definition
the existence of laws that permit individuals to revolve the damages done to them by other actors, systems, or organizations
What is porters model
the most wilder used model for understanding competitive advantage
During the pandemic, what IT was used
video conferencing tools, high speed internet connection, laptop, tablet, etc
Operations of a Relational DBMS
• select - creates a subset of data • join - combines relational tables • project - creates tables with only the information specified
Responsibility definition
Accepting the potential costs, duties, and obligations for the decisions you make
Firms that allow employees to use their own devices are embracing which of the following? Mobile consolidation BYOD Cloud computing Wearable computing
BYOD
Which of the following is NOT a correct statement about big data? Big data refers solely to extreme volume of data. Big data can reveal more patterns and interesting relationships than smaller data sets. Big data are produced in much larger quantities and much more rapidly than traditional data. Big data is characterized by the 3Vs: volume, variety, and velocity.
Big data refers solely to extreme volume of data.
__________ consists of three different types of services: IaaS, SaaS, and PaaS. Quantum computing Virtualization Consumerization of IT Cloud computing
Cloud computing
IT infrastructure major components?
Computer hardware platform Operating system platforms Data management and storage
Information Technology definition
Consists of all the hardware and software that a firm uses to achieve its business objectives
Which of the following is NOT a correct statement about IT infrastructure? Conventional client operating system is designed by using touch technology . Companies are moving their IT infrastructure to partially rented by external vendors. There are more microprocessor chips vendors for smartphones than those for desktop personal computers. Companies are moving their IT infrastructure to the cloud services.
Conventional client operating system is designed by using touch technology.
Which of the following is NOT a correct statement about cookies? Cookies are installed only at the user's request. Cookies are used to support the user experience on websites. Cookies are stored on the user's computer. Cookies can be combined with other website data to develop detailed profiles of customers.
Cookies are installed only at the user's request.
What are the internets challenges to privacy?
Cookies: small text files saved on your computer, track website visit history, can be installed without the users request Web Beacons: invisibly embedded in email and web page, and keep record of users online click streams
The select operation __________. Combines relational tables to provide the user with more information than is otherwise available Creates a subset consisting of columns in a table Creates a subset consisting of rows in a table that meet stated criteria Identifies the table from which the columns will be selected
Creates a subset consisting of rows in a table that meet stated criteria
Which of the following is NOT a capability of DBMS? Data access language Data definition Data dictionary Data manipulation language
Data access language
DBMS have a(n) __________ because it can add, change, delete, and retrieve the data in the database. Data access language Data manipulation language Report generation Data definition
Data manipulation language
Information data definition
Data that has been shaped into a form that is meaningful and useful to human beings
All of the following are competitive forces in Porter's model except __________. New market entrants Substitute products Disruptive technologies Suppliers
Disruptive technologies
What is the golden rule?
Do unto others as you would have them do unto you
Which of the following is NOT one of the five moral dimensions of the information age? Golden rule System quality Property rights and obligations Information rights and obligations
Golden Rule
IT infrastructure include investment in what?
Hardware, software, and services
Which of the following is a correct statement about the ethical no-free-lunch rule? If something someone else has created is useful to you, it has value, and you should assume the creator wants compensation for this work. One can put values in rank order and understand the consequences of various courses of action. If an action cannot be taken repeatedly, then it is not right to be taken at any time. One should take the action that produces the least harm or incurs the least cost.
If something someone else has created is useful to you, it has value, and you should assume the creator wants compensation for this work.
What is the ethical no free lunch rule?
If something someone else has created is useful to you, you should assume the creator wants compensation for this work.
Three active to produce the information from data
Input: collects raw data Processing: converts raw data into a meaningful form Output: transfers the information to the people
A DBMS acts as a(n) __________ between application programs and the physical data files. Software Relation Logical view Interface
Interface
Which of the following is a challenge of working from home? Employee's commuting time is reduced. Internet service and laptops are necessary. Overhead costs for companies lower. Employees' schedules are more flexible.
Internet service and laptops are necessary.
Which of the following is NOT a correct statement about blockchain database? It enables firms to create and verify transactions on a network very rapidly. Encryption is a key feature of a blockchain database. It enables the ability to use relational databases. It maintains a growing list of transactions shared by all.
It enables the ability to use relational databases.
