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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

HDFC,

1 5853

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 20744

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 10813

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

EDC,

2189

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

EDC,

2603

what is meant by magic query

2238

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 5047

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 4513

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

4 8054

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 7721

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

1 5877

Differnce between view and index

3 6245

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 14535

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the four Oracle system processes that must always be up and running for the database to be useable?

1056

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1130

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2394

How to convert dates to characters in oracle?

1096

How to Truncate Table in Oracle

1219

Differentiate between translate and replace?

1194

How to write text literals in oracle?

1124

What is a user account in oracle?

1173

how to handle exceptions in post production

1486

Is oracle an open source?

1128

How to convert characters to numbers in oracle?

1115

What are the tools for Oracle ?

1114

How to load excel data sheet to oracle database

1080

What is integrity and what is constraint??Explain with example

2347

When system tablespace is created?

1093

For More Un-Answered { Oracle General } Questions Click Here