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 17069

why pl sql doesn't support retrieving multiple records

Mphasis,

1 7054

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

2066

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

IPEC, Satyam, SunTec,

2199

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

Satyam,

3 7172

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

1 10877

which is the best training centre for learning oracle?

13 19796

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

IBM,

8 12459

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

1 4869

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

5 40356

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

1 15582

What different of iner joint & outer joint with example

4 10222

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

ESS,

1 5483

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

ESS,

2357

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

IBM,

22 33354

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How different is ms access and oracle?

1089

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

2233

Give the various rollback segment states.

1088

What is the dynamic sql in oracle?

1130

How do I limit the number of rows returned by an oracle query after ordering?

1221

how may join possible between (requisition with purchase order)

2327

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

How to convert dates to characters in oracle?

1092

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1930

Explain the use of tables option in exp command.

1166

What would you do with an in-doubt distributed transaction?

2044

How to assign values to data fields in record variables?

1077

Can a formula column referred to columns in higher group ?

2550

What is the difference between a hot backup and a cold backup in oracle?

1074

What is the best way to do multi-row insert in oracle?

1107

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