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 102312

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

 12 79148

What is a constraint. Types of constraints ?

 5 23805

What is a trigger ?

 11 18284

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 16148

will function return more than one value how

 9 21174

what is purge command explain about oracle performance tuning

 2 24963

Give an example of any procedure.

 5 14850

How will we see framework of a table?

 2 10486

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

 24 50151

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 10319

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

1 8994

What is different between union and minus?

 7 21051

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 13573

What is the relation b/w view and trigger

 3 14664

Post New Accenture SQL PLSQL Interview Questions


Accenture SQL PLSQL Interview Questions


Un-Answered Questions

How do I get activex to work in chrome?

423

Write a function expand(s1,s2) that expands shorthand notations like a-z in the string s1 into the equivalent complete list abc...xyz in s2 . Allow for letters of either case and digits, and be prepared to handle cases like a-b-c and a-z0-9 and -a-z. z-a:zyx......ba -1-6-:-123456- 1-9-1:123456789987654321 a-R-L:a-R...L a-b-c:abbc

5042

How do I open dos in windows 10?

433

When would you use hbase?

140

How do I open raw files in excel?

261




Enumerate the cause of pumps low delivery of water

1494

What are the building blocks in cloud architecture?

331

Explain an account group. What does it control?

630

Why did you choose this company?

770

1) What is an Virtual memory? 2) How do we test API's in both Windows/Linux/Unix? 3) What is an IOCTL? 4) How do you open a char device through API's? 5) What is major num/ minor num? 6) What is the max num for minor num? 7) Who gives you the major / minor numbers? 8) Reverse a string using recursive func. 9) fork/vfork/clone. 10) What does fork returns? 11) What is a zombie process? 12) What happens when a child completes before parent tries to wait for it? 13) Interrupt handlers, top-hdnl....?

2030

How can you traverse a linked list in java?

661

what is your aim

1432

What is the threshold level for think time and how can be this changed?

672

Explain grand central dispatch (gdc).

459

What is horizontally scalable?

500