how do you find compatible for this position
Sql Support Interview Questions
2,216 sql support interview questions shared by candidates
There weren't too many difficult questions.
what is a view,index,syntax of update,delete
1. Basic to intermediate level SQL questions. 2. Performance tuning 3. SQL query-based problem solving
why you want to leave current position
In Python 1) Binary search, binary tree traversal. 2) Reading the data from a file and counting the number of times a word repeated frequently. and finding 5 of the words which are repeated most frequently.
How to optimize slow running query?
If you have a left join with criteria, how does moving criteria in to the where statement change the query?
How does a dirty read differ from snapshot transaction?
If you have a table with a massive amount of records and the table can't change, how would you optimize a query that's taking too long? (This is more about getting results as fast as possible and not pigeon holing the solution to a query.) Assuming the query has been optimized, what else can you do to speed up performance? (Prepare to enter DBA and systems architect territory at this point.)
Viewing 1161 - 1170 interview questions