Answer Posted / srikanth

A composite key is used to club primary key for more than
once column.

PRIMARY KEY(<<COLUMN1>>,<<COLUMN2>>....<<COLUMNN>>)

But the disadvantage is that it will allow duplicates for
any one of the fields.

Example:

CREATE TABLE Example1
(Id INT NOT NULL,Pername VARCHAR(20) NULL,Phno INT NOT NULL
PRIMARY KEY(Id,Phno)
)

Command(s) completed successfully.

INSERT INTO Example1
VALUES(1,'sri',1111)

(1 row(s) affected)

INSERT INTO Example1
VALUES(1,'sri',6666)

(1 row(s) affected)

SELECT * FROM Example1

Id Pername Phno
1 sri 1111
1 sri 6666

As you can see that it is allowing same Id.

Basically Composite Key will take all the fields defined as
a group.So it is least bothered about any one of the field.

What are a query and state the different types of queries and their uses?

998

---

Describe an oracle table?

1026

---

How to use "in" parameter properly?

1043

---

How to use "if" statements on multiple conditions?

1142

---

How to convert numbers to characters in oracle?

1022

---

What is tns entry?

1110

---

How to do clean up if create database failed?

1012

---

Explain coalesce function?

1169

---

How to use group functions in the select clause using oracle?

1052

---

What is an oracle user role?

963

---

How to sort the query output in oracle?

1001

---

What is an external table?

997

---

What is an oracle recycle bin?

975

---

What is varray?

1105

---

What is SQL Tuning Advisor in Oracle?

1145

---