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

Explain the wait events in statspack report 'db sequential real'?

636

Explain the wait events in statspack report 'db scattered read'?

581

What is your favorite tool for day-to-day oracle operation?

548

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

552

What is difference between co-related sub query and nested sub query?

567

What is oracle full backup?

570

What is pga_aggregate_target?

571

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

603

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

Tell me about standby database? What should we watch out for?

547

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

617

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

659

What are the steps involved in instance recovery in oracle?

550

What is oracle log switch?

619

Un-Answered Questions { Oracle }

What privilege is needed for a user to connect to oracle server?

994

How to view existing locks on the database?

1053

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2093

How to create a testing table in oracle?

989

How to convert characters to dates in oracle?

1100

When do I need to use a semicolon vs a slash in oracle sql?

1090

Difference between ETL and E_LT?

593

How to check your oracle database 10g xe installation?

987

How to shutdown your 10g xe server?

1149

what is normalisation?what are its uses?

2273

What is an oracle user account?

990

What exactly does a dba do?

578

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2280

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

How would you go about verifying the network name that the local_listener is currently using?

2049

For More Un-Answered { Oracle } Questions Click Here