Answer Posted / vaziuddin shaik

PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........

FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........

How to define an external table with a text file?

1019

---

How do I limit the number of rows returned by an oracle query after ordering?

1099

---

How to create a server parameter file?

1080

---

How to use "out" parameter properly?

1023

---

How do I reset a sequence in oracle?

1050

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

932

---

What is oracle server autotrace in oracle?

1089

---

Explain about functional dependency and its relation with table design?

952

---

What are the different pseudo commands? Explain in general?

1020

---

What is procedure overloading in oracle?

992

---

How to use "for" statements in oracle?

1017

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

---

How to get the Installed Oracle Version Information ?

1073

---

How to check database size in Oracle?

1115

---

How to check the server version in oracle?

1032

---