SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Difference between SUBSTR and INSTR?

3 36019

What are the usage of SAVEPOINTS?

5 17814

What is correlated sub-query?

Oracle,

7 42737

What is difference between TRUNCATE & DELETE?

Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

16 46340

What is the Subquery?

4 7812

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 14559

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13382

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 14070

What are the pre requisites?

1 5613

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

Saama Tech,

6 34105

What is the fastest way of accessing a row in a table?

TCS,

5 20720

What is ROWID?

8 19890

How will you a activate/deactivate integrity constraints?

2 9294

when a procedure /package is getting invalidated?

TCS,

4 13795

how to create a primary key with out creating an index?

TCS,

9 21222

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Write a sql select query that only returns each name only once from a table?

1071

Can a select statement fire a trigger?

1201

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1077

What are the qualities of 2nf?

1094

Why are sql stored procedures used?

1090

Explain exception handling in pl/sql?

1076

What is procedure explain with program?

1063

Explain cursor types?

1077

What is the difference between unique and primary key constraints?

1118

Mention what plvcmt and plvrb does in pl/sql?

1193

What are the different types of functions in sql?

1097

Can you sum a count in sql?

1057

How do I run a sql query?

1076

What is difference between pl and sql?

1105

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1066

For More Un-Answered { SQL PLSQL } Questions Click Here