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 ?

2555

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 11580

what is meant by magic query

2186

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

2 11201

What is autonomous transaction?

6 12225

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 4910

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 4446

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

4 7903

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 7597

How to create placeholder columns?

2 26485

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

1 5783

Differnce between view and index

3 6135

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 14322

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26737

What are triggers?Where are they used?

3 6446

Un-Answered Questions { Oracle }

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

1028

What is da in database?

543

can u give guidance abt packages of plsql

2174

What are the Types of repositories in ODI?

584

Why should I use oracle database?

991

What are a cluster and non-cluster index?

1018

How to create id with auto_increment on oracle?

990

How to export data to a csv file?

1305

How to drop an index?

959

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2022

Explain the use of rows option in exp command.

1091

What language does oracle use?

1100

What is the difference between post-database commit and post-form commit?

1199

What is secure property?

For More Un-Answered { Oracle } Questions Click Here