What is the difference between clustered index and primary key?

0 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

Define constraints and give an example of their use?

0 Answers  

---

---

What is a partition function in sql server?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

what is the sql equivaent of the dataset relation object ?

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---