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 11533

Can we use out parameter in function?

Infosys,

4 16651

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

Infosys, Satyam,

12 30888

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 6076

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 10211

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

4 9869

When do we create bitmap indexes

CTS,

2 9954

define sql

Zensar,

3 6437

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 5368

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 13577

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 7832

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 15816

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

BeBo Technologies,

8 16775

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

TCS, Tesco,

11 28764

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 8646

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is %rowtype in pl sql?

987

What is scalar data type in pl sql?

1066

Write the alter statement to enable all the triggers on the t.students table.

1123

How do you modify a column in sql?

991

Can I learn sql in a week?

1059

What is constant in pl sql?

1012

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1063

Explain the uses of control file.

1046

Does sql between include endpoints?

998

What is the maximum number of rows in sql table?

1022

Is sql port 1433 encrypted?

1017

How long does it take to learn pl sql?

1055

What are inner outer left and right joins in sql?

1009

What is a behavioral trigger?

970

What are properties of the transaction?

997

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