Answer / shashikant

Hot Backup
taking backup, When the database is up & Running
making database in archivelog mode ,
using the command like alter database begin backup

Cold Backup
taking backup when is database is off.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Explain the use of table functions.

0 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

What are different types of transactions in ar? : oracle accounts receivable

0 Answers  

---

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---

What does coalescing a tablespace do?

2 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

0 Answers  

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---