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

What are different clauses used in sql?

1172

---

What is date functions?

1088

---

What is rownum in sql?

1091

---

What is the difference between having and a where in sql?

1149

---

what are the different type of sql's statements ? : Sql dba

975

---

how is exception handling handled in mysql? : Sql dba

1127

---

How do I add a database to sql?

1181

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1131

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1243

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1004

---

Can you have more than one key in a database?

989

---

what are the t string functions available in tsql? : Transact sql

1062

---

Explain what is a database?

1134

---

how would you enter characters as hex numbers? : Sql dba

1035

---

What are the possible values that can be stored in a boolean data field?

1040

---