Answer Posted / saraswathi muthuraman

Compost key :

More than one column will be used to create compst key

SQL> create table ts_250 (a number,b number,c number,
primary key(a,c));

Table created.

here column A and column C is used to create compst key.
U can't insert null value in both columns.
Only unique combination of column A and column B value can
be inserted.

Primary key :

Key will be created on a single column in table.

SQL> create table ts_251 (a number,b number,c number,
primary key(a));

Table created.


null value cann't be inserted into column a.
oracle will create a index
only unique value can be inserted into column a.
only one primary key can be created on a table

How to return query output in xml format?

1086

---

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2652

---

How do you insert a table?

971

---

Is foreign key indexed mysql?

936

---

How to enter numeric values as hex numbers?

1035

---

What do ddl, dml, and dcl stand for?

964

---

What is the use of mysql workbench?

1060

---

How do you backup a database in mysql?

1120

---

Is mysql case-sensitive?

947

---

How do I find mysql database?

952

---

What is the difference between mysql and oracle?

1007

---

How do I restart mysql on windows?

1011

---

How do I insert multiple rows in a table?

950

---

How do I edit a database in mysql workbench?

952

---

What is mysql aggregate functions? Explain

1158

---