1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

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

EDC,

2058

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 9387

what is meant by magic query

 1769

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

 2 10227

What is autonomous transaction?

 6 9913

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 3976

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 3808

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

 4 6510

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 6244

How to create placeholder columns?

 2 25288

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

 1 4885

Differnce between view and index

 3 4976

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 12200

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 23249

What are triggers?Where are they used?

 3 5228

Un-Answered Questions { Oracle }

How to add a new column to an existing table with a default value?

542

What is an external table?

586

Mention what is new feature in oracle asm 12c?

1

What are the benefits of oracle rac?

1

what is load plans and types of load plans?

272




Explain a synonym?

601

What are the set operators union, union all, minus & intersect meant to do?

560

How many types of km's?

294

Is the After report trigger fired if the report execution fails ?

2402

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1470

When configuring sqlnet on the client what files need to be set up?

259

how to pass a variable more than one values?

369

What are the components required to manage oracle real application clusters database?

1

What is Undo Management Advisor in Oracle?

609

How to use select statement to count the number of rows in oracle?

553

For More Un-Answered { Oracle } Questions Click Here