Answer Posted / s. senthil kumar

HOW TO CREATE TABLE FOR IMAGE FILE?

create table image_table (
file_id number,
file_desc varchar2(30),
file_loc bfile,
file_type varchar2(4));

HOW TO INSERT IMAGE FILE IN TABLE?

INSERT INTO image_table
VALUES(1,'Senthil
photo',bfilename('c:\photos','Kanneer.jpg'),'JPEG');

State the difference between a primary key and foreign key?

937

---

How to create additional tablespaces for an new database?

1031

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1908

---

Explain the function of optimizer in oracle?

1145

---

How many types of table in Oracle?

1128

---

How to use subqueries with the in operator using oracle?

1091

---

How to rebuild an index in oracle?

1028

---

Is oracle a language?

951

---

Where is the export dump file located?

1159

---

How to load excel data sheet to oracle database

1029

---

Use of an integrity constraint is better to validate data. Explain

1042

---

What is the difference between count (*), count (expression), count (distinct expression)?

1011

---

What happens if the update subquery returns multiple rows?

1116

---

What is the usage of save points in oracle database?

964

---

How to create an oracle database?

1049

---