Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the basic concepts of SQL server architecture?
- 2 Answers
- 16972 Views
- College School Exams Tests, I also Faced
- E-Mail Answers
Answer Posted / hari
Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc
| Is This Answer Correct ? | 33 Yes | 10 No |
Post New Answer View All Answers
What is a derived table?
How to find the list of fixed hard drive and free space on server?
What is sub-query in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is bookmark link in ssrs?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain left outer join and right outer join?
How to test values returned by a subquery with the in operator?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Which sql server table is used to hold the stored procedure scripts?
what types of replication are supported in sql server? : Sql server database administration
How to encrypt Strored Procedure in SQL SERVER?
Can we use having clause without group by?
Do you know nested transaction?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
