Question { Oracle, 10221 }

What is a temp table? how to denote temp table?

Answer

Temporary tables are created in the tempdb database. To
create a temporary table, you must have created table
permission in tempdb.
You can create temp tables in 2 ways :
1. Create table #tablename
2. Create table tempdb..tablename

a).If you create the table as per the above mentioned ways,
the table will get dropped automatically when the
session/procedure ends or you drop it manually.
b).If you don’t use the above mentioned ways and use
only "create table table name" command in tempdb the table
will stay there as long as you drop in manually.
c).If you create a table in any other database other than
tempdb, it will not be a temp table.

Question { 5701 }

what is directio?

Answer

1.directio performs IO in the same manner as raw devices
and provides the same performance benefit as raw devices,
but has the ease of use and manageability of file system
devices.
2.directio is a static parameter that requires a restart of
Adaptive Server to take effect.

Question { 10386 }

what is the difference between dbcc checkstorage and other
dbcc commands

Answer

1.dbcc checkstorage runs checks against the database on
disk. If a corruption is only in memory, dbcc checkstorage
may not detect the corruption. To ensure consistency
between two dbcc checkstorage runs, run checkpoint before
running dbcc checkstorage. However, doing so can turn a
transient memory corruption into corruption on disk.

2.dbcc checkstorage checks the entire database, including
unused pages, so execution time is relative to database
size. Therefore, when you use dbcc checkstorage, there is
not a large difference between checking a database that is
nearly empty and checking one that is nearly full, as there
is with the other dbcc commands.

Question { L&T, 13410 }

What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?

Answer

If more than 16 levels, it will degrade your performance.