Answer / Vipin Agarwal

A data file in Oracle Database is a physical file that contains the database's data. There are two main types of data files: tablespaces and control files. Tablespace data files store objects such as tables, indexes, clusters, and undo segments, while control files contain information about the structure of the database and its location.

How to divide query output into groups in oracle?

1 Answers  

---

what is the bitmap index?

3 Answers  

---

List the types of joins used in writing subqueries?

1 Answers  

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

can u call user defined functions in select statements

2 Answers  

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

What are the numeric comparison operations?

1 Answers  

---

6. Display the client name and order date for all orders using the traditional method.

1 Answers   Wipro,

---

What is the difference between translate and replace?

1 Answers  

---