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 30795

Wat is SGA ?

ABB,

3 8136

What is TABLE SPACE?

ABB, TCS,

4 12252

when MSQL8.0 is in market

2076

can we create index on index?

iFlex, Symphony,

7 15796

diff b/w function and procedure?

iFlex,

9 15667

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

iFlex,

3 10874

write the Sql query for creating database backup?

TCS,

7 20990

how to retrieve only duplicate values in a table

9 14734

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

Spice Telecom,

3 13182

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

Mastek,

3 18629

what is a cursor

IBM, TCS, Wipro,

9 15985

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 7982

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

2 7573

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

8 58886

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a dirty read sql?

1137

What is application trigger?

997

List out the acid properties and explain?

949

how can we know the count/number of elements of an array? : Sql dba

1060

Can we edit a view in sql?

983

how can you see all indexes defined for a table? : Sql dba

992

Which are the different types of indexes in sql?

1058

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

How do you exit in sql?

1106

Why is pl sql used?

979

Why is the cursor important?

1043

What is transaction control language (tcl)?

1139

how to do backup entire database? : Transact sql

1143

What is insert command in sql?

1127

what are date and time data types? : Sql dba

983

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