What is a view and what are its advantages?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

What is Schema in Database?

1 Answers   Cap Gemini,

---

What is abstracting periodical?

0 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

How use inner join in sql server?

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

Why do we use trigger?

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---