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 is the functionality and features provided by oracle clusterware?

What is the function of grid naming service used in oracle rac

What are the benefits of oracle real application clusters (rac)?

What are the provisions and resources provided in the oracle’s cloud server?

Explain the oracle grid infrastructure?

Explain the hardware architecture used in oracle rac?

What are the tools provided in oracle enterprise manager?

What are the components required to manage oracle real application clusters database?

What are the key components of oracle’s maximum availability architecture?

How is clustered database important in oracle rac architecture?

Why is cluster verification utility so important in oracle rac?

What is the function of having virtual internet protocol address (vip) in oracle rac?

Explain the oracle real application clusters architecture?

What is the load balancing advisory?

Explain the purpose of oracle real application clusters (rac)?

Un-Answered Questions { Oracle }

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2026

Explain the dml?

981

What is the use of oracle?

1030

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1989

What is ELT? Or What is the difference between ODI and other ETL Tools?

687

How to open a cursor variable?

1035

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

What are the different editions of oracle?

1108

how to load the data with one flat file and one rdbms table using joins?

616

How is mapping of name of dll and function done?

Explain the purpose of oracle real application clusters (rac)?

What are the attributes of cursor?

1054

What is meant by a deadlock situation?

1109

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

553

Write a trigger example in oracle?

1063

For More Un-Answered { Oracle } Questions Click Here