Answer Posted / uday shankar chejerla

select clientnum,high_value_order from ordertab where
high_value_order=(select max(high_value_order) from
ordertab);

What is a user account in oracle?

1166

---

Explain do view contain data?

1047

---

Differentiate between pre-select and pre-query?

1153

---

What privilege is needed for a user to connect to oracle server?

1032

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1966

---

What is a synonym? What are its various types?

1168

---

How to speed up webrick?

1121

---

What are the types of trigger in oracle?

1026

---

What is a server parameter file in oracle?

1095

---

How to divide query output into groups in oracle?

1030

---

How to define a cusotmer as a supplier in ORACLE R12

2300

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1109

---

what is a Nested Loop join?

2170

---

What are a query and state the different types of queries and their uses?

1063

---

How to store pictures on to the database?

1030

---