Answer Posted / akki

column constraint is only for particular column to provide restriction,

where in table level constraint we define multiple constraint at same time except not null .

not null is only used for column level.

ex: create table customer(cust_id number(2) not null,cust_name varchar2(20)check(cust_name like 'C%');

above example is shows constraints on column level.

What are the different types of synonyms?

1197

---

What happens to the indexes if a table is recovered?

1045

---

How to convert dates to characters in oracle?

1090

---

What is Redo Log Buffer in Oracle?

1277

---

what is the use of system.effective.date variable in oracle?

1161

---

What is a nested table?

1109

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2100

---

How can we view last record added to a table?

1104

---

How do we represent comments in oracle?

1096

---

What are the differences between blob and clob in oracle?

1134

---

How to connect to a local oracle 10g xe server?

1032

---

IS it possible to built the oracle database without setting the kernal parameters?

2393

---

How to grant create session privilege to a user in oracle?

1050

---

Explain oracle’s system global area (sga).

1185

---

What is a sub query? What are its various types?

1270

---