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?

582

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?

589

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 }

What are the limitations of check constraint?

1033

Explain odi architecture?

613

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

550

candidate key is subset of super key but not vice-verse explain

2068

What is a synonym? What are its various types?

1110

Step by step explain for the Flat file?

672

What are the ways tablespaces can be managed and how do they differ?

2365

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558

What are the Types of repositories in ODI?

584

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

How to create a stored procedure in oracle?

1102

How to select all columns of all rows from a table in oracle?

1052

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2324

What is an Oracle index?

1655

What are the different types of database users?

572

For More Un-Answered { Oracle } Questions Click Here