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 118533

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

12 83884

What is a constraint. Types of constraints ?

5 26099

What is a trigger ?

11 21864

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 17803

will function return more than one value how

9 23956

what is purge command explain about oracle performance tuning

2 26560

Give an example of any procedure.

5 16963

How will we see framework of a table?

2 11767

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

24 57892

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 12923

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

1 10124

What is different between union and minus?

7 23740

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 15842

What is the relation b/w view and trigger

3 16531

Post New Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions

Accenture SQL PLSQL Interview Questions (15)

Un-Answered Questions

Can .net framework components be used from a com program?

905

What is xslt mapping?

844

What are the Steps for Creating a Blade Template Layout ?

1211

What are the different types of collections views being provided by the map interface? : java collections

1041

Can to set up filters like I did in eudora?

Name different types of searches available in QlikView?

What is the difference between a check constraint and a rule?

1254

What are the different types of fits? Explain

1107

Explain with example the concept of constant variable in java.

1183

tell us about your qualification?

1054

Can a file other than a .h file be included with #include?

1166

Is windows 7 still safe to use?

847

Define what is the difference between active and passive filters?

1954

What is information model and why is it required?

105

What is heading tag and why it is used for?

798