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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

Infosys,

5 11701

Can we use out parameter in function?

Infosys,

4 16835

What will be the output for the below Query Select 'High' from dual where null = null;

Infosys, Satyam,

12 31306

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 6194

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 10486

how many no of table can be join in a sql query.

4 10065

When do we create bitmap indexes

CTS,

2 10064

define sql

Zensar,

3 6588

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

TCS,

1 5449

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

TCS,

6 13788

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

TCS,

3 7962

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

Accenture,

6 16091

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

BeBo Technologies,

8 17040

How to count the no of records of a table without using COUNT function?

TCS, Tesco,

11 29181

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

JDA,

4 8791

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I tune a sql query?

1035

What is the difference between a primary key and a clustered index?

1034

Why do we use view in sql?

1017

What are the 3 modes of parameter?

1203

What is normalization? How many normalization forms are there?

1138

Is join and inner join the same?

1041

What is the difference between alter trigger and drop trigger statements?

1162

What are predefined functions in sql?

1105

Can we use view in stored procedure?

953

What steps server process has to take to execute an update statement?

1016

What are the types of optimization?

1008

Can we have two clustered index on a table?

1077

Do we need commit after truncate?

1135

Are stored procedures compiled?

980

What is information schema in sql?

1113

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