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 }

Explain an integrity constrains?

1149

What is set verify off in oracle?

1103

as a technical developer in oracle applications which type errors feced in your experience sofar

2181

Is there a combination of "like" and "in" in sql?

1065

Explain procedure to change characterset of a database.

633

How to view the tablespaces in the current database?

978

What is bulk copy or bcp in oracle?

1124

What are the tools provided in oracle enterprise manager?

What are the oracle built-in data types?

1065

What does a dba stand for?

579

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

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1209

What is sharded cluster?

1015

Will you be able to store pictures in the database?explain.

992

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008

For More Un-Answered { Oracle } Questions Click Here