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));

What is difference between cartesian join and cross join?

1081

---

Can objects of the same schema reside in different tablespace?

1058

---

What is tns name?

974

---

What are the limitations oracle database 10g xe?

1037

---

What is redo log?

1055

---

How to execute a stored procedure in oracle?

1075

---

Explain the use of tables option in exp command.

1107

---

Explain an index?

1123

---

How can we delete duplicate rows in a table?

968

---

What are the execution control statements?

1061

---

How to experiment a data lock in oracle?

1052

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2964

---

What do you mean by group by clause?

1042

---

Why do we use bulk collect in oracle?

1056

---

Explain oracle insert into command?

1107

---