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 are the similarities between a function and a procedure?

903

---

What is pdo :: fetch_assoc?

911

---

Why are function needed?

949

---

How do you create a table in mysql workbench?

935

---

How can you filter the duplicate data while retrieving records from the table?

904

---

What does "i_am_a_dummy flag" do in mysql?

965

---

What is the maximum number of columns per table?

932

---

Can you tell the difference between ereg_replace() and eregi_replace()?

1043

---

What are the steps involved in query processing?

890

---

What is the current root password of mysql?

925

---

What is a delimiter in mysql?

1038

---

How to drop an existing view in mysql?

929

---

How do I flush privileges in mysql?

1015

---

How to update info already in a table and delete a row(s) from a table.

860

---

How to extract a unit value from a date and time?

954

---