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 17602

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 5311

what is an object groups?

2 20174

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?

2159

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 }

How to use windows user to connect to the server?

989

What file will give you oracle instance status information? Where is it located?

625

What are the five functions of a database?

608

What are the file systems and volume management techniques used in oracle rac?

How to join two tables in a single query using oracle?

997

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5552

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

What are the most common interview questions on ETL Testing for experience?

1143

How to delete a column in an existing table in oracle?

1072

What are advantages of dateset in datastage?

2263

How would you determine what sessions are connected and what resources they are waiting for?

2127

Why does Oracle not permit the use of PCTUSED with indexes?

2424

Can multiple columns be used in group by in oracle?

988

What is meant by recursive hints in oracle?

1087

What do you understand by format trigger?

For More Un-Answered { Oracle } Questions Click Here