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)

What is the difference between dropping a database and taking a database offline?

1115

---

What are different types of replication in sql server?

1030

---

What is the standby server?

908

---

How would we use distinct statement? What is its use?

1023

---

Is it true, that there is no difference between a rule and a check constraint?

972

---

What is the return type of executeupdate ()?

857

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1011

---

Do you know what is difference between index seek vs. Index scan?

897

---

What is the difference between Stored Procedures and triggers?

1034

---

Explain the xml support sql server extends?

982

---

Explain the steps to use transact-sql cursor?

957

---

What happens if we shrink log file in sql server?

910

---

How to write an inner join with the where clause in ms sql server?

1028

---

What is the use of RDBMS?

957

---

What is the name of the Database which IBM mainframe uses?

947

---