Answer / Shaji Najeev Siddiki

{"user defined datatypes": "User-defined data types (UDTs) in SQL Server allow you to create a new data type by combining built-in data types or other UDTs. This provides a way to enforce consistency and improve code reusability. You can create UDTs as structured data types, table-valued functions, scalar-valued functions, or user-defined aggregate functions."}

What is database replication? What are the different types of replication you can set up in sql server?

1 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

what are database files and filegroups? : Sql server database administration

1 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

Explain Geometry datatype in sql server 2008 with example

1 Answers   Infosys,

---

Can an entity have two primary keys?

1 Answers  

---

What are the components of sql server service broker?

1 Answers  

---

What is de-normalization and what are some of the examples of it?

1 Answers  

---

What function does a database engine serve in the sql server?

1 Answers  

---

What are SSL and TSL protocols?

1 Answers   Wipro,

---

What stored by the msdb?

1 Answers  

---

What is sql injection? How to protect against sql injection attack?

1 Answers  

---