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 106726

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

 12 80613

What is a constraint. Types of constraints ?

 5 24382

What is a trigger ?

 11 19192

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 16620

will function return more than one value how

 9 21967

what is purge command explain about oracle performance tuning

 2 25505

Give an example of any procedure.

 5 15456

How will we see framework of a table?

 2 10842

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

 24 52461

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 10983

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

1 9378

What is different between union and minus?

 7 21769

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 14374

What is the relation b/w view and trigger

 3 15300

Post New Accenture SQL PLSQL Interview Questions


Accenture SQL PLSQL Interview Questions


Un-Answered Questions

What is another word for methodology?

642

Explain what do you mean by balanced color way?

1

What is an assistance class in webdynpro abap?

155

How can I evaluate an arbitrary python expression from c?

562

Can you define slice in business objects?

542




Why do we need indexer in c#?

675

what is the weight of 12mm aggregates?

1205

During execution of Works Contract,If Contractee(Customer) supply goods to contractor, then it should be shown in Invoice as deduction or no need to show in Invoice.

1343

How many cores does a server need?

670

Where is it located?

470

What is a prefix function.write down a code to compute prefix function.

646

Explain what are partitioned views and distributed partitioned views?

661

What do you mean by collision in hashing?

643

What is Under Subscription?

756

Can Kotline offer any additional functionality for standard Java packages or standard Java classes?

149