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 79022

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

 12 71625

What is a constraint. Types of constraints ?

 5 20483

What is a trigger ?

 10 13419

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 12470




will function return more than one value how

 9 16608

what is purge command explain about oracle performance tuning

 2 20915

Give an example of any procedure.

 5 11700

How will we see framework of a table?

 2 8168

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

 24 37863

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 6830

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

1 7225

What is different between union and minus?

 7 17229

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 9705

What is the relation b/w view and trigger

 3 9489

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions





Un-Answered Questions

how to invest in mutual fund? what is bita & how it is calculated?

1822

In plants, this naturally occurring auxin has the abbreviation iaa:

24

What are important tcodes in sap workflow?

24

What is the syntax of ui object identifier used by dom extension?

46

what is the difference between driver.get() and driver.navigate.to(“url”)?

27




Why does my windows application pop up a console window every time I run it?

37

How to remove toxic links to a site?

47

How might the internet address (ipv6) affect the development and implementation of the internet of things?

1

What change management processes have you used to ensure that change is introduced properly?

2194

How to transfer request which is created directly on quality server & has to be moved to in production server?

608

What is catalog in sap pm?

39

What is numpy and how is it better than a list in python ?

1

what are the methods for absence quota accrual?

50

What are the different set operators available in sql?

29

How check variable is set or not in php?

13