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

What mysql means?

886

---

how can you test for null values in a database? : Mysql dba

893

---

List some comparisons operators used in mysql?

934

---

What is append query?

862

---

What is innodb mysql?

986

---

What is trigger in mysql?

875

---

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

842

---

How do you connect MySQL database with PHP?

926

---

What is inner join in mysql?

846

---

How to calculate the difference between two dates?

977

---

How do I change the max connections in mysql?

825

---

Can we store videos in mysql database?

877

---

What are programming functions?

885

---

What is the full meaning of mysql?

912

---

How do I start mysql in linux?

839

---