to explain sql server 2000 architecture & authentication
- 1 Answers
- 5377 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhuri
Sql server architecture
Database having physical and logical databases
in physical databases contains filegroup and Transcation log
in filegroup consists of datafile--36,767 TB
datafile consists of table--a single table can have 1024
columns.
Table consists of extents---8 contigious pages 1 extent--
64KB
exetents consists of pages---8KB
pages consists of rows---8060 bytes(max row size)
Tnasaction log is userdefind filegroup by default it's
primary file group.
Logical --- database objects like
views,sp,functions,triggers,indexes and roles etc.
------authentication modes
There are two types of Authentication modes.
1.Windows Authentication Mode.
2.Sql server Authentication(mixed mode)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is self contained sub query?
What is a scheduled job or what is a scheduled task?
How to connect php with different port numbers?
Equi join and non equi join is possible with sql server?
Why should you use or avoid select * statements?
Can we do dml on views?
How to convert character strings into numeric values?
What is the difference between for xml raw and for xml auto?
Explain system functions or built-in functions? What are different types of system functions?
How can I check that whether automatic statistic update is enabled or not?
How to remove duplicate rows from table except one?
How do I find the sql server version?
do you know how to configure db2 side of the application? : Sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
