What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

In the oracle version 9.3.0.5.0, what does each number shows?

0 Answers  

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

Explain the use of record option in exp command.

0 Answers  

---

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

---

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,

---

What is the use of aggregate functions in oracle?

0 Answers  

---

Explain the difference between sql and oracle?

0 Answers  

---

What are the extensions used by oracle reports?

0 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

How to view all columns in an existing table?

0 Answers  

---