Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 4180

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 12957

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

5 7735

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

EDC,

1188

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

EDC,

1610

what is meant by magic query

1376

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

2 9458

What is autonomous transaction?

6 8336

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 3256

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 3244

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

4 5524

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 5235

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

1 4305

Differnce between view and index

2 4045

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 10793


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

State and explain about oracle instance?

218


How to download oracle database 10g xe?

228


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2549


What is an index associated with a constraint?

207


master table and child table performances and comparisons in Oracle ?

1287






What is the use of file param in imp command?

256


What is rowid and rownum in oracle?

188


What are the logical operations?

236


Are truncate and delete commands same? If so why?

217


How to define a record variable to store a table row?

197


How will you identify oracle database software release?

196


How to return top 5 rows in oracle?

231


How to start instance with a minimal initialization parameter file?

197


How to call a stored function with parameters?

205


How to display row numbers with the records?

219