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 30763

Wat is SGA ?

ABB,

3 8121

What is TABLE SPACE?

ABB, TCS,

4 12223

when MSQL8.0 is in market

2072

can we create index on index?

iFlex, Symphony,

7 15775

diff b/w function and procedure?

iFlex,

9 15627

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

iFlex,

3 10855

write the Sql query for creating database backup?

TCS,

7 20962

how to retrieve only duplicate values in a table

9 14706

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

Spice Telecom,

3 13172

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

Mastek,

3 18621

what is a cursor

IBM, TCS, Wipro,

9 15949

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 7972

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

2 7557

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

8 58852

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql harder than python?

1093

How does join work in sql?

1005

can a stored procedure call itself or recursive stored procedure? : Sql dba

1026

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

What is dbo in sql?

953

What does pl sql developer do?

920

what are tables and fields? : Sql dba

1042

What are literals in sql server?

1160

What is the usage of nvl function?

1031

Explain the difference between triggers and constraints?

967

How can you load multi line records? : aql loader

1071

Where can I learn sql for free?

981

what are the join types in tsql? : Transact sql

1060

What are inner outer left and right joins in sql?

1006

what are the disadvantages of mysql? : Sql dba

1144

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