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 happens if null values are involved in bitwise operations?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

State a few properties of relational databases?

0 Answers  

---

Explain what is the function of sql server agent windows service?

0 Answers  

---

How to concatenate two strings in SQL Server.

0 Answers   HCL,

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---