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.

How to write text literals in oracle?

1015

---

What happens to the indexes if a table is recovered?

940

---

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

983

---

How to use an explicit cursor without open statements?

1011

---

What is an index associated with a constraint?

973

---

What is the database name in oracle?

967

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2245

---

How to find out what oracle odbc drivers are installed?

976

---

What is index-organized table in Oracle?

1018

---

Explain the difference between sap and oracle?

973

---

What are the differences between lov and list item?

989

---

what are bitmap indexes? How does they work?

2181

---

Calculate difference between 2 date / times in oracle sql?

985

---

How would you begin to troubleshoot an ORA-3113 error?

2022

---

What is difference between truncate and delete?

972

---