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 120049

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

12 84265

What is a constraint. Types of constraints ?

5 26318

What is a trigger ?

11 22239

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 17936

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 58661

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 24003

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 16091

What is the relation b/w view and trigger

3 16688

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

Why struct is used in c++?

1172

You must have BU Troubleshooting issues in GRC ? Can you list out of them ?

1888

What is size_type?

1115

How do I know if my hard drive is bad?

894

Which is a personal work schedule?

1044

What is mysql default database?

1069

Other than Data Loader any other way to import Bulk Data?

508

Did adaptive path help build google's ajax applications?

954

Differentiate between linearlayout, relativelayout, absolutelayout.

936

what is mean by sample account and data transfer rule in SAP FI?

2025

Difference between dev401 and dev501?

545

What’s credential store?

431

How do I add a font to excel 2007?

651

What is core CT & it's function?

2119

Why is maintaining a database important?

952