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

Oracle General (1809)
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 3765

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

1 3806

Difference between NO DATA FOUND and %NOTFOUND?

1 4399

Can you use a commit statement within a database trigger?

4 5315

What WHERE CURRENT OF clause does in a cursor?

2 4107

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,

1901

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

4 5373

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 3054

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 3765

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 3284

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 3489

how to we delete a row using varray

CTC,

3 4507

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

MasterCard,

2 4266

difference between bind variable and variable

Attra,

1 3011

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

Attra, Metric Stream,

4 7210

Un-Answered Questions { Oracle }

What is ole automation?

How you find which the latest record in SCD type2 transformation is?

545

How will you differentiate between varchar & varchar2?

998

where the dff data will be stored

2358

how to reverse engineer views(how to load the data from views)?

507

what systems can odi extract and load data into?

538

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7579

can you convert or reverse engineer a fmx back to a fmb file?

1100

What is the Repository and how many types of repository?

538

What are nested tables?

1117

What are the file systems and volume management techniques used in oracle rac?

What are the different types of database users?

533

Difference between cartesian join and cross join?

975

Explain the wait events in statspack report 'db sequential real'?

580

What are the types of trigger in oracle?

926

For More Un-Answered { Oracle } Questions Click Here