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 118499

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

12 83875

What is a constraint. Types of constraints ?

5 26092

What is a trigger ?

11 21849

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 17800

will function return more than one value how

9 23943

what is purge command explain about oracle performance tuning

2 26560

Give an example of any procedure.

5 16958

How will we see framework of a table?

2 11766

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

24 57874

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 12918

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

1 10123

What is different between union and minus?

7 23733

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 15833

What is the relation b/w view and trigger

3 16527

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

What is periodic processing in fi-aa? : fi- asset accounting

1253

What is awb?

926

what are the two different smart groups in Xcode?

921

How can the partner of sap support the migration of customer to sap s/4hana?

What are the different types of ejb?

978

What is the command to find hidden files in the current directory?

1192

Is xml html?

855

How can we improve the performance of a crystal report?

1193

What do you understand by jdbc statements?

1036

What is Erosion in a control valve?

2136

What is the difference between the functions strstr() and stristr()?

984

Explain normalization in one line?

1095

How can the output be redirected to some other action process in place showing it in the screen?

1067

Which of the Angular life cycle component execution happens when a data-bound input value updates?

928

What is an ocx?

771