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

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

Accenture SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Write a query to get 2nd maximum salary in an employee table ?

68 83190

What is an index and types of indexes. How many number of indexes can be used per table ?

12 73065

What is a constraint. Types of constraints ?

5 21034

What is a trigger ?

10 14185

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 13052





will function return more than one value how

9 17347

what is purge command explain about oracle performance tuning

2 21570

Give an example of any procedure.

5 12202

How will we see framework of a table?

2 8533

When we give SELECT * FROM EMP; How does oracle respond?

24 40006

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 7373

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 7508

What is different between union and minus?

7 18074

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

5 10268

What is the relation b/w view and trigger

3 10197

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions


Un-Answered Questions

What is the relationship in salesforce? What are its types?

7


in 1-phase 230v,how in 3-phase 440v. in each phase in between 230v.

1892


who is the pramotar?

885


What is a cascading goal?

13


in indoor type circuit breakers why only the corner breaker trips specially during cold season. What is the reason.

1010






I mean if we both are strange for each other & i want to make friendship within 10 min. then what is the all process of that like "hell i m neeraj if u dont mind may i take ur 10min. then 2ns person says that why not sure" so plz guide like it ?

1398


explain code with multi inhertance

1198


What are start up parameters or input parameters?

1


How will you find the current time of the remote machine using QTP script?

183


Explain when do we analyze the tables? How do we do it?

139


Explain the significance of the shareoptions parameter?

111


i have 2 tables 4 colums table 1 respective values a1 6, a2 8,a3 9,a4 14 & table 2 respective values a1 6, a2 8, a3 9, a4 12. if compare 2 tables 3 colums values same then 4th column values 1)Qes diff >5 then (5 * diff value ) 2)Qes diff <5 the 5 3)Qes diff 5 then 5 print respective values..

1300


How do I fix windows update corruption windows 10?

98


Explain the different types of building contracts?

155


Which is better windows 7 or windows xp?

138