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
Sql Developer Interview Questions
Sql Developer Interview Questions
SQL stands for Structured Query Language, and SQL developers create SQL databases and the applications that work with them. They often use design tables and storing procedures for stability, reliability, and performance. In an SQL developer interview, employers often ask questions about your programming knowledge and problem-solving skills.
Top SQL Developer Interview Questions & How to Answer
Question #1: What are the types of keys in SQL, and when would you use them?
Question #2: What are the types of normalization available in SQL, and how do you use them?
Question #3: What programming languages are you familiar with?
2,209 sql developer interview questions shared by candidates
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