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 2189

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 7397

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 2430

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 1968

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

1 2275

Whis is not false in primary key?

975

Post New Fintellix SQL PLSQL Interview Questions


Fintellix SQL PLSQL Interview Questions


Un-Answered Questions

What is sqldatareader c#?

487


What is excel default font?

315


What is the need of multimedia course?

665


Explain the benefits of quick test pro(qtp)?

567


Are there any security issues with ajax?

517






Why to use node.js?

256


Define a process flow diagram?

625


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1557


What should be done to override the governor limit that restricts you from fetching more than 50,000 records in a soql query ?

223


Explain what is regions and endpoints in aws?

98


What is cookie?

532


What are the major uses of hexachlorophene, chlorhexidine, and triclosan as agents for controlling microorganisms?

1779


What is huffman’s algorithm?

608


What are the different turn on methods of scr?

594


What is change data capture (cdc) feature?

584