How do you optimize a query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql quora?

0 Answers  


i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  


Describe different types of general function used in sql?

0 Answers  


Can you have more than one key in a database?

0 Answers  


what are the security recommendations while using mysql? : Sql dba

0 Answers  






What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,


What is null in pl/sql?

0 Answers  


How long it takes to learn pl sql?

0 Answers  


What is the difference between inner join and left join?

0 Answers  


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 Answers   Oracle,


consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  


Categories