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 can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

Fidelity, KCP,

4 15800

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

rsystems,

8 10479

how will be date change into string

4 6350

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

Fidelity, IBM,

6 13828

I need to write a simple query,which one is better select statement or stored procedure?and why?

iGate,

2 7015

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

Honeywell, Interact,

5 13584

how will you find out the last three records in a table with n no of records and delete them

3 6093

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 6804

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 5865

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 5887

pl/sql testing means what ...... explain process how to find pl/sql bugs

Zensar,

1 5598

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2079

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 3179

We have a CURSOR then we need BULK COLLECT?

1 3615

what is the main difference between join and subqurey?

Oracle,

3 7627

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is lexical units in pl sql?

1141

what is the difference between union and union all? : Sql dba

1016

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1670

What is oracle pl sql developer?

978

What makes a good primary key?

1032

Explain what is dbms?

1052

How many types of cursors are available in pl/sql?

1101

What are the constraints available in sql?

1046

How many types of relationship are there?

1025

Can we join same table in sql?

1015

What are the three pl sql block types?

1005

Describe sql comments?

1029

Enlist the advantages of sql.

1001

What is sqlexception in java?

982

What are the different ddl commands in sql?

1162

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