Answer Posted / akhilesh singh

schema is collection of objects
(table,view,procedure,function.....)

What is a proxy object?

1108

---

When do I need to use a semicolon vs a slash in oracle sql?

1142

---

What is an oracle user account?

1040

---

State the difference between a primary key and foreign key?

996

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

---

How many types of cluster table in Oracle?

1081

---

How to set up autotrace for a user account?

1112

---

How would you change old and new values in an insert, delete and update triggers?

1077

---

Can select statements be used on views in oracle?

1083

---

What is a subquery in oracle?

1167

---

Oracle

2423

---

What are the oracle differences between nvl and coalesce

1234

---

Where is the export dump file located?

1224

---

What is the sql query to concatenate column values from multiple rows in oracle?

1103

---

What is a subquery?

1191

---