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 6354

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

2 7292

What is a Procedure ?

3 8079

What is difference between Procedures and Functions ?

Hi Caliber IT,

6 10429

What are the differences between Database Trigger and Integrity constraints ?

4 18252

What are the blocks in stored procedure?

Microsoft,

6 15306

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

BCL, Microsoft,

1 8318

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 129283

When would you denormalize?

MBT, Microsoft, MMU,

8 17550

Difference between a query and strored procedure?

Microsoft,

4 10258

What is clustered and non-clustered indexes?

Microsoft,

4 14084

Types of joins?

Microsoft,

4 9202

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

Microsoft,

8 19309

Types of optimization?

Microsoft,

6 15489

Difference between inline query and stored procedure?

Bharat, Microsoft,

4 29432

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a Mapplet?

1120

explain normalization concept? : Sql dba

1045

Why we use joins in sql?

981

When you have to use a default "rollback to" savepoint of plvlog?

1191

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1579

How can the performance of a trigger be improved?

1047

Which join is like inner join?

1027

Is primary key an index?

991

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

Is sql low level language?

1018

What is composite primary key in sql?

996

What are the types of index in sql?

1069

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7347

Why procedure is used in sql?

1036

what is a composite primary key ? : Sql dba

1050

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