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 118306

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

12 83847

What is a constraint. Types of constraints ?

5 26079

What is a trigger ?

11 21803

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 17796

will function return more than one value how

9 23893

what is purge command explain about oracle performance tuning

2 26552

Give an example of any procedure.

5 16947

How will we see framework of a table?

2 11760

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

24 57825

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 12914

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

1 10116

What is different between union and minus?

7 23722

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 15824

What is the relation b/w view and trigger

3 16516

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

List out all the tables that are a part of cics ?

958

as a technical developer in oracle applications which type errors feced in your experience sofar

2325

Explain the process of recievables in oracle financials. : oracle accounts receivable

1153

Can we include external javascript/css libraries in components?

473

You are about to get on a plane to Seattle, you want to know whether you have to bring an umbrella or not. You call three of your random friends and as each one of them if it's raining. The probability that your friend is telling the truth is 2/3 and the probability that they are playing a prank on you by lying is 1/3. If all 3 of them tell that it is raining, then what is the probability that it is actually raining in Seattle.

334

What are prompt tables in peoplesoft hrms?

894

How many types of primary data structures in Perl and what do they mean?

1410

How camel handles multiple parameter binding in bean method?

What is vat adjustment?

1051

Hi Looking for web developer..who has hands on experience with HTML/DHTML, CSS,Javascript,XML. minimum 3.8yrs is mandatory. can reach..srisanh@gmail.com

2144

What is data taxonomy?

189

why dose response of a phototransistor depent upon the wave length of the incident light?

2102

Is unix a language?

879

what should be inferred by a variable named birthplace_str? : Adobe flash

846

What is a server on a computer?

984