Accenture SQL PLSQL Interview Questions Answers, Accenture Placement Papers, Accenture Technical, HR Interview Questions, Accenture Aptitude Test Questions, Accenture Campus Placements Exam Questions

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 ?

69 120005

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

12 84256

What is a constraint. Types of constraints ?

5 26310

What is a trigger ?

11 22230

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 17935

will function return more than one value how

9 24205

what is purge command explain about oracle performance tuning

2 26675

Give an example of any procedure.

5 17150

How will we see framework of a table?

2 11879

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

24 58653

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 13126

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

1 10214

What is different between union and minus?

7 24002

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

6 16081

What is the relation b/w view and trigger

3 16686

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

For some transformers we are using solid neutral earthing while some others we are using resistance earthing why ?

1951

Can you have more than one content canvas view attached with a window ?

2368

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2896

What is DAO?

2071

what is data control language? : Sql dba

1065

Why should pumping be not used in case of concreting works?

1476

What is the main parts of jms applications?

903

Can we implement dealloc in arc? If yes, what is the need to do that?

How to find operating system information using the qtp script?

1139

What is an administration server?

1067

What do you know about routing in sap pp?

684

explain working principle of earth leakage relay

3760

what are the usual adaptations of saprophytic plants like agaricus and ascobolus?

4144

Distinguish between factory, service & provider?

820

What are the back slash character constants or escape sequence charactersavailable in c?

1227