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 2190

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 7404

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 2432

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 1970

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

 1 2277

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 reference variables in java?

593

How to implement dphibernate to activate lazy loading in Flex with java ?thanx in advance!

2555

What is unsigned in mysql?

506

What are the time-dependent workflow – considerations ?

210

What are dlr binders?

444




How do I change the shape of a table in word?

296

What are locks in sql?

539

How secure is blockchain?

1

What is data structure explain in detail?

510

What is the total number of primary partitions you can have on one drive in linux red hat?

329

What is the difference between a variable name and an environment variable?

1

How to know the requirement of a private package in yaas builder in hybris?

5

What is inharmonious ecological interaction?

63

can anyone please tell about the nested interrupts?

1674

How to implement role based security in asp.net mvc? : Asp.Net MVC

433