Answer / 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)

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

Do you know the isolation level that sql server support?

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Does index slows down insert statements?

0 Answers  

---

State a few properties of relational databases?

0 Answers  

---

Do you know what is rank function?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

How can you list all the table constraints in a database?

0 Answers  

---

What is database mirroring?

0 Answers  

---

What is the purpose of self join?

0 Answers  

---