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

Why is mysql used?

926

---

How does mysql store dates?

915

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2214

---

How do I rename a table in mysql workbench?

940

---

Is mysqli deprecated?

939

---

How do I find the size of a mysql database?

898

---

How to show table structure mysql?

986

---

What is trigger in mysql?

908

---

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

908

---

Where is mysql data stored linux?

992

---

What are the advantages and disadvantages of using mysql?

981

---

How show all tables in mysql query?

903

---

What is blob and text in mysql?

1158

---

How do I use mysql?

877

---

How do you create a primary key?

990

---