Answer Posted / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

Differentiate between translate and replace?

1123

---

What is the usage of control file in oracle?

1090

---

How to check the oracle tns settings?

1047

---

Explain the use of show option in imp command.

1098

---

Can a formula column be obtained through a select statement ?

2330

---

How to create a new table in oracle?

1159

---

What is the sid in oracle?

968

---

How would you go about verifying the network name that the local_listener is currently using?

2049

---

How to delete all rows a table in oracle?

1068

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

---

How many anonymous blocks can be defined?

1187

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2293

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2124

---

What is bulk copy or bcp in oracle?

1124

---

What is an oracle database table?

1017

---