Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 14020

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 57857

What are inner join and outer join?

3 7196




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 58637

what are Triggers?

TCS,

4 7100

what are stored procedures?

TCS,

6 5540

what are indexes..how many types of index's are there and what are they?

TCS, Green Info Solutions,

7 10341

what are views?

TCS,

7 11835

what is the difference between oracle 81,91,11i

Oracle, i2,

2 13844

How client makes connection with server in client/server architecture?

CA,

1 1962

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 2543

For web applications from which version of Oracle is suitable?

1 2774

What are the main diff. between oracle 7.3 and oracle 8i?

1 2655

What is Statement Auditing ?

2 2126

What are the use of Roles ?

3 2356







Un-Answered Questions { Oracle }

What are the Roles and responsibilities of database administrator?

1291


Can anybody give me link for BOXI R3.1 Key please

1320


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

832


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

644


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2758


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

633


What is Tax Categories?

622


please send me oracle pl/sql exp resume. and also faqs...

1069


What are the different windows events activated at runtime ?

1535


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

980


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.

2273


what is Single Byte Overhead...?

1026


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

2229


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

724


what is reindexing?

177