Answer Posted / priya

Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.

What is the usage of synonyms?

575

---

Compare and contrast between sql and sql server and explain its various functions?

522

---

Can a formula column be obtained through a select statement ?

1843

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1797

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1174

---

---

What is rich query?

535

---

Explain the function of optimizer in oracle?

587

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2384

---

what are the advantages of running a database in archive log mode?

1726

---

how to join query for one source type is oracle another source type is sql server ?

1979

---

What is the difference between $oracle_base and $oracle_home?

576

---

Can you have more than one content canvas view attached with a window ?

1815

---

How to define a procedure inside another procedure?

537

---

Explain how you would restore a database using RMAN to Point in Time?

1622

---

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

636

---