Answer / dev

A Table can't have two primary key.

Answer / suresh babu

No,The Table should have one primary key.But we can create
single primary key for combination of more columns,which is
called Composite Primary Key.

Answer / damini

No.A table can have only one primary key .if it is having
more than one primary key then we say it as composite
primary key...A composite primarykey is a primary key of 2
or more columns together..A composite primary key is
different from primary key..

Answer / yes

yes

Answer / subbarayulu

No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.

Answer / srilekha

no,it's not possible to set more than one primary key column
to a single table

Answer / sattprakash mittal

Primary key is a field which is uniquely identified each record in a table. A table can only one primary key but there are more field can be used as primary key are known as candidate keys

Answer / vikneswaran

no,table can have only one primary key.

Answer / pardeeep

NO,A table have only one primary key.But we can use it on more then one column.
Exp..
create table emp(empno int,ename nvarchar(20),deptno int,constraint Pk_constraint primary key( empno,deptno))
This query for SQL server

Answer / iamanocp

A table can have only 1 primary key

What are the types of join in sql?

0 Answers  

how will be date change into string

4 Answers  

How to fetch alternate records from a table?

0 Answers  

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

What are system versioned tables?

0 Answers  

Why is the cursor important?

0 Answers  

What is a natural join?

0 Answers  

what is meant by nl2br()? : Sql dba

0 Answers  

Can ddl statements be used in pl/sql?

0 Answers  

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers