They are asking only basics question from SQL and C. Interview proces is very easy prepare only basics of SQL , Group function ,having clause basic query on join. some question related to Date function. what is NVL function.it's took around 20 to 25 minutes .
What are database indexes.
+ Some of the questions were from Spring like dependency injection etc? + Questions from core java, OOPs concept in depth and data structure etc. + Questions on your project, and skills you mentioned in CV. All tricky question
Give a condition related to database and u need to solve it by using pl/sql
how to connect two rows having first name and another last name in a table
1.Have you Worked on Complex queries and how much complex?
Tell me about your work history.
what are joins and stored procedure,cursor.
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
Explain what is Denormalization and why would you use that?
Viewing 71 - 80 interview questions