Answer Posted / binta

there are three types of database link:
private
public
network

Is truncate autocommit in oracle?

1060

---

does the query needs a hint to access a materialized view?

1844

---

What are the logical operations?

1102

---

Explain an integrity constrains?

1121

---

How many types of cluster table in Oracle?

1018

---

How to sort the query output in oracle?

1007

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1937

---

Why does for update in oracle 8 cause an ora-01002 error?

983

---

Explain the use of tables option in exp command.

1097

---

How to use subqueries with the exists operator in oracle?

1005

---

What is a table index in oracle?

1107

---

if you ctreate table identity

2353

---

How to add another datafile to a tablespace?

1016

---

What is Trigger in Oracle?

1135

---

How do I call oracle stored procedures that take no parameters?

1088

---