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

Fintellix SQL PLSQL Interview Questions
Questions Answers Views Company eMail

1. Which is an aggregate function? a. Union b. like c. max d. Rank

 1 2185

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

 2 7393

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

 1 2428

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

 1 1966

7. Where would you look for errors from the database design?

 1 2274

Whis is not false in primary key?

 975

Post New Fintellix SQL PLSQL Interview Questions


Fintellix SQL PLSQL Interview Questions


Un-Answered Questions

What are lazy/deferred loading and eager loading?

55

Is use case diagram static or dynamic?

577

What is the purpose of 'register' keyword?

683

What are the benefits of using css?

330

Explain replication factor (rf)?

129




give me the code to save all messages of inbox of gmail into a folder and notepad

1615

i finished my B.sc garment production and chemical processing .now i am pursuing mba finance.suppose if interviewer asks me why did u study mba finance after ur B.Sc, what to answer.

1613

write an interactive C program that will encode or decode a line of text.To encode a line of text,proceed as follows. 1.convert each character,including blank spaces,to its ASCII equivalent. 2.Generate a positive random integer.add this integer to the ASCII equivalent of each character.The same random integer will be used for the entire line of text. 3.Suppose that N1 represents the lowest permissible value in the ASCII code,and N2 represents the highest permissible value.If the number obtained in step 2 above(i.e.,the original ASCII equivalent plus the random integer)exceeds N2,then subtract the largest possible multiple of N2 from this number,and add the remainder to N1.Hence the encoded number will always fall between N1 and N2,and will therefore always represent some ASCII character. 4.Dislay the characters that correspond to the encoded ASCII values.  The procedure is reversed when decoding a line of text.Be certain,however,that the same random number is used in decodingas was used in encoding.

2700

What are routines in datastage? Enlist various types of routines.

627

Explain the contract review process followed in your project?

4137

What are the two virtual tables available at the time of database trigger execution?

631

What are the advantages of gto over scr?

1244

What is the difference between abstract & interface?

580

What is the difference between internet and isdn?

539

What billing models are supported on BlackBerry App World?

542