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 is the difference between local and global temporary tables?

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What are the differences between local and global temporary tables?

0 Answers  

---

---

Can primary key be a foreign key?

0 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

Explain about protocol layer present in SQL server?

0 Answers  

---