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 104279

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

 12 79753

What is a constraint. Types of constraints ?

 5 24047

What is a trigger ?

 11 18632

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 16332

will function return more than one value how

 9 21474

what is purge command explain about oracle performance tuning

 2 25204

Give an example of any procedure.

 5 15075

How will we see framework of a table?

 2 10637

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

 24 51039

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 10585

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

1 9125

What is different between union and minus?

 7 21317

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 13876

What is the relation b/w view and trigger

 3 14903

Post New Accenture SQL PLSQL Interview Questions


Accenture SQL PLSQL Interview Questions


Un-Answered Questions

Discuss the challenges and strategies for managing anesthesia in children, including dosage adjustments and pain management.

575

Explain under what type of account does the unearned revenues fall?

3480

What is a jms server?

478

Explain the adodb.stream class?

581

In bom I mentioned item category as l but when I create po for sub-contracting defaultly it shows t?

777




What is Fractional PRI?

1089

What is the difference between ienumerable and enumerator?

484

What is meaning of <> in sql?

635

Which is the t/r that builts only single cache memory?

766

Can corba application be multi-threaded?

544

What is constrainted picklist?

680

What is the array in php?

584

explain local datetime api in java8?

587

What is lazy loading and how to enable lazy loading?

454

Which of the WebCR options allows to view the list of all client machines along with their status in read-only form?

147