9. You have decided to delete doctors that contained the name ‘John’ in their name. You have a function in the lib schema called item_remove where the first item in the function is the table and the second item is the provider_id. Write a shell script that will connect to the database and loop through the provider_id into the function.
Describe a project you're proud of
What is your weakness point
If you have a raw dataset, what will you do? Explain how are the steps your programming skill applies on this dataset.
How will you predict if i ask you how many people are going to wear red T-shirt on a following day in New York city.
How do you deal with missing data?
How is CNN different from other neural networks? When would you use it?
Given Email-id of the sender, location, timestamp, id, subject of the mail and mail content. Come up with a way to appropriately classify mails as Spam or No-Spam. Labels for the dataset is given(Supervised). How will you vectorize the input? Also write code for classification algorithm. How would you use sender's id, location and timestamp to your benefit?
SQL: select, different join, not in, is not null; What will you do if you don't know/not sure about something?
There was a fun SQL question on Mario kart
Viewing 921 - 930 interview questions