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 16890

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6973

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

2021

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

IPEC, Satyam, SunTec,

2161

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

Satyam,

3 7038

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

1 10795

which is the best training centre for learning oracle?

13 19448

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

IBM,

8 12228

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

1 4813

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

5 40210

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

1 15515

What different of iner joint & outer joint with example

4 10034

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

ESS,

1 5415

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

ESS,

2314

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

IBM,

22 32813

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to retrieve the count of updated rows?

1128

What is control file used for?

1209

How to invoke the data pump export utility?

1188

Describe the types of sub query?

999

What is difference between sid and service name in oracle?

956

How to start an oracle instance?

1019

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2145

What is the difference between view and materialized view in Oracle?

1156

How to use subqueries with the in operator using oracle?

1091

What is a trigger and what are its types in oracle?

1073

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

1935

What are the differences between number and binary_float in oracle?

1101

How can Oracle users be audited?

1116

Explain the use of Merge statement in oracle 11g

1029

Explain an extent?

1106

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