Why did you pursue a career in web development?
Web Operations Interview Questions
4,868 web operations interview questions shared by candidates
Commission Report: Build a page where we can pull a report of all orders that are in the database with the following columns: 1. Invoice: Invoice number of the order 2. Purchaser: Purchaser of the order 3. Distributor: The person who referred the Purchaser. Also known as the Referrer. If the Purchaser’s referrer is not a Distributor, leave this column blank. 4. Referred Distributors: The number of Distributors that the Referrer/Distributor (from the 3rd column) has referred by the �me the order was made. Note that this number gradually increases as the Referrer refers more Distributors over �me. 5. Order Date: Date the order was placed 6. Percentage: Commission percentage that the Distributor (Referrer) will get paid. Note that this is dependent on the number of Referred Distributors he/she has. If the purchaser is not a Customer, the Distributor does not earn a commission. 7. Commission: Percentage x Order Total ● Add a feature that would allow us to filter the result by Order Date and Distributor. Note that the Distributor input box is an autocomplete field. TASK 2 Rank Report: Build a page where we can see the Top 100 Distributors with the most sales. Sales are the total amount of orders that have been purchased by the customers and distributors they have referred. Note that if 2 or more Distributors have achieved the same amount of sales, they would have the same # on the list. PART B REQUIREMENTS: - Programming Language: PHP - Framework: Use Na�ve PHP. Do not use a framework. - DBMS: MySQL - Database Schema: Design your own database model. TASK 3 Build a Registra�on Page that would require a user to submit the following info: ● Name ● Birthdate ● Complete Address ● Profile Picture ● Credit Card Info EXPECTED OUTPUT ● All 3 pages must load in less than 10 seconds. ● All features outlined in the instruc�ons above are working. ● A video demo explaining how to use the 3 tools you’ve built. ● In submi�ng your output, please provide the following files separately: a. Source Codes for Part A (Task 1-2) in a ZIP file b. Source Codes for Part B (Task 3) in a ZIP file c. SQL file used in Part A d. SQL file used in Part B e. Video demo of your Part A output f. Video demo of your Part B output
Why are you interested in this job
Questions were thought-provoking and led to longer conversations.
Algorithms and data structure. System design
Online test questions required knowledge of node traversal, basic search algorithms and some rudimentary knowledge of popular view libraries.
Tell us about yourself and how you’re the perfect fit for this role
Questions about data structure and algorithm, system design and architecture.
Why would you like to join Turing?
"We want to roll back to a previous version of our website. How would you go about moving all of the data from our current site to the previous version?"
Viewing 3501 - 3510 interview questions