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 do I disable mysql?

917

---

What is the usage of regular expressions in mysql?

887

---

How does triggers work in mysql?

934

---

What is mysql data directory?

976

---

What is normalization and list the different types of normalization?

936

---

What is mysql protocol?

877

---

What is difference between function and procedure in mysql?

935

---

How can you find out the version of the installed mysql?

1296

---

What is mysql shell?

965

---

How do I change the max connections in mysql?

874

---

what are the different tables present in mysql? : Mysql dba

994

---

Can I install mysql on mac?

962

---

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

908

---

Does mysql automatically index foreign keys?

905

---

What is mysqli_free_result?

883

---