Plsql Developer Interview Questions

274 plsql developer interview questions shared by candidates

There are two table. In one table I have values 1,1,1 and t2 table have 1,1,null. If I inner join what is the count? (How can we tell the count?we can tell the values it can return) 2)what is ref cursor 3) query to delete duplicates. I told him partition by query and his reply was this is very time consuming. Tell me something different. 4)components of cursor.
avatar

Plsql Developer

Interviewed at 3i Infotech

3.4
Oct 22, 2020

There are two table. In one table I have values 1,1,1 and t2 table have 1,1,null. If I inner join what is the count? (How can we tell the count?we can tell the values it can return) 2)what is ref cursor 3) query to delete duplicates. I told him partition by query and his reply was this is very time consuming. Tell me something different. 4)components of cursor.

Viewing 161 - 170 interview questions

Glassdoor has 274 interview questions and reports from Plsql developer interviews. Prepare for your interview. Get hired. Love your job.