Sql Developer I Interview Questions

1,521 sql developer i 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 481 - 490 interview questions

Glassdoor has 1,521 interview questions and reports from Sql developer i interviews. Prepare for your interview. Get hired. Love your job.