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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2548

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

TCS,

7 11551

what is meant by magic query

2176

Define the terms primary key foreign key and also the difference between primary and the unique key

2 11192

What is autonomous transaction?

6 12202

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 4885

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 4433

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 7887

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

Digital Group,

3 7558

How to create placeholder columns?

2 26472

can any one help me with import/export options in oracle............

1 5776

Differnce between view and index

3 6117

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

TCS,

6 14292

what is difference between sap and oracle applications and which is now market leader?

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26669

What are triggers?Where are they used?

3 6435

Un-Answered Questions { Oracle }

How to filter out duplications in the returning rows using oracle?

1015

What do you understand from cache fusion?

What is oracle thin client?

1020

What is dynamic proxy?

1000

What is the difference between restoring a database and recovering a database?

What happens to the current transaction if the session is killed?

983

Explain the wait events in statspack report 'db sequential real'?

630

How many types of auditing in Oracle?

1030

What is rowid and rownum in oracle?

1007

Explain oracle’s system global area (sga).

1134

How to rename a column in an existing table?

1033

What is the main function of database?

603

How to assign values to data fields in record variables?

1029

What are the extensions used by oracle reports?

1032

What is the use of oracle?

1027

For More Un-Answered { Oracle } Questions Click Here