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 the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1158

---

How to find the duplicate rows count from employees table in oracle?

1143

---

How do you bind variables in oracle?

1019

---

What does sharding mean?

1052

---

What are the different windows events activated at runtime ?

2941

---

Explain a private synonyms?

1095

---

How can we find out the current date and time in oracle?

1129

---

Explain the use of inctype option in exp command.

1080

---

How can we create the complete backup of data in the oracle.

2199

---

Which is faster join or subquery in oracle?

1046

---

How to fetch the row which has the max value for a column?

1042

---

How to define an explicit cursor in oracle?

1098

---

How to use attributes of the implicit cursor in oracle?

1061

---

What is an oracle transaction?

1225

---

List the parts of a database trigger.

1108

---