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 102372

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

 12 79193

What is a constraint. Types of constraints ?

 5 23817

What is a trigger ?

 11 18298

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 16165

will function return more than one value how

 9 21191

what is purge command explain about oracle performance tuning

 2 24984

Give an example of any procedure.

 5 14877

How will we see framework of a table?

 2 10493

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

 24 50192

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 10340

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

1 9001

What is different between union and minus?

 7 21059

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 13588

What is the relation b/w view and trigger

 3 14683

Post New Accenture SQL PLSQL Interview Questions


Accenture SQL PLSQL Interview Questions


Un-Answered Questions

What is laravel used for?

414

Difference between winrunner and test director?

662

What are Principal components?

273

Is it necessary to install spark on all the nodes of a YARN cluster while running Apache Spark on YARN ?

228

Can we extend private class in java?

538




what is queuemanager in ibm websphere mq?

485

What is a unix file?

514

How do I run exe on windows 7?

399

Where will you generally define the credentials and how will you use them in blue prism?

118

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2143

Where is the windows start menu in windows 10?

412

What kind of the information stored inside the assembly?

547

Why syn. Generators are used for the production of electricity?

653

Explain how many arms does an octopus have?

563

What is meaning of View in MVC?

5