How does and autonomous transaction work
Sql Analyst Interview Questions
2,215 sql analyst interview questions shared by candidates
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
What is normalisation and types of normalisation
Materialized views and lead lag functions
Tell me about yourself and why did you applied for this role?
why should I hire you
advance plsql. collections. cursor , joins, exceptions
1) delete duplicate data from employee table 2) find salary of manager > avg(salary) of his reporting employees
What is PL? what are triggers? Difference between PL/SQL and SQL
What is trigger, how many values a function returns.
Viewing 2191 - 2200 interview questions