Answer Posted / srinivas

Constraint are the rules enforced on data columns on table



Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

what is spatial nonclustered index

538

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

489

---

Explain primary key?

539

---

What are date and time data types in ms sql server?

525

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

513

---

---

ow to bring suspect mode datbase online from scratch

1402

---

What types of replication are supported in sql server?

561

---

Explain indexing and what are the advantages of it?

524

---

What are commit and rollback in sql?

564

---

Can foreign key be duplicate?

626

---

Explain system scalar functions?

573

---

Explain the rules for designing files and file groups in sql server?

548

---

What happens when transaction log is full?

511

---

How do I view a trc file?

503

---

What are the types of normalization?

547

---