In interview there was a question :- How many tempory table in database.

any answer?

I think the question should be
How many types of temporary tables are there is ( sybase ) database.

If this is the case then ....

Hash ( # ) tables :
Accessible from user database, though created in tempdb.
Available till connection session expires.

eg.
create table #sample_hash
( col1 )

Temporary tables :
Accessible from tempdb database
Available till server gets rebooted.

eg.
create table tempdb..sample_table
( col1 )

-samir
TechFruits.com