1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
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 4891

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 16688

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

 5 9073

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

EDC,

1622

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

EDC,

2054

what is meant by magic query

 1764

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

 2 10212

What is autonomous transaction?

 6 9874

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 3961

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 3799

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

 4 6498

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 6233

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

 1 4871

Differnce between view and index

 3 4959

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 12174

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain overloading. Can functions be overloaded?

563

Why does for update in oracle 8 cause an ora-01002 error?

532

How to display employee records who gets more salary than the average salary in the department?

584

What is oracle analytical function?

520

What is varray?

578




What are the major difference between truncate and delete?

509

How many memory layers are in the oracle shared pool?

632

What is parameterized cursor in oracle?

566

What is proxy method?

534

What is oracle latest version?

572

What is raw datatype?

583

How to bring a tablespace online?

510

How to create a new view in oracle?

601

What is recovery manager(rman) backup in Oracle?

615

How to use windows user to connect to the server?

527

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