Answer / unknown

If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.

Answer / mustafa

How do we specify an ALTERNATE KEY while creating a table?

Answer / jheelum

A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

What is master database? : SQL Server Architecture

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

How fixed length strings are truncated and padded?

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

What are functions

3 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---