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 10273

What is the diff between Truncate table / delete

purge

TCS,

3 15708

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 7841

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 10430

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

CGI, TCS,

1 6090

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

CGI, Quest,

2 7026

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

CGI,

2 7605

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

CGI,

6 12078

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 7639

What is Difference Between delete and Truncate?

9 11757

What is Difference between StoredProcedure and function?

3 7523

what is Difference between Having and Where clause?

IBM,

5 10989

How many rows will return from dual table?

Fujitsu,

4 12013

2 5334

select top 3 sal from each dept?

IBM, TCS,

17 27525

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the rules to be applied to nulls whilst doing comparisons?

1323

What is the difference between clustered and non-clustered indexes?

1091

What are the parts of a basic sql query?

967

What are the types of variable use in pl sql?

1080

What is data abstraction in sql?

1031

What is a dirty read sql?

1137

Explain what is a subquery ?

1188

what is the difference between char_length and length? : Sql dba

1044

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1042

What is the usage of when clause in trigger?

1057

What does fetching a cursor do?

1087

What is the difference between an inner and outer join?

1012

How do you declare a user-defined exception?

1024

how to fetch alternate records from a table? : Sql dba

1112

How does left join work in sql?

1001

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