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 well can multiple sessions access the same data simultaneously ?

Oracle,

1 3512

What is Data Concarency and Consistency?

1 6000

What is Overloading of procedures ?

Amdocs,

4 11260

How to return more than one value from a function?

Satyam,

11 31100

How can you create Cursor with parametres ?

3 8655

How you will create Toad Function?

1 17318

what is a sub query?how will you calculate working days in a month using sub query?

InteQ,

4 11907

what is difference between procedure and function

MCN Solutions, Wipro,

10 16543

in procedure how to return a value

Wipro,

3 11447

in a package one procedure is wrong package shows valid or not

4 8573

what is cursor procedure

iGate,

1 7311

what is global variable in package

Polaris,

3 11272

is it mandatory to select all the column in a view then what columns should be selected

2 6099

difference between pl/sql table and normal pl/sql table

2 12977

will function return more than one value how

Accenture,

9 23942

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the difference between nested table and varray?

1003

Is sql port 1433 encrypted?

1023

How do you write an index?

965

What is primary key and foreign key?

960

What does the acronym acid stand for in database management?

1032

What is trigger and how to use it in sql?

1021

What is scalar data type in pl sql?

1070

What is mutating sql table?

1109

How many tables can you join in sql?

957

What is a column in a table?

1125

What is number function in sql?

971

What is the maximum rows in csv?

920

Which one is better subquery or joins?

1062

Explian rowid, rownum?

1012

What is tuple in sql?

1078

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