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 116705

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

12 83500

What is a constraint. Types of constraints ?

5 25873

What is a trigger ?

11 21448

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 17663

will function return more than one value how

9 23616

what is purge command explain about oracle performance tuning

2 26437

Give an example of any procedure.

5 16781

How will we see framework of a table?

2 11639

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

24 57227

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 12713

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

1 10012

What is different between union and minus?

7 23497

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 15584

What is the relation b/w view and trigger

3 16394

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

how to reverse engineer views(how to load the data from views)?

514

What is kararch effect?

990

How do you use the eraser tool in powerpoint?

390

In nsfetchrequest can we fetch only a selective few attributes of an entity? How?

760

what are the certificates needed at the time of SBI clerical interview?

2083

remodeling is applied only on info cube? why not dso/ods?

1900

What is the difference between left and right outer join?

1039

Required all material and labour rate analysis 4" brick wall 12mm plaster 12mm pop punning 4" pcc full ht storage low hight storage laminate panelling veneer panelling 3" gypsum partition gypsum ceiling vitrified tiles 2nd quality laminate partition veneer partition brick bat coba italian marbles

1037

What is a package in oracle?

1048

What is a table header?

519

what will happen if OLR CT in all phases are short circuted

2131

What is a

tag in html?

751

What is a Null object?

1545

While writing an error message what all things you need to take into consideration?

825

Explain what is the difference between response.redirect & server.transfer?

1052