Answer Posted / tarun kumnar basak

A Local Temporary table is almost the same as the Temporary
table in oracle. The main difference is that in oracle
you've to specify the keyword local in your query and also
Local Temporary table exists only for the user who is
created the table. So no other session can use/see the
temporary table.

Where as GTT is another kind of temporary table in oracle
which is by default the temporary table(if you don't
specify the keyword local). GTT can be used by every
user/schema which is connected to the DB irrespective of
each others session and without knowing what data resides
for a particular user. As soon as you log off from the
server the GTT also deleted. It is more kind of session
specific where the structure of the table is shared among
all users but not the data. Data remains private for each
users session and no Lock can be aquired on the table.

What are the default system databases in sql server 2000?

1072

---

How to define and use table alias names in ms sql server?

1205

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1103

---

Explain magic tables in sql server?

1098

---

What is difference statement and preparedstatement?

1030

---

What is dbcc updateusage?

1252

---

Do you know the different ddl commands in sql?

1096

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1112

---

What is change tracking in sql server?

1071

---

Do you know what is a linked server in sql server?

1064

---

What is a mutating table error and how can you get around it?

1123

---

Does union all remove duplicates?

1119

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1034

---

What is the ‘fillfactor’?

1013

---

How to connect sql server management studio express to sql server 2005 express?

1091

---