Answer Posted / riddhi

Difference between column level constraints and table level constraints
1)Column level constraint is declared at the time of creating a table but table level constraint is created after table is created.
2)Column Level Constraints refers Only One Column whereas table level constraints refers to one or more than one column
3)not null constraint can't be created as table level constraints because it don't have name.
Column level constraint-

Ex : Create table emp
( empno number primary Key);
Table level constraint

Ex: Create table emp
( empno number);
Constraints pk_con primary Key(empno));

Can objects of the same schema reside in different tablespace?

1062

---

What is connection pooling in oracle?

973

---

What is BBED in Oracle?

1154

---

How to do paging with oracle?

999

---

what are actual and formal parameters?

1104

---

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

1003

---

Explain the difference between replace() and translate() functions in oracle?

1036

---

How to load excel data sheet to oracle database

1024

---

What is a connect identifier?

1039

---

What are the execution control statements?

1065

---

Explain compound trigger in oracle?

1039

---

How to invoke the data pump export utility?

1187

---

How to invoke the data pump import utility?

1165

---

List out the components of logical database structure of oracle database.

1039

---

How to create a testing table in oracle?

990

---