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

  • Oracle aptitute test questions (18)
  • Oracle interview questions (479)
  • Oracle placement papers (2)
  • Oracle technical test questions (41)



Oracle SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is correlated sub-query?

7 32663

how instead of triger is helpful for mutating tables errors handlling ?

2 6572

What are the advantages of the packages

6 6157

what are the advantages of primary key over unique+notnull

7 13538

how to retrieve the top 3 salaries of the table using rownum

31 20280

what is the difference between union and union all

14 30937

What is the difference between join and union.

27 147120

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 7919

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 4952

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 7538

What cursor type do you use to retrieve multiple recordsets?

17 46219

Two Methods of retrieving SQL?

7 43135

How do you optimize SQL queries ?

6 23285

How well can multiple sessions access the same data simultaneously ?

738

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 9781

Post New Oracle SQL PLSQL Interview Questions




Un-Answered Questions

What is the magnetic field (coil DC ) of Turbo Expander?

567


What do you know about the historical background of Development Financial Institutions (DFIs)?

615


What is the difference between specifying a constant variable like with constant keyword and #define it? i.e what is the difference between CONSTANT FLOAT A=1.25 and #define A 1.25

425


I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

422


I HAVE DONE B. SC . (BIO) AFTER THAT I HAVE DONE MBA HR AND NOW MANY INTERVIEWER ASK ME WHY I HAVE HONE MBA IN HR? PLZ ANSWER ME?

842


What is aggregate Liabilities ?

426


1.) How would you describe yourself?

1384


how do u really know that paging to disk is happening while u are using a lookup transform?

617


Give the Core Architecture?

323


what is the critical defect in telecom domain?help me out from this prob its very urgent

1763


write a report on 'house path management'.

656


I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian

628


What is alpha test in alumina powder?

443


What is the indication of leaking starting valve of an engine?

535


suppose we have 400 users in that 300 can able to connect to the Database and 100 cannot

78




Oracle SQL PLSQL Interview Questions
  • C (21)
  • OOPS (2)
  • C++ General (2)
  • Programming Languages AllOther (4)
  • PHP (2)
  • CGI Perl (2)
  • JavaScript (1)
  • VB Script (1)
  • Networking Administration (1)
  • Oracle General (44)
  • Architecture (1)
  • Database Management (5)
  • Forms Reports (6)
  • Oracle AllOther (13)
  • SQL Server (11)
  • Sybase (1)
  • DB Administration (4)
  • SQL PLSQL (37)
  • Linux Commands (6)
  • Linux General (2)
  • Linux AllOther (4)
  • Unix Commands (2)
  • Unix AllOther (1)
  • Solaris General (2)
  • Operating Systems General Concepts (2)
  • Load Runner (1)
  • QTP (18)
  • Test Director (1)
  • Automation Testing AllOther (1)
  • Manual Testing (29)
  • QA Concepts (13)
  • Testing AllOther (5)
  • COBOL (2)
  • Core Java (16)
  • Advanced Java (2)
  • Struts (1)
  • J2EE (6)
  • Weblogic (5)
  • Middleware AllOther (1)
  • Business Objects (6)
  • Cognos (2)
  • Informatica (4)
  • Data Stage (1)
  • SAS (33)
  • Data Warehouse General (3)
  • HR Questions (2)
  • UML (1)
  • SAP Basis (1)
  • SAP FI CO (1)
  • SAP SRM (1)
  • PeopleSoft Administration (1)
  • Siebel (3)
  • ERP General (2)
  • Oracle Apps Technical (32)
  • Oracle Apps Financial (57)
  • Oracle Apps Manufacturing (3)
  • Oracle Apps HRMS (11)
  • Oracle Apps CRM (1)
  • Oracle Apps SCM (7)
  • Oracle Service Contracts (1)
  • Oracle Apps AllOther (1)
  • 3D Animation (1)
  • Image Processing General (1)
  • Civil Engineering (1)
  • Mechanical Engineering (1)
  • Electrical Engineering (2)
  • Electronics Communications (3)
  • Engineering AllOther (4)
  • Marketing Sales (5)
  • Finance (2)
  • Human Resources (2)
  • Non Technical (3)
  • Accounting General (1)
  • Accounting AllOther (4)
  • APPSC AllOther (3)
  • Everything Else AllOther (1)
  • General Aptitude (8)
  • Puzzles (9)
  • Placement Papers (2)
  • CISA Certification (2)
  • Oracle Certifications (12)
  • Australia Visa (1)
  • C Code (2)
  • J2SE Code (1)
  • Programming Code AllOther (1)
  • CAT (1)
  • Oracle Errors (15)