Answer Posted / sowmya

Hi
A table can have only one primary key.but a primary key can
have two column fields
Ex i have a employee table.and i have fields eno,ename,esal
i can declare primarykey(esal,ename)

let me know if i am wrong

How can check sql version from command line?

540

---

what are wild cards used in database for pattern matching ? : Sql dba

559

---

What is primary key and foreign key?

540

---

Why should I use postgresql?

570

---

Does truncate free space?

526

---

---

how do you know the version of your mysql server? : Sql dba

512

---

Explain the rollback statement?

584

---

how tsql statements can be written and submitted to the database engine? : Transact sql

542

---

Why plvtab is considered as the easiest way to access the pl/sql table?

631

---

What are the different types of joins in sql?

587

---

How do I access sql anywhere database?

506

---

List out the acid properties and explain?

569

---

what is self-join? : Sql dba

579

---

What is dbo in sql?

542

---

What is database white box testing and black box testing?

645

---