Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IAS SQL PLSQL Interview Questions
Questions Answers Views Company eMail

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

1 2460

Post New IAS SQL PLSQL Interview Questions






Un-Answered Questions

What is the scope of static variable in c?

100


Your table has a large character field there are queries that use this field in their search clause what should you do?

123


Can you tell me limit of character used for PPC Ads ?

62


Have you already been placed?

182


Rate yourself on your learning abilities in terms of fast learner, slow learner, moderate learner?

136






Could you find this place easily?

242


Tell me can the size of operator be used to tell the size of an array passed to a function?

125


If I have put commit in badi implementation class after update, is it allowed? Also if some standard functionality already implemented an update and now i m doing update and if it fails, what will be the impact of commit?

580


In DAO we are writting sql queries , how it is possible with creating and closing database connections.

1149


How to start hbase services?

31


What is index, cluster index and nonclustered index?

126


How many variables are in python?

87


What is database migration? And how to use it to add insert initial data to database?

85


What is the difference between rank and dense_rank?

90


Why powerpoint is called powerpoint?

25