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 joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 57754

what are Triggers?

TCS,

4 6829

what are stored procedures?

TCS,

6 5288

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

TCS, Green Info Solutions,

7 10049

what are views?

TCS,

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?

CA,

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.

273


how may join possible between (requisition with purchase order)

654


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

811


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

539


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

330


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

681


What is the mandatory setup in cyclecount ?

1000


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

3174


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

593


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

832


what are archived logs?

847


when All datafiles related to a Tablespace are removed ?

691


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

645


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

480


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

2642