IMDB 2.0 - Movie DB Table Structure Your best friend Betty thinks IMDB is too complicated and challenges you to create a simple movie web site. One page will display movies (with movie name, date it was released, and list of actors). Click on an actor and you're taken to the actor page (with actor name, birthday, bio, and list of movies actor has been in). Please outline the relational table structure of the database for this.
Longest palindromes in a string SQL quesiton
A brain teaser question where we have to find out 45 minutes with the help of two ropes. Given that one rope burns completely in 1 Hr and the rate or burning is not consistent.
Data Modeling: Data Modeling Question for a hypothetical scenario where you have scope to work on your Data Warehousing knowledge. How will you design ETL pipelines for the model? SQL question to display data from your model. Python/SQL questions.
Write a function that returns the square root of a number (obviously without using any sort of built-in square root function).
Given an array [1, 2, 3, 4, 3, 5] and number x, rotate the array such that all occurrences of x are shifted at the end. For example, x = 3, then output should be [1, 2, 4, 5, 3, 3]
They also asked some behavioral questions.
1. Given the sample: id, status 1, active 2, active 3, active 4, pending 5, expired 6, expired 7, expired 8, pending Pull the unique statuses that show up consecutively 3 times, e.g. from the sample, the output would be 'active', 'expired'. 2. Given the sample: employee, in_out, time A, IN, 6:00 B, IN, 7:00 A, OUT, 8:00 C, IN, 9:30 A, IN, 9:00 A, OUT, 10:00 B, OUT, 11:00 C, OUT, 10:00 Determine which employees are in the building at 10:30.
Implement a stack using a Queue
(1) two sums : given a list of numbers, return the indexes of two values whose sum is a given value. (2) Revers a string list
Viewing 1311 - 1320 interview questions