MIS 301H Final Questions and Answers 2024
1. What is a database? Why do people use a database?: A single table or a collection of related tables
2. What is relational database? Understand the meaning of the following terms in relational database context:
records, attributes, fields. What are the require- ments for a table in relational database?: Relational Database:
Tables related based on common keys
i. Records: rows in a table
ii. Attributes: columns in a table
iii.Fields: columns in a table
3. What is primary key? What is the difference between simple primary key and composite primary key?
When given a table and certain assumptions, understand how to identify primary key.: An attribute or set of
attributes that uniquely identifies each row of the relation in question.
- simple primary key: only one attribute is needed to uniquely identify each record
- composite primary key: when more than one attribute is needed to uniquely identify each record
4. What is foreign key? When given a set of tables and certain assumptions, understand how to identify foreign
key.: - An attribute or set of attributes in a relation of a database that serves as the primary key of another relation in the
same database. Helps linking different relations (tables) in a relational database.
- Acts as the primary key in a different table in order to help you find data
5. What is SQL?: Structured Query Language
- To retrieve information from the database - run a query on the database
- International standard language
6. Know the order of SELECT, FROM, WHERE in SQL statement: SELECT [DISTINCT] column_list
1. FROM table_list
2. [WHERE conditional expression]
7. Understand the meaning of Comparison operators, Boolean operators, BE- TWEEN... AND..., In (... , ...)
operators.: Comparison operators: <, >, =
- returns record if the condition is met Boolean
1/
16
, MIS 301H Final Questions and Answers 2024
Operators: AND, OR
- AND: returns record if both conditions are met
- OR: returns record if one of the conditions is met BETWEEN
- returns records within a range of values
2/
16
, MIS 301H Final Questions and Answers 2024
IN (... , ...)
- ???
8. What is ERP? What is CRM? What is SCM? Understand what each of these enterprise systems basically
does.: - ERP: Enterprise Resource Planning
- CRM: Customer Relationship Management
- SCM: Supply Chain Management
9. What is cloud computing? What are the essential characteristics of cloud computing?:
10.What is IaaS? For this service model, what are the resources the cloud vendor will provide/manage and
what are the resources the cloud user will have a control? What basic question is it essentially addressing for a
cloud user?: - IaaS: Infrastructure as a Service
- Customer: "I need a server" (raw processing power and/or storage)
11.What is PaaS? For this service model, what are the resources the cloud vendor will provide/manage and
what are the resources the cloud user will have a control? What basic question is it essentially addressing for a
cloud user?: - PaaS: Platform as a Service
- Customer: "I have developed or acquired an app, I need a place to run it."
12.What is SaaS? For this service model, what are the resources the cloud vendor will provide/manage? What
basic question is it essentially addressing for a cloud user? Know that the cloud user will usually not manage or
control the cloud infrastructure, operating systems, and even individual application capabilities, except for
limited user-specific configuration settings.: - SaaS: Software as a Service
- Customer: "I want access to the software app via my thin client interface (e.g., Web browser)"
13. What are the benefits to users from cloud computing? What are the barriers to cloud computing
adoption? When you decide if you want to get service from a particular cloud vendor, why should you consider the
long-term viability of the cloud vendor?:
14.Suppose now your company wants to adopt an enterprise software appli- cation (e.g., CRM, ERP) and you
have two options - buying some packaged enterprise software or using software-as-a-service model (i.e. getting
on-de- mand enterprise software). What are the benefits of buying the packaged one and what are the benefits of
getting the on-demand one? Understand how the size of your organization affects your choice.:
15.What are the benefits faced by IT vendors in offering cloud computing?: -
3/
16
1. What is a database? Why do people use a database?: A single table or a collection of related tables
2. What is relational database? Understand the meaning of the following terms in relational database context:
records, attributes, fields. What are the require- ments for a table in relational database?: Relational Database:
Tables related based on common keys
i. Records: rows in a table
ii. Attributes: columns in a table
iii.Fields: columns in a table
3. What is primary key? What is the difference between simple primary key and composite primary key?
When given a table and certain assumptions, understand how to identify primary key.: An attribute or set of
attributes that uniquely identifies each row of the relation in question.
- simple primary key: only one attribute is needed to uniquely identify each record
- composite primary key: when more than one attribute is needed to uniquely identify each record
4. What is foreign key? When given a set of tables and certain assumptions, understand how to identify foreign
key.: - An attribute or set of attributes in a relation of a database that serves as the primary key of another relation in the
same database. Helps linking different relations (tables) in a relational database.
- Acts as the primary key in a different table in order to help you find data
5. What is SQL?: Structured Query Language
- To retrieve information from the database - run a query on the database
- International standard language
6. Know the order of SELECT, FROM, WHERE in SQL statement: SELECT [DISTINCT] column_list
1. FROM table_list
2. [WHERE conditional expression]
7. Understand the meaning of Comparison operators, Boolean operators, BE- TWEEN... AND..., In (... , ...)
operators.: Comparison operators: <, >, =
- returns record if the condition is met Boolean
1/
16
, MIS 301H Final Questions and Answers 2024
Operators: AND, OR
- AND: returns record if both conditions are met
- OR: returns record if one of the conditions is met BETWEEN
- returns records within a range of values
2/
16
, MIS 301H Final Questions and Answers 2024
IN (... , ...)
- ???
8. What is ERP? What is CRM? What is SCM? Understand what each of these enterprise systems basically
does.: - ERP: Enterprise Resource Planning
- CRM: Customer Relationship Management
- SCM: Supply Chain Management
9. What is cloud computing? What are the essential characteristics of cloud computing?:
10.What is IaaS? For this service model, what are the resources the cloud vendor will provide/manage and
what are the resources the cloud user will have a control? What basic question is it essentially addressing for a
cloud user?: - IaaS: Infrastructure as a Service
- Customer: "I need a server" (raw processing power and/or storage)
11.What is PaaS? For this service model, what are the resources the cloud vendor will provide/manage and
what are the resources the cloud user will have a control? What basic question is it essentially addressing for a
cloud user?: - PaaS: Platform as a Service
- Customer: "I have developed or acquired an app, I need a place to run it."
12.What is SaaS? For this service model, what are the resources the cloud vendor will provide/manage? What
basic question is it essentially addressing for a cloud user? Know that the cloud user will usually not manage or
control the cloud infrastructure, operating systems, and even individual application capabilities, except for
limited user-specific configuration settings.: - SaaS: Software as a Service
- Customer: "I want access to the software app via my thin client interface (e.g., Web browser)"
13. What are the benefits to users from cloud computing? What are the barriers to cloud computing
adoption? When you decide if you want to get service from a particular cloud vendor, why should you consider the
long-term viability of the cloud vendor?:
14.Suppose now your company wants to adopt an enterprise software appli- cation (e.g., CRM, ERP) and you
have two options - buying some packaged enterprise software or using software-as-a-service model (i.e. getting
on-de- mand enterprise software). What are the benefits of buying the packaged one and what are the benefits of
getting the on-demand one? Understand how the size of your organization affects your choice.:
15.What are the benefits faced by IT vendors in offering cloud computing?: -
3/
16
