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 79698

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

12 71931

What is a constraint. Types of constraints ?

5 20584

What is a trigger ?

10 13586

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 12624





will function return more than one value how

9 16767

what is purge command explain about oracle performance tuning

2 21053

Give an example of any procedure.

5 11808

How will we see framework of a table?

2 8240

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

24 38220

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 6929

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

1 7285

What is different between union and minus?

7 17403

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 9822

What is the relation b/w view and trigger

3 9620

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions





Un-Answered Questions

How do I restart iis express from command line?

27


FOR 16/20 MVA 132/33 KV ONAN/ONAF TYPE TRANSFORMER IT IS DESIGNED FOR 16 MVA WITH ONAN CONDITION.IT BECOMES 20 MVA UNDER ONAF CONDITION.LOAD LOSS IS GUARANTEED FOR 65KW AT 20 MVA AND % IMPEDANCE 13.75. PLEASE TELL US AT WHAT LOAD LOSS AND % IMPEDANCE IT SHOULD BE DESIGNED FOR 16 MVA AND WHAT WILL BE ITS EFFICIENCY AT 20 MVA?

2249


What is the purpose of objects present in asp.net?

34


What is the use of AWS redshift driver?

1


What are sql injections, how do you prevent them and what are the best practices?

38






What does GEQO stands for in PostgreSQL?

554


What do you meant by gui?

72


What is wordpress used for?

5


How many tabs are available to view your test in a test pane and what are they?

58


How does arrays sort work in java?

17


How do I remove duplicate text in word?

11


Is zero a natural number?

31


What does this line do? @Hostbinding(‘[class.valid]’) is valid?

37


What are the time-dependent workflow – considerations ?

5


What is the use of django framework?

1