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)

Mention the different authentication modes in sql server.

1099

---

Is the order of columns in the set clause important in ms sql server?

1011

---

How can change procedure in sql server?

1121

---

How the authentication mode can be changed?

1172

---

Mention what are the different types of ssrs reports?

158

---

What are dml (data manipulation language) statements in ms sql server?

1021

---

What is a derived table?

986

---

What is table valued function and scalar valued functions?

1157

---

What program is used to store the data source file?

1002

---

Can you create a logon trigger in sql server 2005 express edition?

1116

---

What is the difference between functions and stored procedures?

1219

---

A trigger can reference objects outside the current database? State true or false.

1057

---

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?

1011

---

what is a sub-report?

146

---

New concepts of sql server 2005 use in your project.

2399

---