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

Which function is used to find the largest integer less than or equal to aspecific value?

562

Explain procedure to change characterset of a database.

614

What is oracle archived redo log?

583

what does the no logging option do? Why would we use it?

548

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

554

List five most important parameter in 9i affecting performance?

553

What is the difference between rman and a traditional hotbackup?

1 1438

How can you tell if an index on particular table is used or not used in 9i?

560

You see a wait on lms process in statspack, what does that mean?

567

What does the no logging option do? Why would we be careful of using it?

597

Tell me about standby database? What are some of the configurations of it?

566

When using oracle export/import what character set concerns might come up? How do you handle them?

584

Which date function is used to find the difference between two dates?

574

How do you install statspack?

679

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

547

Un-Answered Questions { Oracle }

How many types of dba are there?

559

How to delete all rows a table in oracle?

1065

Does oracle partitioning improve performance?

986

How many categories of data types in oracle?

1024

What does dba stand for database?

592

1) Does oracle have any table which contain all the exceptions and it's code internally?

1747

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

What is the full form of dba?

597

What are the set operators union, union all, minus & intersect meant to do?

983

What do you mean by redo log file mirroring?

1022

How to divide query output into groups in oracle?

982

How to change user password in oracle?

1021

Give the constructs of a package, function or a procedure.

1028

How to create Drill down report?

2123

What is the difference between recovery and restoring of the oracle database?

1212

For More Un-Answered { Oracle } Questions Click Here