Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 4776

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

Baidu,

1 5265

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

1979

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

2 4301

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

BPO, Excel, Wipro,

9 17915

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

2085

i have marks in table,how to find total?

1 5401

what is an object groups?

2 20294

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 4279

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

1 5042

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

2243

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

1945

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

1 4443

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.

2285

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,

2339

Un-Answered Questions { Oracle }

What is the history of ODI?

701

What is ordinary table in oracle?

1243

How to open a cursor variable?

1093

Can the query output be sorted by multiple columns in oracle?

1061

What is SKM and when we will use this SKM?

721

What is a procedure in oracle?

1288

What are the constraints are used in Ur project?

588

What is db_recovery_file_dest in oracle? When do you need to set this value?

1172

how to replace not in with not exist?

3807

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

2484

How do I connect to oracle database?

1204

Explain the use of record option in exp command.

1069

Explain the hardware architecture used in oracle rac?

Explain implicit cursor.

1076

Explain the difference between repeating frame and frame.

For More Un-Answered { Oracle } Questions Click Here