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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is sql profiler

Fidelity,

2 10259

What is the diff between Truncate table / delete

purge

TCS,

3 15693

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI,

1 7833

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI, IBM,

4 10415

What are the difference between Functions/Stored Procs and Triggers and where are they used.

CGI, TCS,

1 6080

Can you have multiple SPs with the same name on a database?

CGI, Quest,

2 7016

Can you create a table with Primary Key not as the clustered index.

CGI,

2 7591

Can you have multiple SPs with the same name on a database?

CGI,

6 12027

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

KPIT,

4 7630

What is Difference Between delete and Truncate?

9 11732

What is Difference between StoredProcedure and function?

3 7515

what is Difference between Having and Where clause?

IBM,

5 10973

How many rows will return from dual table?

Fujitsu,

4 11986

2 5324

select top 3 sal from each dept?

IBM, TCS,

17 27488

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is microsoft t sql?

940

How to add a column ‘salary’ to a table employee_details?

1008

What are sql procedures?

1018

What is join view in sql?

944

What is informix sql?

975

What is full join in sql?

987

How do I run a sql script?

1142

What is right join in sql?

1084

How do you sort in sql?

1019

Is big data nosql?

942

what is a database lock ? : Sql dba

1162

Can a table contain multiple foreign key’s?

989

What are the three forms of normalization?

1042

What is a nested table in word?

952

What is left join in postgresql?

1043

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