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 80681

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

12 72272

What is a constraint. Types of constraints ?

5 20737

What is a trigger ?

10 13762

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 12748





will function return more than one value how

9 16942

what is purge command explain about oracle performance tuning

2 21255

Give an example of any procedure.

5 11911

How will we see framework of a table?

2 8323

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

24 38762

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 7075

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

1 7347

What is different between union and minus?

7 17668

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 9974

What is the relation b/w view and trigger

3 9777

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions


Un-Answered Questions

Who is a authorised Dealer?

138


What are the types of ami provided by aws?

1


How to create a dml trigger using create trigger statements?

80


When we use Abstract Class and when we use Interface?where we will implement in real time?

1197


What is the difference between Functional testing and Unit Functionality testing?

927






What is the maximum zoom size in powerpoint?

14


How do we write components in apache tapestry?

45


Can one take ayurveda medicine with modern medicines?

59


What floating point types is supported in C#?

119


What is error of a measurement?

88


can we make game by using c

2450


Define Data provider?

77


how technical is calculated in 11kv line and lt line

945


What is file and example?

69


What is Acquisition?

1428