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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 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 
What is the difference between local table and global table
 Question Submitted By :: Sneha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between local table and global table
Answer
# 1		 
A local temporary table exists only for the duration of a 
connection or, if defined inside a compound statement, for 
the duration of the compound statement.

A global temporary table remains in the database 
permanently, but the rows exist only within a given 
connection. When connection is closed, the data in the 
global temporary table disappears. However, the table 
definition remains with the database for access when 
database is opened next time.
 
Is This Answer Correct ?    8 Yes 3 No
Radha
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Explain Different types of Projects?  1
What is the default value of CHAR type? Bosch8
What is the use of CASCADE CONSTRAINTS?  2
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds5
Is trigger fired implicitely?  2
how can i store resumes in database? HCL2
Can I remove the default constraint columns in SQL SERVER? Value-Labs3
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
Difference between sql server 2000 and sql server 2005? Satyam4
What is normalization?  6
how to delete duplicate rows from table in sql server HCL8
hi i gone though satyam interview. what is Acid Properties? Satyam2
how to find out the repeated value from table using groupby function?  3
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies12
What are cursors?  8
What is a Stored Procedure?  7
is there more the two primary key in a single table? Systematix22
Difference between writing SQL query and stored procedure ? Cognizent8
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L  4
What is transaction ? Give me one example. Melstar7
 
For more SQL Server 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