Answer Posted / hari

no. a table can have only one primary key.some times table
can use composite primary key

ex create table std
(stdid bigint(10) not null,
e mailid varchar(20) not null);
primary key(stdid,e mailid)

What is example of database?

519

---

What is the difference between the sql*loader and import utilities? : aql loader

600

---

What is materialized view. What are different methods of refresh?

780

---

what are the different type of normalization? : Sql dba

556

---

what are the 'mysql' command line arguments? : Sql dba

652

---

---

What is an oracle stored procedure?

592

---

Explain locks? : Transact sql

575

---

Why truncate is used in sql?

531

---

what is a database transaction? : Sql dba

587

---

How can get second highest salary in sql?

509

---

What is a temp table?

569

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

595

---

Can dml statements be used in pl/sql?

579

---

What does sign mean sql?

573

---

What is cte sql?

517

---