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 3851

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

1 3887

Difference between NO DATA FOUND and %NOTFOUND?

1 4481

Can you use a commit statement within a database trigger?

4 5464

What WHERE CURRENT OF clause does in a cursor?

2 4236

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,

1949

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

4 5519

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 3140

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 3858

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 3374

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 3598

how to we delete a row using varray

CTC,

3 4667

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

MasterCard,

2 4368

difference between bind variable and variable

Attra,

1 3109

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

Attra, Metric Stream,

4 7369

Un-Answered Questions { Oracle }

Explain force logging feature in 9i.

608

How to write numeric literals in oracle?

1183

How many types of synonyms in Oracle?

1124

Can a formula column be obtained through a select statement ?

2324

If you see statistics that deal with "undo" what are they really talking about?

653

What are the execution control statements in oracle?

1095

What are a query and state the different types of queries and their uses?

1015

What is a oracle database?

1055

System tablespace cant be exported from one database and imported into another why?

555

what is the difference between restoring and recovering?

1011

What are the ways tablespaces can be managed and how do they differ?

2367

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2071

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1152

What are the possible ways to gain information regarding the control file?

569

What is the Cdc?

701

For More Un-Answered { Oracle } Questions Click Here