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 77645

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

 12 70942

What is a constraint. Types of constraints ?

 5 20230

What is a trigger ?

 10 13105

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 12148




will function return more than one value how

 9 16205

what is purge command explain about oracle performance tuning

 2 20620

Give an example of any procedure.

 5 11491

How will we see framework of a table?

 2 7998

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

 24 36995

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 6555

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

1 7052

What is different between union and minus?

 7 16816

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 9470

What is the relation b/w view and trigger

 3 9161

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions





Un-Answered Questions

Why should we use null or zero in a program?

7

What is Combiner in MapReduce?

12

WHAT IS MEANT BY DERATING OF THYRISTOR?

1729

how do we do job grading and what are main job grading methods pls explain?

1645

What is meant by Search Queries?

6




What is an iphone app?

8

What items are required in a financial statement version? : fi- general ledger accounting

11

How to Create a folder using pmrep command?

16

is computer knowledge is must to work for bpos????????//

1070

Differentiate between data file and descriptor file?

14

What are the default port numbers used by ssh,ftp,http,https,telnet,smtp,pop3,pop3s,imap,imaps?

14

Did adaptive path invent ajax? Did google? Did adaptive path help build google's ajax applications?

10

What is limitation of the ht.of the displacer of a level trol?

1090

How can your convert numpy arrays to tensors ?

1

What is a advantage of Self Reset Lockout ? On Fault breaker get trip & fault no longer exist then self reset lockout how inform us?

519