Answer / vignesh lakshmirajan

ONE COLUMN MAY HAVE N NUMBER OF COLUMNS,.. THERE IS NO RESTRICTION IN THAT.. BUT A TABLE SHOULD CONTAIN ONLY ONE PRIMARY KEY, BUT IT MAY HAVE N NUMBER OF UNIQUE KEYS.

Answer / shashi kishor prasad

In a Table there can have as many as 1024 colums but not
more than that is allowed. There can be only 1 primary key
in a table However you can combine multiple keys together to
act like a primary key that is called composite key.
Composite key is also a primary key, difference is that it
is a combination of no of colums that act as candidate key.

Answer / rehan khan

guys first plz check the question what is exactly asked ok

the numbers of column in a table can range from 1 to 254 and only one primary key in a table .

Explain subquery and state its properties?

0 Answers  

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

List down some advantages of sql stored procedure?

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

Explain how many normalization forms?

0 Answers  

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---