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

How many types of indexes are there in sql?

0 Answers  

What is application trigger?

0 Answers  

How do I install sql?

0 Answers  

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

What are the two different parts of the pl/sql packages?

0 Answers  

What will you get by the cursor attribute sql%rowcount?

0 Answers  

Explain scalar functions in sql?

0 Answers  

what is organisational index?

1 Answers  

what is External tables? explain with examples

2 Answers   TCS,

can we update a view which is created from two tables

11 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,