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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 are the advantages of using sql server over ms access 
or why should one use sql instead of ms access
 Question Submitted By :: Anil
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the advantages of using sql server over ms access or why should one use sql instead of ms access
Answer
# 1		 
Some SQL Server 2000 and Access 2000 products limits:




 Feature 	              SQL Server 2000 	Access 2000 
database size 	               1,048,516 TB 	2 GB plus 
linked tables size 
objects in a database          	2,147,483,647 	32,768 
user name length 	          128 	  	20 
password length 		  128 	 	14 
table name length 		  128 	 	64 
column name length 		  128 		64 
index name length 		  128 		64 
Number of concurrent users 	  limited  	255 
columns per table 		  1024 	  	255 
table size 	 		  limited  	1 GB 
number of indexes in a table 	  250 	        32 
number of columns in an index 	   16 	       10 
bytes per row 	8060 	2000 
number of tables in a query 	  256 	      32 
columns per SELECT statement 	  4096 	      255 
nested subqueries 	          32 	       50 
number of enforced relationships  253 	         32
 
Is This Answer Correct ?    9 Yes 3 No
Ramakrishna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output  5
What is difference beteen Migration and Upgrdation? Satyam4
What is an index? Yardi-Software7
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony21
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
What are the new features in SQL Server 2005? Emphasis2
what is the Enterprise manager(2000) and management studio (2005)?  2
How do we return a record set from a Stored Procedure in SQl server 2000?  2
What is blocking and how would you troubleshoot it?  1
How do you fine the performance tunning? Accenture2
Can you have a nested transaction? HCL3
What is the difference Between Sql-server 2000 & 2005 Value-Labs2
Can Somebody tell me the difference between Clustered & Non- Clustered Index?? Progressive3
Explain some DBCC commands?  4
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records. 247Customer3
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
What is bit datatype and what's the information that can be stored inside a bit column?  1
How many index keys possible for a table  6
 
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