interview is not good he asked me home town location,i give the answer am coming from andhra pradesh he drop the call
Sql Analyst Interview Questions
2,209 sql analyst interview questions shared by candidates
types of trigger. how it works?
1) delete duplicate data from employee table 2) find salary of manager > avg(salary) of his reporting employees
Explain about projects and your responsibilities? What is dual ? Difference between view and materialized view? What is substr and instr , syntax? Cursors,types of cursors and cursor attributes? Simple scenario given and instructed to write cursor and exception handling Psuedo columns in oracle? SQL loader
Asked me to write algorithm
Tell me of a time that have explained something complex.
Cleared but did not get the offer
Materialized views and lead lag functions
diff between 2005 and 2008 versions..diff b/w stored procedure and function
Viewing 2201 - 2210 interview questions