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
why should I hire you
Deeply from sql What is triggers What is stored procedure What is normalisation Describe joins and types What is cluster and pointers in SQL Questions from projects
Tell us about your background.
You get access to a SQL database from Revolut, and you must write SQL queries — for example, to calculate the click-through rate (CTR) of an ad.
Asked about error handling, materialised views, Data Warehousing concepts.
Tell me about yourself and why did you applied for this role?
Cleared but did not get the offer
diff between 2005 and 2008 versions..diff b/w stored procedure and function
Viewing 2201 - 2210 interview questions