Answer Posted / gourvendra singh

if you need to take tha backup of the database on ur hard
disk then u can use the following query:

exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc

Why primary key is required?

540

---

How do we accept inputs from user during runtime?

540

---

What is mutating sql table?

596

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1636

---

Is sql an operating system?

534

---

---

What are the most important ddl statements in sql?

563

---

explain the delete statements in sql

574

---

What is rtm in testing?

566

---

What is java sql connection?

505

---

Explain the types of joins in sql?

563

---

Can there be 2 primary keys in a table?

548

---

what is normalization? : Sql dba

555

---

What is pl sql architecture?

493

---

What is equi join in sql?

603

---

how to convert character strings to dates? : Sql dba

512

---