Explain the architecture of SQL Server?
Answer Posted / 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 View All Answers
Can group by and orderby be used together?
Define constraints and give an example of their use?
What is the recursive stored procedure in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
How many levels of sp nesting is possible?
Is resultset an interface?
What is SQL Azure Federations?
What are the recovery models in sql server 2000?
How to return the date part only from a sql server datetime datatype?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How to create median function?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Can we add an identity column to decimal datatype?
List out different types of normalizations in sql server and explain each of them?
Write query to return all rows sql?