IT
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Question 1 0 / 3.125 points
The key components of information systems are hardware, software, network, database, and users.
Incorrect Response
True
Correct Answer
False
Question 2 6.25 / 6.25 points
Please match the following choices to benefits or risks of upgrading the operating system for Zara.
__1__
Ongoing support from software vendors
__1__
Cross-store sales and improve customer services
__2__
Change the human-centered culture and DNA
__2__
Transition to the new system leading to disruption
__1__
Platform for future growth to online and global sales
__2__
Investments and ongoing spending on the upgrade
1.
Benefits
2.
Risks
Question 3 6.25 / 6.25 points
Which of the following options accurately describe the role or value of IT at a stock exchange?
Leasing technology services and selling data solutions to other companies
Enabling stock transactions
Limiting the liquidity of the financial market
Providing market information to individuals and institutions
Ensuring high speed and lower cost of the financial market
Question 4 3.125 / 3.125 points
Fill in the blank: The ___structure___ of Zara can be characterized by decentralized decision-making, vertical integration, and human-centered culture.
Question 5 6.25 / 6.25 points
In a newly launched video game, called "Pawfect Pals", users can raise their very own virtual pet. In the game, each virtual pet is unique and can only be assigned to a single owner. Although Basic users can only raise one pet, Premium users can raise up to five pets. If we were to represent this video game with an ER model, what would be the cardinality between the "pets" and "Basic users" and between the "pets" and "Premium users"?
1:1 / M;N
1:1 / N:1
1:N / 1:1
N:1 / M:N
1:N / M:N
Question 6 6.25 / 6.25 points
What is the primary key in the table representing a relationship in the ER model when the relationship has M:N cardinality?
Primary key from the N side
Primary key from the M side
Attributes in the relationship table
Combination of the primary keys from each side
Question 7 6.25 / 6.25 points
The following SQL statements were run on the below "Employee" table.
Employees
Fill in the blanks in the following view table after executing the provided SQL query on the "Employees" table.
Answer for blank # 1: AverageSalary (50 %)
Answer for blank # 2: 2000 (50 %)
Answer for blank # 3: Incorrect Response
(AverageSalary, 2000)
All the correct answers are not displayed for this Multi-Short Answer question.
Question 8 6.25 / 6.25 points
Match the following components for a computer with its descriptions.
__2__
Temporary data storage for keeping the data and applications while the computer is running.
__1__
The actual hardware that interprets and executes software instructions and coordinates how all the other hardware devices work together.
__3__
Permanent data storage for storing information for use at a later time
__5__
A tool we use to see, hear, or otherwise receive the results of information-processing requests.
__4__
A tool used to capture information and commands from the environment.
1.
CPU
2.
RAM
3.
Storage
4.
Input device
5.
Output device
Question 9 6.25 / 6.25 points
Which of the following action plans should be considered immediately after a crash occurring after an IPO? Select all that applies.
Implement ongoing upgrades and testing of the system
Rethink the the culture of the organization
Improve the backup system
Consult with external resources with more expertise
Seek a technical fix in-house
Question 10 3.125 / 6.25 points
A book store is considering two methods to store their book sales data: storing them in a single table and using a relational database. They have a total of 500 books, 100 customers, and 1000 transactions in their sales data.
The first method to store data in a single table will result in a table like the following:
The second method to store data as a relational database will result in three tables like the following:
Please calculate the total number of cells (excluding the row with column names) for each method.
Answer for blank # 1: 35,000,000 Incorrect Response
Answer for blank # 2: 5700 (50 %)
(7000, 5700)
Question 11 3.125 / 3.125 points
Moore's law has been remarkably accurate over the decades due to the empirical observation that the number of transistors in a chip doubles approximately every two years.
True
False
Question 12 0 / 6.25 points
Convert the given sound wave into binary representation. The sample rate is 1Hz, and each time sample should be represented using 4 bits. Skip time=0.
Answer for blank # 1: 10000011011001010001 Incorrect Response
Answer for blank # 2: Incorrect Response
Answer for blank # 3: Incorrect Response
(010100110111011001110011)
All the correct answers are not displayed for this Multi-Short Answer question.
Question 13 6.25 / 6.25 points
How much hard drive memory (in Bytes) is required to store "Cruella" movie? We assume the following.
Resolution: 1960 x 1080 pixels
24 fps
2h 13 minutes long
Color Depth: 30 bit
Choose the answer closest to your calculation.
2.5 x 1011
1.2 x 1012
1.5 x 1012
1.2 x 1013
2.0 x 1012
Question 14 6.25 / 6.25 points
What would be the number of cells in the view of the following queries in the database?
Original data
Song Title
Singer
Album
Hours of streaming
Weeks on Billboard Hot 100
Last Night
Morgan Wallen
One Thing at a Time
340
17
Flowers
Miley Cyrus
Endless Summer Vacation
400
19
Kill Bill
SZA
SOS
454
24
Calm Down
Rema & Selena Gomez
Single
1000
38
Favorite Song
Toosii
NAUJOUR
236
14
Ella Baila Sola
Eslabon Armado X Peso Pluma
Single
98
10
All My Life
Lil Durk feat. J. Cole
Almost Healed
36
2
Query
Select songs that were on the Billboard Hot 100 for less than 15 weeks and project 'Song Title', 'Singer', and 'Hours of streaming'
Answer: 12
Question 15 6.25 / 6.25 points
Finish the following SQL query that retrieves the total number of sales for each product category, sorted in descending order by the sales count, and display the sales count as "TotalSales" in the result. Write in the order of (A), (B), and (C).
Sales
product_id product_name category sale_amount
1 Laptop Electronics 1500
2 Phone Electronics 800
3 TV Electronics 2000
4 Shirt Apparel 500
5 Jeans Apparel 700
6 Shoes Apparel 900
Query:
Answer for blank # 1: AS TotalSales (33.33 %)
Answer for blank # 2: GROUP BY (33.33 %)
Answer for blank # 3: DESC (33.33 %)
Question 16 3.125 / 3.125 points
Fill in the blank: ___vertical___ software is a type of software that can be used for a specific industry, such as a patient scheduling software and a film studio project management software.
Question 17 6.25 / 6.25 points
Imagine you are the owner of a popular ice cream shop called "Scoop & Joy." Your shop offers a variety of ice cream flavors to customers. Each customer can place multiple orders, but each order is associated with only one customer. Customers can buy more than one ice cream at a time.
If we were to represent this with an Entity-Relationship model, what would be the cardinalities between "Customers" and "Orders" and between "Orders" and "Ice cream flavors"?
Answer for blank # 1: 1:N (50 %)
Answer for blank # 2: M:N (50 %)
Question 18 0 / 6.25 points
A local book store is adopting a ERP (enterprise resource planning) system to better manage various aspects of a business, including inventory, track sales, process online orders, and maintain customer databases. The book store is known and loved for its unique book selections which are carefully hand-picked by its staffs every month.
Where would you place the ERP of this bookstore in the IT strategic grid?
Correct Answer
Factory
Strategic
Support Turnaround
2023-06-20