Answer Posted / satish reddy

Each table can have only one primary key; however, that key may consist of more than one column.

SQL> create table EMP(EMPNO Number(5),EMPNAME Varchar2(10),ADDRESS Varchar2(10),Constraint Multi_Constr
aint Primary Key(EMPNO,EMPNAME));

After creating table try to insert null value into EMPNAME Column, it will throw an error "cannot insert NULL into ("SCOTT"."EMP"."EMPNAME")"

Can you join a table to itself?

1062

---

How do I make my sql query run faster?

907

---

what is a primary key? : Sql dba

997

---

Can a table have no primary key?

1021

---

what is heap table? : Sql dba

1067

---

Why use truncate instead of delete?

974

---

how can you create an empty table from an existing table? : Sql dba

1099

---

What is java sql drivermanager?

1041

---

How do I view a sql database?

993

---

What does select top 1 do in sql?

1038

---

Can we commit in trigger?

936

---

How show all rows in sql?

984

---

What is cascade in sql?

930

---

State some properties of relational databases?

1019

---

What is partition in sql query?

965

---