sql developer interview questions shared by candidates
If I knew what the cross apply operator was
I gave a description of the cross apply operator
If they want the word its join, a description could be "the Cartesian product of multiplying the tables" and an example would be "like merging two matrices except every column may be of incongruent variables creating a result with polynomial rows, (which is likely no longer normalized to the form level of the database)"
An Apply operator is a join type that the DB engine evaluates in sequential order because the right-hand table object can reference data in the left-hand table object. The Cross Apply operator is the Apply operator that acts like an Inner Join, eliminating any records in the left-hand table object that have a null match in the right-hand table object.
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??
See Interview Questions for Similar Jobs
- SQL Developer
- Software Engineer
- Data Analyst
- Business Analyst
- Database Developer
- Database Administrator
- Software Developer
- Senior Software Engineer
- Business Intelligence
- SQL Server Database Administrator
- Project Manager
- Java Developer
- Vice President
- Data Architect
- Programmer Analyst
- Research Analyst