ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  Databases AllOther
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Can we have a function Overloading with same number of 
arguments but with different return types of function
 Question Submitted By :: Ajay
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 1
Yes
 
Is This Answer Correct ?    2 Yes 4 No
Ajay
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 2
No its not possible.
Because in function overloading the return type is not play 
any role.
 
Is This Answer Correct ?    3 Yes 2 No
Sandeep Joshi
 
 
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 3
function signature (name mangling) is done based on function
name and no. of parameter.we can't diff. by return type
because when function call there will be ambiguty.
 
Is This Answer Correct ?    2 Yes 1 No
Vikram Shinde
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 4
No,writing no. of functions with the same name but 
different argument is called as function overloading.
The arguments may be differ in nos,type etc.
The return type may or may not be same.
 
Is This Answer Correct ?    4 Yes 0 No
Anupam
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 5
Generally no but.......... ADA(Language) supports it
..............Source Wikipedia search for polymorph ism
 
Is This Answer Correct ?    2 Yes 0 No
Vivek
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 6
Yes, it is possible here are the examples

create or replace function funbool(b varchar2)
return boolean
as
begin
If b is not null then
return true;
else
return false;
end if;
end;

create or replace function funbool(b varchar2)
return number
is
begin
if b is null then
Dbms_output.put_line( 'false');
else
Dbms_output.put_line( 'true');
end if;
Return b;
end;
 
Is This Answer Correct ?    0 Yes 1 No
Ajay
 
  Re: Can we have a function Overloading with same number of arguments but with different return types of function
Answer
# 7
There is a catch in the question. We can have function overloading with same number of arguments with different return types. One step ahead, we can have function overloading with same number of arguments provided the type and order of the arguments are not same irrespective of return type.
 
Is This Answer Correct ?    4 Yes 0 No
Abhilash S Thachil
 

 
 
 
Other Databases AllOther Interview Questions
 
  Question Asked @ Answers
 
Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key  1
what is primary key,unique key, foreign key? can u teach me in simple language? CMC14
What are the differences between Database Trigger and Integrity constraints ? Synergy2
Which is the best sorting method if i have to sort the students of Harvard University according to their first name? CybAge1
characters of DBMS A) non redundant B) data independence C) increased security D) all the above Accenture1
What is the differnce between Order by and Group by  1
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS? HP2
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?  1
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN Accenture1
what is vlook up in ms excel and how does it used???  1
plz suggest me the book for preparation of NIC exam. NIC5
WHAT IS OPM?(IN DETAILED) L&T1
Can we have a function Overloading with same number of arguments but with different return types of function CybAge7
if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media Indian-Web-Technology1
what is Normalization means..? AZTEC5
what is cardinality CSC3
what is meant by Dynamic query? Satyam2
What is Stored procedure ? Inspira-Technologies3
a __________ is a virtual table made up of subset of actual table  1
What is the default identifier of structure in C? CybAge1
 
For more Databases AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com