Answer Posted / shruti

Normalization is the process of breaking tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.

Is it important for a database administrator to understand the operating system and file access?

1041

---

Can we use trigger new in before insert?

959

---

What are the difference between primary keys and foreign keys?

1013

---

What are differences in between sql server 2012 and sql server 2016?

1094

---

Define msdb database?

1075

---

How to create function without parameter in sql server?

1105

---

how you can list all the tables in a database?

1067

---

Explain “@@rowcount” and “@@error” in sql server?

1132

---

How to provide column names in insert statements in ms sql server?

1224

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

970

---

How to see existing views in ms sql server?

1106

---

Can a rule be bound to any column of any data type?

1024

---

Explain how you can configure a running aggregate in SSRS?

169

---

Where is my database stored on the hard disk in ms sql server?

1106

---

What are information schema views?

1028

---