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

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Where do we use connected and un connected lookups?

How to determine what records to extract?

What are materialized views & where do we use them? What is a materialized view log?

How do you analyze the tables

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

550

How can be determining the size of the log files?

583

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

573

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

586

How can you tell if a tablespace has excessive fragmentation?

599

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

590

What is a database instance?

590

Which is the best option used to move database from one server to another serve on same network and why?

547

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

How can you determine the number of sqlnet users logged in to the unix system?

574

Un-Answered Questions { Oracle }

Discuss row chaining, how does it happen?

569

What is a staging area? Do we need it?

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2184

What is package and main advantages?

606

How to load a large xml file?

1055

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

590

What is the quickest way to fetch the data from a table?

1058

What is the difference between bind and lexical parameter?

1079

How to convert characters to numbers in oracle?

1065

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

551

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

Query to retrieve record for a many to many relationship ?

2519

What operating systems are supported by oracle database 10g xe?

1034

What is an Oracle database Full Backup?

1131

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1126

For More Un-Answered { Oracle } Questions Click Here