Standard Sql Queries, PL SQL syntax
Pl Sql Developer Interview Questions
253 pl sql developer interview questions shared by candidates
how to read explain plan and tuned the query?
starts with basic pl/sql questions to advanced topics.
Questions were scenario based revolving around how to handle bulk data and how to optimize the process.
Round 1: Online Test (20 questions) Basic PL/SQL Questions Round 2: Telephonic (1 Hr) tell me about urself work u have done till now Cursors Triggers Indexes Pragma Round 3 F2F (Technical and Managerial) (1 Hr 45 Mins) Interviewers were friendly why do we use index what happens in backend when you create index what will happen if you apply index on multiple column plsql code tuning what will you do if a query is working on your system and the same query is not working in clients system (Explain plan for both are same) if your manager gives you work on friday which you have to complete it by monday and at the same time your parents are coming from your hometown what will you do? PL/SQL Objects types of SDLC model tell about a situation when you have disagreement with your co-worker how will you handle failure questions on cursors, trigger (basic questions)
Preguntas diversas sobre mi experiencia y sobre desarrollo de queries en SQL, además de algunas preguntas de acertijos.
Collections,Architecture
Difference between ASM and ADDR report
types of trigger. how it works?
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
Viewing 241 - 250 interview questions