What is the tnsnames?
Senior Sql Developer Interview Questions
58 senior sql developer interview questions shared by candidates
What do you want to build together?
Assume a schema of Emp ( Id, Name, DeptId ) , Dept ( Id, Name). If there are 10 records in the Emp table and 5 records in the Dept table, how many rows will be displayed in the result of the following SQL query: Select * From Emp, Dept Explain what would be your answer?
Qual sua experiência com SQL Server
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??
All Technical Questions.....
What is your notice period.
How do you handle working with difficult people.
The hiring manager asked me some questions about relational vs. Star Schema. He also asked me to review some code and comment on it. I brought code samples with me and talked him though what I’d done and I think that really helped. The users mostly asked me what type of work I did and some general SQL questions, nothing too hard.
What size of company I'd prefer to work for.
Viewing 1 - 10 interview questions