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 116054

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

12 83356

What is a constraint. Types of constraints ?

5 25797

What is a trigger ?

11 21321

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 17604

will function return more than one value how

9 23522

what is purge command explain about oracle performance tuning

2 26381

Give an example of any procedure.

5 16711

How will we see framework of a table?

2 11591

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

24 56947

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 12626

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

1 9968

What is different between union and minus?

7 23395

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 15506

What is the relation b/w view and trigger

3 16354

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

how can i create a table from front end to back end in wabe page?

1871

How can you get the reference of a caller function inside a function?

976

What would you tell a customer who said they could buy your product from another agency at a cheaper rate? : insurance sales

534

compare between starting charactristics of synchronous motor with those of 3Q Squirrel cage induction motor

1730

Difference between basic and digest authentication modes?

930

What do you understand by an implicit parameter in scala ?

What is ms office and ms word?

548

why one should join accenture?

2894

Do you need microsoft exchange to use outlook?

How to Print a TStringGrid / TDBGrid?

1721

Define satellite Assembly in .NET?

927

What are the directives in jsp?

858

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

913

How do you add custom message to the Property when it fails the Validation.

481

What is the difference between transaction data and master data?

1041