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 30975

Wat is SGA ?

ABB,

3 8261

What is TABLE SPACE?

ABB, TCS,

4 12443

when MSQL8.0 is in market

2137

can we create index on index?

iFlex, Symphony,

7 16017

diff b/w function and procedure?

iFlex,

9 15936

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

iFlex,

3 10991

write the Sql query for creating database backup?

TCS,

7 21187

how to retrieve only duplicate values in a table

9 15014

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

Spice Telecom,

3 13314

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

Mastek,

3 18781

what is a cursor

IBM, TCS, Wipro,

9 16247

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 8088

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

2 7670

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

8 59165

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is bcp? When is it used?

1175

How to install oracle sql developer?

1095

Can we insert in view in sql?

1100

Can we join same table in sql?

1063

How many types of cursors supported in pl/sql?

1252

what is 'mysqladmin' in mysql? : Sql dba

1073

How to get list of all tables from a database?

1206

Can we commit inside a trigger?

1047

How is debugging done?

1020

How do I add a primary key to a table?

1079

What is sql*plus?

1120

explain the difference between bool, tinyint and bit. : Sql dba

1057

How to change the order of columns in Oracle SQL Plus ?

1100

Can we insert delete data in view?

994

What information is needed to connect sql*plus an oracle server?

1075

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