Answer Posted / guest

You can find here in the following link :
http://oraclebabu.blogspot.com/2008/04/oracle-certification-
to-z_29.html

What is oracle used for?

1030

---

Use of an integrity constraint is better to validate data. Explain

1046

---

Whether any commands are used for months calculation? If so, what are they?

1099

---

How to see free space of each tablespace?

1040

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2156

---

How to use "in" parameter properly?

1078

---

How to divide query output into groups in oracle?

996

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2197

---

What is the sid in oracle?

973

---

What is Reduced List of Values?

2180

---

How to delete multiple rows from a table in oracle?

1068

---

What are the differences between date and timestamp in oracle?

1054

---

What happens to the current transaction if the session is killed?

992

---

What is tns entry?

1164

---

Explain the use of rows option in exp command.

1100

---