Interview Questions

Julien C. - "👇 Your feedback is very much appreciated 👇 Clarifying Questions Should we look at it worldwide or in the USA only? Should we consider all Slack messages? ones that are sent in business-owned workspaces? ones that are sent in other types of communities? We'll give numbers for this scope: worldwide all messages Approach: Nb of users x Nb messages sent by user per hour x Nb hours worked per day Nb of users: 10M Nb of messages per hour: 10 Nb of hours worked per day: 8 So an"See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Srilaxmi C. - "Alright kiddo, imagine you have a big box of LEGO bricks. Each brick is like a tiny tool that helps you build something special. Now, think about a game you love to play on your computer or phone. The people who make those games want to help other people make things that work with their games, like new levels or characters. So, they create something called an "SDK," which stands for "Software Development Kit." This is like a special set of LEGO bricks and instructions that they share with other"See full answer

P D. - " Summary of chapter for students to enable quick learning for revision Summary of books for readers so that they can make better decision to choose the book Summary of vedas to easily understand and teach the religious texts Summary of news articles for readers to quickly review the articles and then deep dive into specific topic Summarizing the legal documents for users to understand easily and ensure the authenticity and correctness of the documents Summarize research reports and s"See full answer

Mision veterans ministry B. - "The answer to this question will give valuable insight to a persons kharma/ energy/ motivation"See full answer

Jayveer S. - "WITH suspicious_transactions AS ( SELECT c.first_name, c.last_name, t.receipt_number, COUNT(t.receiptnumber) OVER (PARTITION BY c.customerid) AS noofoffences FROM customers c JOIN transactions t ON c.customerid = t.customerid WHERE t.receipt_number LIKE '%999%' OR t.receipt_number LIKE '%1234%' OR t.receipt_number LIKE '%XYZ%' ) SELECT first_name, last_name, receipt_number, noofoffences FROM suspicious_transactions WHERE noofoffences >= 2;"See full answer