Answer / Satyendra Kumar Chaurasia

Database design and development refer to the process of creating and maintaining a database. It involves defining the logical structure, physical layout, and interrelationships among data.

State the acid rules?

1 Answers  

---

Write short notes on manual refreshes.

1 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

Explain the rollup operator?

1 Answers  

---

How you can make a parameterized view?

1 Answers  

---

What is the database development process?

1 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

How long can an error message be in raiseerror function?

1 Answers  

---

Can you have a nested transaction?

1 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

How can you log an error to the server event log from a stored procedure?

1 Answers  

---