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 81859

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

 12 72640

What is a constraint. Types of constraints ?

 5 20886

What is a trigger ?

 10 13926

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 12876




will function return more than one value how

 9 17148

what is purge command explain about oracle performance tuning

 2 21395

Give an example of any procedure.

 5 12030

How will we see framework of a table?

 2 8419

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

 24 39393

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 7210

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

1 7423

What is different between union and minus?

 7 17861

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 10098

What is the relation b/w view and trigger

 3 9975

Post New Accenture SQL PLSQL Interview Questions




Accenture SQL PLSQL Interview Questions


Un-Answered Questions

you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva

1030

What is dogpile mechanism? Explain.

132

I am going for an interview for back end and ui testing. Can smone tell me some important questions?

1012

What is meant by MIME?

135

Which are commonly used php based cmss ?

9




Name some of the JavaScript features?

134

What is microsoft visual c++ 2017 redistributable?

89

What is a bubble sort in java?

87

What is payroll driver

1110

Can I work with several databases simultaneously? : sql server management studio

122

How to accelerate electron capture decay?

1357

How many types of ngmodule?

82

What is the difference between microprocessor and DSP?

1154

After removing a table from database, what other related objects have to be dropped explicitly?

118

How will you remove all leading and trailing whitespace in string in python?

110