Sql Entwickler Interview Questions

2,209 sql entwickler interview questions shared by candidates

1st round: My query runs slow. What to do? Window function you used before. Given two tables: products -- productid, productname orders -- orderid, productid, quantity, orderdate 1) Write a SP to find the [product name] based on the [product id] input. 2) Write a SP to find the [order id] based on [part of the product name] as input. 3) Orders placed in the month of Feb this year?
avatar

SQL Developer

Interviewed at Perspecta

3.2
Feb 2, 2020

1st round: My query runs slow. What to do? Window function you used before. Given two tables: products -- productid, productname orders -- orderid, productid, quantity, orderdate 1) Write a SP to find the [product name] based on the [product id] input. 2) Write a SP to find the [order id] based on [part of the product name] as input. 3) Orders placed in the month of Feb this year?

Viewing 741 - 750 interview questions

Glassdoor has 2,209 interview questions and reports from Sql entwickler interviews. Prepare for your interview. Get hired. Love your job.