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 4675

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

Baidu,

1 5162

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

1917

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

2 4178

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

BPO, Excel, Wipro,

9 17575

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??

2022

i have marks in table,how to find total?

1 5308

what is an object groups?

2 20160

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 4207

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

1 4954

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

2150

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

1879

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

1 4349

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.

2224

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,

2268

Un-Answered Questions { Oracle }

What is package and main advantages?

602

What is connection pooling in oracle?

964

What is an oracle recycle bin?

1006

How to bring a tablespace offline?

1055

How to create lov dynamically at runtime & attach to text field?

1169

What are the set operators union, union all, minus & intersect meant to do?

984

What are the tools for Oracle ?

1055

what is the dual table in oracle?

989

Why do we use bulk collect in oracle?

1058

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

2268

What happens if you set the sga too low in oracle?

1137

What is the difference between flex mode and confined mode?

1046

What is main function of database administrator?

566

Can you assign multiple query result rows to a variable?

984

How to define a variable of a specific record type?

1068

For More Un-Answered { Oracle } Questions Click Here