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

Is it possible to sort a column using a column alias?

0 Answers  

what is a constraint? : Sql dba

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

Does truncate need commit?

0 Answers  

What is an alias command?

0 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

What are inner outer left and right joins in sql?

0 Answers  

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

How do I save a stored procedure?

0 Answers  

What does a pl/sql package consist of?

0 Answers  

What is the syntax to add a record to a table?

0 Answers