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

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 4686

how oracle will recognise its space is 100gb if 100gb is allocated for it...

Baidu,

1 5175

Hi Can any one tell me what are the API's used in requisition import.

1923

How do we switch from init.ora file to asp file?

2 4184

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

BPO, Excel, Wipro,

9 17601

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

i have marks in table,how to find total?

1 5310

what is an object groups?

2 20173

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 4212

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 4962

what are steps for interface? where is exchange rate defined in which table?

2158

how report can be generated if we have the database designed in oracle 10g?

1888

how report can be generated if we have the database designed in oracle 10g?

1 4356

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2230

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

HCL,

2280

Un-Answered Questions { Oracle }

Explain the types of exception?

1143

How to compare dates in oracle sql?

1102

What is the difference between sharding and partitioning?

986

What is system tablespace?

1097

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1347

What are the logical operations?

1125

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

1209

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1776

What is analyze command used for?

1072

How can you use check constraints for self referential integrity?

969

How do I become a dba?

583

How to list all indexes in your schema?

1093

Mention in rac what files should be created on shared storage?

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

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

For More Un-Answered { Oracle } Questions Click Here