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 differences between substr and charindex in sql server.

509

---

What are different backups available in sql server?

599

---

Explain temporary table vs table variable by using cursor alternative?

514

---

What is data file in computer?

536

---

Which tools are available to manage SQL Azure databases and servers?

93

---

---

How would you go about developing a ssrs report?

110

---

What is the difference between NOROW and LOCKROW?

2225

---

Is it important for a database administrator to understand the operating system and file access?

504

---

What are the two authentication modes in sql server?

596

---

How many full-text indexes can a table have?

545

---

How to execute multiple stored procedures at one time in sql server?

498

---

How can windows applications connect to sql servers via odbc?

573

---

How to Sync Two SQL Azure Databases?

101

---

What is an execution plan? How would you view the execution plan?

540

---

What are the types of sql server?

512

---