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 ?

2513

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 11325

what is meant by magic query

2139

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

2 11098

What is autonomous transaction?

6 11987

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 4771

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 4383

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

4 7742

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 7439

How to create placeholder columns?

2 26347

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

1 5706

Differnce between view and index

3 6029

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 14116

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26393

What are triggers?Where are they used?

3 6303

Un-Answered Questions { Oracle }

What is the difference between sharding and replication?

971

candidate key is subset of super key but not vice-verse explain

2022

Were you involved in any data conversion, which one?

How to delete an existing row from a table in oracle?

1022

What is a synonym? What are its various types?

1051

How to define an external table with a text file?

1026

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

539

What is a nested table and how is it different from a normal table?

994

how report can be generated if we have the database designed in oracle 10g?

1839

Explain the oracle real application clusters architecture?

What is explain plan and how is it used?

548

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1334

What is BBED in Oracle?

1098

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

4480

Explain what are clusters?

1054

For More Un-Answered { Oracle } Questions Click Here