Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 13439

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

Wipro, BeBo Technologies,

7 56774

What are inner join and outer join?

3 6894

What are many types of joins are there?

CSC, TCS, Amdocs,

29 57754

what are Triggers?


4 6829

what are stored procedures?


6 5288

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

TCS, Green Info Solutions,

7 10049

what are views?


7 11455

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

Oracle, i2,

2 13602

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


1 1855

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

2 2442

For web applications from which version of Oracle is suitable?

1 2665

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

1 2556

What is Statement Auditing ?

2 2017

What are the use of Roles ?

3 2254

Un-Answered Questions { Oracle }

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.


how may join possible between (requisition with purchase order)


How can we create the complete backup of data in the oracle.


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??


what is a package n what r the packages availbla in report


What is the mandatory setup in cyclecount ?


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.


as a technical developer in oracle applications which type errors feced in your experience sofar


what are archived logs?


when All datafiles related to a Tablespace are removed ?


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE


How would you best determine why your MVIEW couldnt FAST REFRESH?


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