(Value ofIT)

Q1. Select all that applies: Which of the following is considered a key component of Information Systems?

A) Hardware

B)  Marketing strategies

C)  Financial statements

D) Human resources management

E)  Data

F)  Business practices

G) Infrastructure

H) None of the above

Q2. True or False: Since information systems share key components, they essentially play the same role for all companies.

Answer: False

Q3. Fill in thefollowing blanks (Two blanks have different answers): A/an _____________         refers to various business activities and processes involved in creating a product or performing a service. By analyzing each activity that organizations engage in order to create value, we can use it to pinpoint the main ____________ for them and identify opportunities for competitive            advantage.

Q4: True or False; When a firm decides to adopt an information technology, it is due to strategic necessity in surviving among competitors.

Answer: False

Q5. Select all that applies: What is not the role or value of IT at a stock exchange?

A) Enabling stock transactions

B)  Ensuring high speed of the financial market

C) Limiting the liquidity of the financial market

D) Providing market information to individuals and institutions

E)  Leasing technology services and sells data solutions to other companies.

(Technical Foundations Part 1)

Q6. Short answer: Please convert the following decimal number to a binary number.

627

Answer: 1001110011

Q7. Short answer: Referring to the  following binary character table, please convert the following binary code to characters: 01001100011011110111011001100101

Answer: Love

Q8. Select one: How much hard drive memory (in Bit) is required to store “The Hobbit” movie? We assume the following.

➔ Resolution: 5120 x 2880 pixels

➔ 48 fps

➔ 2h 50 minutes long

➔ Color Depth: 16 bit

A)  1.15×1014

B)  6.79×1011

C)  1. 15×1013

D) 6.79×1010

E)  1. 15×1012

Q9. Short answer: How many colors can be represented in a 8-bit color depth image?

Answer: 256

Q10. Fill in the blank: The reason why computers represent information in binary codes is fundamentally because of the building blocks of digital circuits, called ________,  in computers that can only represent on and off states.

Answer: transistors

Q11. Select all that applies: Which of the following is not the reason why Moore’s law has been so accurate?

A) It acts as a coordination device for the technology industry

B)  Moore found a generalizable pattern of growth in number of transistors in a chip

C)  For the developers of related technology, they can predict ahead how much computing power they will have when launching a functionality

D) Microchips manufacturers can ensure that there will be a market for their new chip

E)  It was empirically found and tested to be true

Q12. Select one: Which of the following statements best describes the difference between an algorithm and a program?

A) An algorithm is a set of instructions that computers understand, while a program is a step-by-step blueprint that humans can read.

B)  An algorithm is a step-by-step blueprint that humans can read, while a program is a set of instructions that computers understand.

C)  An algorithm and a program are interchangeable terms for the same concept.

D) An algorithm is a visual representation of a program, while a program is the actual implementation of the algorithm.

(Database)

Q13. Select one: The following diagram represents an ER model for the TV show watching data in Hulu. Please select the appropriate cardinality (such as m, n, 1) for the model,

Q14. Fill in the blank: For 1:N cardinality relationship, post the primary key from the “one” side as a/an _________ to the “many” side in the table representing relationships.

Answer: attribute

Q15. True orfalse: A M:N relationship can be converted into multiple 1:N relationships in an ER model.

Answer: True

Q16. Short answer: What type of database is the following prompt describing?

This type of database organizes and stores data in a structured manner using tables, composed of rows and columns. It is based on a conceptual framework proposed by E.F. Codd in the 1970s, it has become the foundation for modern database management systems. In such a database, data is stored in tables, where each table represents a specific entity or relationships in an ER model. By having multiple tables instead of one, it minimizes the waste in computing space and time,          information loss when deleting specific rows, and error rates when modifying information.

Answer: relational database

Q17. Short answer: Based on the following table representing a database of enrollment of       students in 2023 Summer courses, select the appropriate cardinality of the ER model. (Assume the instructor only teaches one class per semester.)

(a) Student - Class

(b) Class - Instructor

Answer: (a) m:n, (b) 1:1

(SQL)

Q18. Short answer: What would be the number of cells in the view of the following queries in the database?

Original data:

Query:

Select songs that had more than 300 hours of streaming and project ‘Song Title’ and ‘Singer’

Answer: 10

Q19. Select one: What is the appropriate expression for the blank in the following SQL statements to select all fields in the Products table?

SELECT ________

FROM Products

A) All

B)  *

C)  Fields D)

E)  None of the above

Q20. Short answer: Add one more line to the following SQL statements to select ‘ProductID’ for products with prices higher than $5 and lower than $10.

SELECT ProductID

FROM Products

Answer: WHERE Price < 10 AND Price > 5

Q21. Select one: Select the correct SQL statements to create a new column named                    “InflatedPrice”, where multiplies 1.05 to the “Price” column, and add it to the existing Product table.

A)  SELECT Price * 1.05,  InflatedPrice FROM Products

B)  SELECT Price * 1.05 AS InflatedPrice FROM Products

C)  SELECT *,  Price * 1.05 = InflatedPrice FROM Products

D) SELECT *, Price * 1.05 AS InflatedPrice FROM Products

E)  None of the above