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');

How many types of segments in Oracle?

1114

---

What is a sub query? Describe its types?

1071

---

Explain the use of indexes option in exp command.

1208

---

Can we save images in a database and if yes, how?

1108

---

WHAT IS ecc 6.0

2201

---

What is the parameter mode that can be passed to a procedure?

1108

---

List the various oracle database objects?

1108

---

Can a parameter be passed to a cursor?

1179

---

How to loop through a cursor variable?

1126

---

In oracle there is column command, how will you explain that?

1135

---

What is Library Cache in Oracle?

1186

---

What is Segment Advisor in Oracle?

1145

---

What are the general rules on data consistency?

1060

---

Does oracle database need java?

1066

---

What is a relational database management system?

1170

---