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

Oracle General (1803)
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 ?

2603

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 11852

what is meant by magic query

2240

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

2 11322

What is autonomous transaction?

6 12443

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 5051

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 4516

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

4 8057

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 7722

How to create placeholder columns?

2 26613

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

1 5880

Differnce between view and index

3 6246

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 14543

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 27126

What are triggers?Where are they used?

3 6580

Un-Answered Questions { Oracle }

What are the attributes of the cursor?

1061

What are the major difference between truncate and delete?

1138

What are the logical operations?

1174

What is an index associated with a constraint?

1094

How do I become a dba?

628

What is a cursor variable?

1218

what is insert all statement in sql

6627

How to create an oracle testing table?

1130

Can you have more than one content canvas view attached with a window ?

2373

Explain the use of indexes option in imp command.

1266

What is a read write transaction in oracle?

1136

What is an oracle?

1069

How to use in conditions in oracle?

1119

What are the key characteristics of rac or why to use rac?

How to send the emails for odi?

755

For More Un-Answered { Oracle } Questions Click Here