SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 2653

What is Data Concarency and Consistency?

1 5237

What is Overloading of procedures ?

Amdocs,

4 9599

How to return more than one value from a function?

Satyam,

11 27637

How can you create Cursor with parametres ?

3 7139

How you will create Toad Function?

1 16523

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

InteQ,

4 10482

what is difference between procedure and function

MCN Solutions, Wipro,

10 12994

in procedure how to return a value

Wipro,

3 9918

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

4 6935

what is cursor procedure

iGate,

1 6389

what is global variable in package

Polaris,

3 9988

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

2 5219

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

2 11878

will function return more than one value how

Accenture,

9 21186


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Mention what is the use of function "module procedure" in pl/sql?

556


What is the requirement of self-join?

533


How many indexes can be created on a table in sql?

489


How do I run a sql trace?

512


Why do we use procedures?

506






What is not null in sql?

564


How do I view a view in sql?

498


List out the acid properties and explain?

554


How subquery works in sql?

533


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1636


Does varchar need length?

513


What are literals in sql server?

520


What are stored procedures used for?

528


What is oracle sql developer?

598


What is a string data type in sql?

509