Answer / rajesh s. chandan

Unique identitiy key is generated during data load process
(ETL) in the datawarehouse system is called as Surrogate
key.
It is mainly used to update slowing changing dimesion
attribute data and also it removes dependencies on key
originating in different data sources.

Primary key is uniquely identified each record in a table
with no null values.

Answer / jayaraj

Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.

What are the various Isolation levels?

2 Answers   HP,

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What is dirty page?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What is the order by used for?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

Explain the usage of floor function in sql server.

0 Answers  

---

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

what is database replicaion? : Sql server database administration

0 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---