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

Oracle General (1789)
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 2959

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

1 3056

Difference between NO DATA FOUND and %NOTFOUND?

1 3692

Can you use a commit statement within a database trigger?

4 3893

What WHERE CURRENT OF clause does in a cursor?

2 3159

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,

1465

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

4 4043

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 2356

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 3124

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 2624

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 2708

how to we delete a row using varray

CTC,

3 3324

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

MasterCard,

2 3262

difference between bind variable and variable

Attra,

1 2338

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

Attra, Metric Stream,

4 5870

Un-Answered Questions { Oracle }

How would you change old and new values in an insert, delete and update triggers?

537

What is a parameter file in oracle?

551

How many control files should you have?

263

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2387

Explain the use of online redo log files in oracle.

575

What is proxy method?

535

How to use null as conditions in oracle?

572

What are the types of windows (window style)?

What is a dba certification?

277

Explain oracle insert into command?

621

Explain a synonym?

593

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1594

Explain oracle’s server parameter file.

560

How to connect to a remote server?

549

How to run queries on external tables?

560

For More Un-Answered { Oracle } Questions Click Here