Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 1886

What is Data Concarency and Consistency?

1 4484

What is Overloading of procedures ?

Amdocs,

4 8241

How to return more than one value from a function?

Satyam,

11 24657

How can you create Cursor with parametres ?

3 5969

How you will create Toad Function?

1 15763

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

InteQ,

4 9223

what is difference between procedure and function

MCN Solutions, Wipro,

9 9516

in procedure how to return a value

Wipro,

3 8007

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

4 5617

what is cursor procedure

iGate,

1 5478

what is global variable in package

Polaris,

3 8809

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

2 4360

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

2 10422

will function return more than one value how

Accenture,

9 17344


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Why stored procedure is better than query?

108


What is a schema sql?

110


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

2493


What is the basic structure of an sql?

153


Why do we use %rowtype & %type in plsql?

148






What is sql and its types?

97


What has stored procedures in sql?

172


Do stored procedures prevent sql injection?

112


How to display the current date in sql?

156


How to raise user-defined exception with custom sqlerrm ?

145


What are different types of sql commands?

96


Does mysql support pl sql?

110


what is the difference between delete and truncate commands? : Sql dba

148


What is group by in sql?

108


Is primary key an index?

114