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)

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

What is Schema in Database?

1 Answers   Cap Gemini,

---

How do I find the default sql server instance?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

Where views are stored in sql server?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

How does a profiler work?

0 Answers  

---

What stored procedure would you use to view lock information?

0 Answers  

---

Explain acid?

0 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---