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 11200

What is autonomous transaction?

6 12224

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 4905

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 7901

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 7591

How to create placeholder columns?

2 26485

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

1 5781

Differnce between view and index

3 6132

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 14319

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26729

What are triggers?Where are they used?

3 6446

Un-Answered Questions { Oracle }

What is different type of rman backup?

665

How do you prevent output from coming to the screen?

528

Is it possible to have multiple layouts in a report?

1026

What is where clause in oracle?

1026

What is a flashback query and when should it be used?

What is set operator oracle?

978

What is the sid in oracle?

963

Which is faster join or subquery in oracle?

995

Step by step explain for the Flat file?

672

Explain alias?

1147

How to shutdown your 10g xe server?

1147

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

How many categories of data types?

994

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

Explain the use of inctype option in exp command.

1034

For More Un-Answered { Oracle } Questions Click Here