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 3841

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

1 3881

Difference between NO DATA FOUND and %NOTFOUND?

1 4470

Can you use a commit statement within a database trigger?

4 5448

What WHERE CURRENT OF clause does in a cursor?

2 4223

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,

1940

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

4 5502

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 3135

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 3849

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 3368

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 3584

how to we delete a row using varray

CTC,

3 4636

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

MasterCard,

2 4355

difference between bind variable and variable

Attra,

1 3093

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

Attra, Metric Stream,

4 7346

Un-Answered Questions { Oracle }

How do you bind variables in oracle?

978

How can Oracle users be audited?

1106

Difference between bind parameter and lexical parameter.

How can you find all the processes on your system?

566

How can we view last record added to a table?

1036

Discuss row chaining, how does it happen? How can you reduce it?

540

What are functions of dba?

548

Explain integrity constraints?

1102

How to use subqueries with the in operator using oracle?

1089

How can you merge two tables in oracle?

995

Explain constraining triggers.

1086

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

583

Differentiate between post-database commit and post-form commit?

1029

Have you attended the client meetings?

597

What is not equal to in oracle?

994

For More Un-Answered { Oracle } Questions Click Here