Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain the architecture of SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain the architecture of SQL Server?..

Answer / skybeaver

SQL Server was originally developed by Sybase in the mid-
1980s and licensed to Microsoft until 1997. Even today,
most of the core technology in SQL Server is the same as
Sybase Adaptive Server Enterprise. Architecturally, Sybase
and Microsoft are very similar, and both use the Transact-
SQL dialect of SQL that is copyrighted by Sybase. To this
day, Sybase receives a royalty for every copy of SQL Server
sold.

Key architecture points:
1. Multi-threaded, scales to multiple processors
2. Main databases are master, model, tempdb
3. Each database has at least one data segment and one
log segment
4. Transaction log is used for rollback and recovery

Is This Answer Correct ?    65 Yes 15 No

Explain the architecture of SQL Server?..

Answer / hari

Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers

Is This Answer Correct ?    46 Yes 26 No

Post New Answer

More SQL Server Interview Questions

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

What are the types of subquery?

0 Answers  

What is the difference between drop table and truncate table?

0 Answers  

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

What is the use of sql profiler in sql server 2012?

0 Answers  

What are the fixed server level roles? : sql server security

0 Answers  

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

Explain a differential backup?

0 Answers  

Do you know what is difference between stored procedure and user defined function?

0 Answers  

What is sqlcmd?

0 Answers  

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

For more SQL Server Interview Questions Click Here
Categories