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 4782

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.

1981

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

2 4312

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

BPO, Excel, Wipro,

9 17922

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

2087

i have marks in table,how to find total?

1 5403

what is an object groups?

2 20301

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 4284

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

1 5044

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

2249

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

1946

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

1 4445

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.

2289

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 happens if the imported table already exists?

1085

What is the relation between database and instance?

705

Point out the difference between user tables and data dictionary?

1042

What is a schema in oracle?

1073

What is a dba certification?

646

How to write an inner join with the where clause in oracle?

1098

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2877

how to dynamically change the page size of d2k reports?

How to define a data field as not null?

1168

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3106

What are elements of administration?

646

How to create a stored procedure in oracle?

1160

What to do if the binary spfile is wrong for the default instance?

1111

How to get execution statistics reports on query statements?

1159

Why do we use bulk collect in oracle?

1115

For More Un-Answered { Oracle } Questions Click Here