Answer Posted / nageswararao.kamineni

we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.

What are the attributes that are found in a cursor?

1010

---

Briefly explain what is literal? Give an example where it can be used?

968

---

In which language oracle has been developed?

1013

---

What is oracle latest version?

1036

---

Can we write insert statement in function in oracle?

1025

---

What are a query and state the different types of queries and their uses?

940

---

What is rowid and rownum in oracle?

951

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4290

---

What is oracle in java?

906

---

Difference between varchar and varchar2 data types?

1114

---

What is data type in oracle?

1037

---

How to delete an existing row from a table in oracle?

1011

---

What is Virtual Private Database in Oracle?

1014

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

---

How to get the Installed Oracle Version Information ?

1069

---