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 3813

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

Baidu,

1 4426

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

1478

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

2 3108

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

BPO, Excel, Wipro,

9 15029

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

1607

i have marks in table,how to find total?

1 4617

what is an object groups?

2 18669

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 3533

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

1 4221

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

1483

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

1447

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

1 3576

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.

1687

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,

1762


Un-Answered Questions { Oracle }

How to start an oracle instance?

567


How to drop an index?

537


How to retrieve values from data fields in record variables?

557


What are the knowledge modules types?

284


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1767






Which process writes data from data files to database buffer cache?

279


List five most important parameter in 9i affecting performance?

273


Explain an exception?

560


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

851


Can we call procedure inside function in oracle?

599


Give the various exception types.

538


material view and view disadvantages?

628


How to shutdown your 10g xe server from command line?

550


Explain the difference between a procedure and a function? What do you understand by those terms?

615


How do you store pictures in a database?

552