Answer Posted / vikneswaran

number

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1144

---

Can we shrink data file in sql server?

1090

---

What is a partitioned view?

1051

---

Is sql server 2016 free?

977

---

What is unique key constraint?

1117

---

How to generate create table script on an existing table in ms sql server?

1192

---

What is postgresql server?

1057

---

What are the new data types are introduced in sql 2000?

947

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1128

---

Explain an incremental backup?

1049

---

What are the system database in sql server 2008?

1094

---

Scalability, Availability, Integration with internet, etc.)?

2931

---

how many bits ip address consist of? : Sql server database administration

941

---

What is Lock table in SQL?

1519

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1118

---