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

How do you analyze table partition using oracle provided package?

520

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

765

What is oracle partial backup?

585

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

577

How do you put database is archivelog mode, explain procedure?

549

Do you need a commit after ddl statements?

561

Explain the wait events in statspack report 'enqueue'?

577

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

What is the difference between truncate and delete? Why is one faster?

648

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

587

What are bind variables and why are they important?

543

Explain force logging feature in 9i.

608

Which rman command is used to create an exact replica of a database innew host?

593

What operator tests column for the absence of data?

599

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

555

Un-Answered Questions { Oracle }

What is the dba role in oracle?

577

How to call a stored function with parameters?

1046

What is the scope of a local variable?

1067

Do you need a commit after ddl statements?

561

How does one get the view definition of fixed views/tables?

1021

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

590

How to write an inner join with the where clause in oracle?

1044

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7674

How to sort output in descending order in oracle?

1045

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2026

What is meant by joins? List out the types of joins.

1031

What are the system variables can be set by users? Explain them

Is it possible to have multiple layouts in a report?

1029

What is a subquery?

1122

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2265

For More Un-Answered { Oracle } Questions Click Here