Answer Posted / hari

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

What is a linked server in sql server?

1133

---

How can sql server instances be hidden? : sql server security

1218

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1108

---

Write a SQL queries on Self Join and Inner Join.

1077

---

How to get the query of a table in sql server?

962

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1000

---

What do you understand by a view? What does the with check option clause for a view do?

1058

---

What is an identity?

1076

---

Differentiate between sql temp table vs table variable?

927

---

Explain primary key?

1006

---

What is dknf in normalization form?

1112

---

What are sql dirty pages?

1081

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1120

---

List few advantages of stored procedure.

1026

---

How to convert character strings into numeric values?

1149

---