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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is pseudo column ?

ABB,

6 30799

Wat is SGA ?

ABB,

3 8137

What is TABLE SPACE?

ABB, TCS,

4 12254

when MSQL8.0 is in market

2076

can we create index on index?

iFlex, Symphony,

7 15799

diff b/w function and procedure?

iFlex,

9 15675

diff b/w sub query and co-relater query?

iFlex,

3 10875

write the Sql query for creating database backup?

TCS,

7 20992

how to retrieve only duplicate values in a table

9 14736

using subquery how can i calculate working days in a month?

Spice Telecom,

3 13183

What is the difference between SQL table and the PLSQL table?

Mastek,

3 18629

what is a cursor

IBM, TCS, Wipro,

9 15991

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 7983

How can I pass the inner procedure value to outer procedure ?

2 7574

What is the difference between anonymous block and named block or stored procedure?

8 58888

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Why do we use %rowtype & %type in plsql?

1048

Explain table and field in sql?

1062

What is the use of procedures?

975

What will you get by the cursor attribute sql%notfound?

1074

what is a table in a database ? : Sql dba

1040

What is %type in sql?

965

List out the acid properties and explain?

949

What is sql in java?

1086

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

1109

What is pl sql code?

1052

Can cursors be part of a trigger body?

1641

How do we use distinct statement? What is its use?

1032

Is left join inner or outer?

1014

How many times can we commit in a loop?

1017

How to return multiple rows from the stored procedure?

970

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