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 ?

68 78440

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

12 71310

What is a constraint. Types of constraints ?

5 20378

What is a trigger ?

10 13279

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 12352





will function return more than one value how

9 16470

what is purge command explain about oracle performance tuning

2 20805

Give an example of any procedure.

5 11610

How will we see framework of a table?

2 8112

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

24 37514

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 6723

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

1 7185

What is different between union and minus?

7 17052

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

5 9616

What is the relation b/w view and trigger

3 9373

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions





Un-Answered Questions

If you use location services in your app, will it drain your battery.if yes? How can we avoid?

471


What is field partitioning in co-pa? : co-pa

33


Explain the difference between logfile & log space?

5


what is the necessity of phase locked loop in amplitude modulation systems ?

1123


What is exception handling in php?

451






Define consignment stock.

13


cud u help me ... i am struggling with this question... to find all the subsets of a given set for ex.... a,,b,c shud give all the subsets.... i gt the program in c bt nt able to get it in java..... help needed ..

1050


What is a two-pass assembler?

56


For what purpose ERS is used for?

1161


Explain about the data model operations in HBase?

3


Explain the process of creating tables using NetBeans IDE?

37


Explain enumeration in java?

14


What are different modes of metastore deployment in Hive?

21


What are the core classes of struts framework? Explain

10


Explain me how will you neutralize a toxic link to your site?

3