Answer / Niraj Kumar Srivastava

Oracle supports most of the ANSI data types including:n- `CHAR` (fixed length character string)n- `VARCHAR2` (variable length character string)n- `NUMBER` (integer, floating point number)n- `DATE` (date and time value)n- `BOOLEAN` (TRUE or FALSE)

What is data type in oracle?

1 Answers  

---

Explain the use of full option in exp command.

1 Answers  

---

How to return top 5 rows in oracle?

1 Answers  

---

What is oracle open database communication (odbc)?

1 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

How to do a full database export?

1 Answers  

---

How do I spool to a csv formatted file using sqlplus?

1 Answers  

---

What is the difference between alert log file and trace file ?

1 Answers  

---

What is the maximum number of triggers that can be applied to a single table?

1 Answers  

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1 Answers   Oracle,

---

Find all employees in Dept “Marketing”.

2 Answers  

---

What are the trigger associated with image items ?

1 Answers   Oracle,

---