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 16876

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6963

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

2017

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

IPEC, Satyam, SunTec,

2156

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

Satyam,

3 7033

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

1 10788

which is the best training centre for learning oracle?

13 19434

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

IBM,

8 12196

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

1 4808

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

5 40190

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

1 15506

What different of iner joint & outer joint with example

4 10019

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

ESS,

1 5410

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

ESS,

2307

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

IBM,

22 32750

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are named parameters?

1087

What is ordinary table in oracle?

1151

How to delete a column in an existing table in oracle?

1069

How can Oracle users be audited?

1106

How to create a testing table in oracle?

988

Is oracle a programming language?

985

How to insert multiple rows with one insert statement in oracle?

1083

How is it different from a normal table?

1028

How to join two tables in a single query using oracle?

992

What are the differences between char and nchar in oracle?

1092

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2181

How to get a list of all background sessions in the database?

991

Differentiate between translate and replace?

1110

What is tns entry?

1143

Why do you use stored procedures and state some of its disadvantages?

1026

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