It Infrastructure Manager Interview Questions

7,677 it infrastructure manager interview questions shared by candidates

Suppose you are managing an e-commerce database for a company that sells products globally. The company's database schema includes multiple tables: Orders, Customers, Products, and OrderDetails. Your task is to extract information about orders that were placed for a specific product category, within a certain price range, and between two specific dates. Additionally, you need to include customer information and handle translations for product names. Database Schema: Orders: OrderID (Primary Key) CustomerID (Foreign Key) OrderDate Customers: CustomerID (Primary Key) CustomerName Country Products: ProductID (Primary Key) ProductName_EN (Product name in English) ProductName_FR (Product name in French) CategoryID (Foreign Key) UnitPrice OrderDetails: OrderDetailID (Primary Key) OrderID (Foreign Key) ProductID (Foreign Key) Quantity Question: Write an SQL query to retrieve the following information: OrderID, OrderDate, CustomerName, Country, ProductName (in English), UnitPrice, and TotalPrice (Quantity * UnitPrice) for orders placed for products in the 'Electronics' category, with a UnitPrice between £500 and £1000, and OrderDate between 1st January 2023 and 31st March 2023. Ensure that you handle translations for the product names, displaying them in English. If a product name is not available in English, display the French name. Include all orders, even if there are no details (i.e., use LEFT JOIN).
avatar

IT Manager

Interviewed at AutoRek

3.7
Mar 27, 2024

Suppose you are managing an e-commerce database for a company that sells products globally. The company's database schema includes multiple tables: Orders, Customers, Products, and OrderDetails. Your task is to extract information about orders that were placed for a specific product category, within a certain price range, and between two specific dates. Additionally, you need to include customer information and handle translations for product names. Database Schema: Orders: OrderID (Primary Key) CustomerID (Foreign Key) OrderDate Customers: CustomerID (Primary Key) CustomerName Country Products: ProductID (Primary Key) ProductName_EN (Product name in English) ProductName_FR (Product name in French) CategoryID (Foreign Key) UnitPrice OrderDetails: OrderDetailID (Primary Key) OrderID (Foreign Key) ProductID (Foreign Key) Quantity Question: Write an SQL query to retrieve the following information: OrderID, OrderDate, CustomerName, Country, ProductName (in English), UnitPrice, and TotalPrice (Quantity * UnitPrice) for orders placed for products in the 'Electronics' category, with a UnitPrice between £500 and £1000, and OrderDate between 1st January 2023 and 31st March 2023. Ensure that you handle translations for the product names, displaying them in English. If a product name is not available in English, display the French name. Include all orders, even if there are no details (i.e., use LEFT JOIN).

Sames as the person before: "Attached is the office seating plan. Please prepare a network build-out plan that includes the following: What data cabling do you want the contractors who are doing the wiring to install during the office build-out? Where do you want what connections? How many? etc. What equipment do we need to buy to get the initial network up and running? Please provide an itemized (list with links if possible) Please note which items (if any) which we’ll be asking the contractors to install for us. Are there scheduling or sequencing constraints the office-manager needs to be aware of with this plan? Please summarize your plan and discuss its considerations as appropriate (vendor choices, price, capacity, and expansion, etc).
avatar

IT Operations Manager

Interviewed at Cockroach Labs

3.6
Jul 16, 2019

Sames as the person before: "Attached is the office seating plan. Please prepare a network build-out plan that includes the following: What data cabling do you want the contractors who are doing the wiring to install during the office build-out? Where do you want what connections? How many? etc. What equipment do we need to buy to get the initial network up and running? Please provide an itemized (list with links if possible) Please note which items (if any) which we’ll be asking the contractors to install for us. Are there scheduling or sequencing constraints the office-manager needs to be aware of with this plan? Please summarize your plan and discuss its considerations as appropriate (vendor choices, price, capacity, and expansion, etc).

Viewing 661 - 670 interview questions

Glassdoor has 7,677 interview questions and reports from It infrastructure manager interviews. Prepare for your interview. Get hired. Love your job.