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.)
Sql Developer Interview Questions
2,211 sql developer interview questions shared by candidates
Easy final interview, was surprised I got an offer
None
How do you add an index to a very large table?
Add a row Delete a row Update a row what is the definition of "table" and "row" arrange in ascending and descending order
Mise en situation, questions de personnalité et intérêt sur la banque et danaine financière.
What is a stored procedure and view?
Sorry I don't remember the questions.
SQL server Architecture
what is replication, log shipping, mirroring, clustering
Viewing 1181 - 1190 interview questions