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 118592

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

12 83900

What is a constraint. Types of constraints ?

5 26105

What is a trigger ?

11 21881

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 17808

will function return more than one value how

9 23965

what is purge command explain about oracle performance tuning

2 26563

Give an example of any procedure.

5 16970

How will we see framework of a table?

2 11770

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

24 57921

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 12931

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

1 10127

What is different between union and minus?

7 23748

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 15849

What is the relation b/w view and trigger

3 16537

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

What does delete function do in perl?

991

What are the different components that are available in kafka?

511

Is unix a coding language?

892

What is bayes' theorem? How is it useful in a machine learning context?

what do you mean by Firm

1623

What is the working mechanism of OLTC in Power Transformers????

4330

What is lmp (link management protocol)?

984

You are noticing a performance impact on your application and you suspect the underlying operating systemresources might be causing the issue, what steps would you take to narrow down the issue?

1070

Search Services in moss 2007 and Sp 2010?

815

What is cairnghorm in flex? How do we use it?have you worked with cairnghorn in flex?

why we need to take u?

2120

What Is Negative Amortization?

1230

write a program in c++ for finding the given no. is odd or even without using any airthmatic operater?

2046

I am maintaing books of accounts a Software Co. Kindly advise me Account Head of these exps. (Software Exps.,Internet Exps., Video Exps.,Server Maint.Exps.,& SMS Exps.,) Thanks

1938

Explain what is the purpose of sap script?

1143