Answer Posted / ns

constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null

What is row-level compre?

990

---

How you can get a list of all the table constraints in a database? : Sql server administration

1019

---

Explain nested join?

966

---

What command would you use to add a column to a table in sql server?

1296

---

What is data source object?

991

---

What happens when converting big values to numeric data types?

1114

---

How to round a numeric value to a specific precision?

1065

---

What is the Disadvantage of indexed sequential file.

1074

---

How to filter out duplications in the returning rows in ms sql server?

1124

---

Explain various On-Delete options in a DB table. Which is the default option?

1456

---

What are the advantages of having an index on the sql server?

921

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1054

---

Explain about extended stored procedure?

923

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1035

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

962

---