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??
What happens when you start the database. Step by step
How comfortable was I with shifts
Totally nine interviewer during the interview, that is the hardest part of the interview
Cluster environment experience
Database optimization for Analytics and its elasticity
If you are having issues connection to your database server how would you troubleshoot
In reality, I was very comfortable with all the questions. If anything, the question that called my attention was "what do you think of open source?". they wanted to see if I would be willing to learn an open source RDBMS (Postgres) in the eventuality they decided to migrate from Informix, their current RDBMS.
RMAN, RAC, ASM and dataguard. Very professional interviewers. DBA and a sys admin people were there. The questions were precise and polite. Very professional interviewers. DBA and a sys admin people were there. The questions were precise and polite
What MySQL topologies have you worked with?
Viewing 21 - 30 interview questions