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 the execution control statements in oracle?

1097

How to create a testing table in oracle?

990

How to use in conditions in oracle?

1058

How to convert dates to characters in oracle?

1042

How to update values on multiple rows in oracle?

1034

How to divide query output into groups in oracle?

992

How to use select statement to count the number of rows in oracle?

1046

How does oracle handle read consistency?

1098

What is the oracle implicit cursor?

1064

What is a subquery in oracle?

1110

What are group functions in oracle?

1042

How to check the oracle tns settings?

1047

How to delete a user account in oracle?

975

How can windows applications connect to oracle servers?

1057

How to write date and time literals in oracle?

1002

Un-Answered Questions { Oracle }

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

Explain the different normalization forms?

1103

what are the tools used for oracle 10g in real time.

2441

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

1209

How to synchronize 2 schema's objects?

2181

How you find which is the latest record in SCD type2 transformation?

590

What are the types of profiles in ODI?

595

How many control files should you have?

591

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1948

Difference between vat and property class.

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

585

What does database administrator do?

577

How can we generate report output in excel format?

997

What is SQL access advisor in Oracle?

1191

For More Un-Answered { Oracle } Questions Click Here