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 does limit work in mysql?

910

---

What are the different types of triggers in mysql?

963

---

Is mysql free download?

854

---

What is mysql workbench used for?

981

---

What is mysql aggregate functions? Explain

1095

---

How to use mysqldump to create a copy of the database?

1054

---

How do I add a column to a table in mysql?

917

---

Can mysql scale horizontally?

993

---

How do I find mysql database?

916

---

What is mysql data directory? How to determine the location of the data directory?

941

---

What is difference between microsoft sql and mysql?

998

---

What is data directory in mysql?

989

---

How do I edit a table in mysql?

896

---

What is mysql connector used for?

946

---

What is mysqli_free_result?

903

---