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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

How do you assign Construct the where clause without concatenating Field,value pairs?

Microsoft,

1 6259

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 7146

What is a Procedure ?

3 7919

What is difference between Procedures and Functions ?

Hi Caliber IT,

6 10204

What are the differences between Database Trigger and Integrity constraints ?

4 18054

What are the blocks in stored procedure?

Microsoft,

6 15039

How do you handle exceptions. Give the syntax for it?

BCL, Microsoft,

1 8223

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 128464

When would you denormalize?

MBT, Microsoft, MMU,

8 17226

Difference between a query and strored procedure?

Microsoft,

4 10030

What is clustered and non-clustered indexes?

Microsoft,

4 13897

Types of joins?

Microsoft,

4 8970

How do you get all records from 2 tables. Which join do you use?

Microsoft,

8 18975

Types of optimization?

Microsoft,

6 15252

Difference between inline query and stored procedure?

Bharat, Microsoft,

4 29217

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the difference between sql, mysql and sql server?

1016

what is the use of set statement in tsql? : Transact sql

945

How are functions and procedures called in PL/SQL?

1132

Can we use distinct and group by together?

994

Can we create index on primary key?

916

What is the syntax and use of the coalesce function?

1100

what is single byte over head in oracle..?

2343

What are views in sql?

928

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062

How many columns should be in an index?

905

what are the different tables present in mysql? : Sql dba

926

How does pl sql work?

915

What is pl sql in dbms?

902

Can we call procedure in select statement?

976

What is the difference between drop and truncate commands?

999

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