Answer Posted / 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

Can we insert data into materialized view?

993

---

Determine if oracle date is on a weekend?

1089

---

what is offset-fetch filter in tsql? : Transact sql

998

---

what are all types of user defined functions? : Sql dba

1086

---

What are reports usually used for?

1085

---

Do we need to rebuild index after truncate?

1098

---

What is difference between procedure and trigger?

1022

---

What are tables and fields?

1087

---

What are character functions in sql?

994

---

What is dml with example?

1155

---

How do temporal tables work?

1020

---

What is the source code of a program?

1120

---

Does sql*plus also have a pl/sql engine?

1131

---

What is recursive join in sql?

1068

---

What are different sql data types?

1128

---