Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What are various constraints used in SQL?

Polaris,

1 3942

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3992

Difference between NO DATA FOUND and %NOTFOUND?

1 4577

Can you use a commit statement within a database trigger?

4 5631

What WHERE CURRENT OF clause does in a cursor?

2 4367

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

Oracle,

2014

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 5679

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

Oracle,

1 3218

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 3930

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 3447

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 3691

how to we delete a row using varray

CTC,

3 4796

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 4465

difference between bind variable and variable

Attra,

1 3198

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 7550

Un-Answered Questions { Oracle }

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2195

What is a user account in oracle?

1173

how can we store any pdf file in oracle

2223

How are extents allocated to a segment?

1183

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2339

a text item is there what r the different types of triggers associated with it

2086

What is different type of rman backup?

722

How would you determine what sessions are connected and what resources they are waiting for?

2181

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2345

Difference between lexical and bind varible.

Difference between pre-select and pre-query

1179

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161

What is a system tablespace?

1136

How to write a left outer join with the where clause in oracle?

1134

Difference between open_form and call_form in oracle.

1224

For More Un-Answered { Oracle } Questions Click Here