Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 16885

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6970

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

2020

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

IPEC, Satyam, SunTec,

2159

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

Satyam,

3 7036

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 10791

which is the best training centre for learning oracle?

13 19445

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

8 12218

what is difference between table and view? where to use views? thanks in advance!

1 4811

What is the difference between Outer join and Full outer join?

5 40204

how to insert data into partitioned table partition done by Range partition

1 15515

What different of iner joint & outer joint with example

4 10031

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

ESS,

1 5414

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

ESS,

2311

how will I find the first 5 highest salaried employees in each dept in oracle.

IBM,

22 32801

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

how to join query for one source type is oracle another source type is sql server ?

2425

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

What is an external table?

1020

What is a read write transaction in oracle?

1093

What are the set operators union, union all, minus & intersect meant to do?

988

what is the difference between functional dependecy and multilevel dependency?

2462

What is a table index?

1098

Why is oracle used?

938

Explain the difference between a procedure and a function?

1170

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2065

How to delete all rows a table in oracle?

1068

How to lock and unlock a user account in oracle?

1106

How to count duplicated values in a column in oracle?

1041

What are joins, explain all types of joins?

2299

For More Un-Answered { Oracle General } Questions Click Here