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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Why is a trigger used?

933

Why query optimization is needed?

920

Why use truncate instead of delete?

1008

Can we call stored procedure in function?

954

Why is theta join required?

1140

What is procedure explain with example?

950

Is full outer join same as cross join?

962

What is difference between nchar and nvarchar?

1020

Can we use commit inside a trigger?

1080

What is procedure explain with program?

1011

How does cross join work?

941

Which table is left in left join?

1007

How does stored procedure reduce network traffic?

1003

What is difference between table and view?

1047

What are types of joins?

960

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the three forms of normalization?

1040

How can we implement rollback or commit statement in a trigger?

1026

Why do we need cursor in pl sql?

1125

How to move files from one directory to another in pl sql?

1184

What is rank function in sql?

1018

What is trigger in pl sql?

990

How does cross join work?

941

How is pl sql different from sql?

1079

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4269

What are the properties of a transaction?

1128

Is big data nosql?

937

Can we delete column in sql?

1088

What is clustered index sql?

982

What is a call statement? Explain with an example.

997

give the syntax of grant and revoke commands? : Sql dba

1147

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