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 102554

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

 12 79215

What is a constraint. Types of constraints ?

 5 23840

What is a trigger ?

 11 18314

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 16184

will function return more than one value how

 9 21208

what is purge command explain about oracle performance tuning

 2 24995

Give an example of any procedure.

 5 14895

How will we see framework of a table?

 2 10502

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

 24 50229

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 10350

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

1 9014

What is different between union and minus?

 7 21082

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 13607

What is the relation b/w view and trigger

 3 14698

Post New Accenture SQL PLSQL Interview Questions


Accenture SQL PLSQL Interview Questions


Un-Answered Questions

What are the negative impacts associated with telemarketing? : insurance cold calling

337

What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?

474

What is GAC in ASP.NET 2.0

582

What is http error 403.14 forbidden?

490

Why is mongodb so fast?

1




Do you participate in implementatation? What is your role in imp. Phase? what have udone in implementation? Which methodology you use in imp.?

1793

what are the difference between banking institutions and financial institutions?

1556

What do you understand by a routed event and what are its types?

112

Is google a server?

580

Is one Elastic IP address enough for every instance that I have running?

108

What are the 4 types of jdbc drivers?

510

How can primeng be used with angular2?

450

What is the use of taxonomy and vocabulary in drupal?

62

Write code to send e-mail from an asp.net application?

543

Is a primary key unique?

533