Oracle General Interview Questions
Questions Answers Views Company eMail

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

5 15216

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6107

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

1585

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

IPEC, Satyam, SunTec,

1672

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

Satyam,

3 5649

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

1 9977

which is the best training centre for learning oracle?

13 15902

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

IBM,

8 9822

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

1 4064

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

5 38131

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

1 14661

What different of iner joint & outer joint with example

4 8567

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

ESS,

1 4565

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

ESS,

1792

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

IBM,

22 26817


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What happens if you use a wrong connect identifier?

491


How to execute the package in oracle?

561


what are archived logs?

1700


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1447


What is a sub query and what are the different types of subqueries?

608






ABOUT IDENTITY?

1549


How to lock and unlock a user account in oracle?

600


Why do we use coalesce function in oracle?

614


What is rowid and rownum in oracle?

532


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1892


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

547


How view is different from a table?

536


How does one get the view definition of fixed views/tables?

585


How to create a stored function in oracle?

574


How to divide query output into groups in oracle?

550