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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to define a data field as not null?

1103

How to enter a new row into a table interactively?

1006

How to build data dictionary view an new database?

1002

How to get a create statement for an existing table?

965

How to pass parameters to procedures?

1028

How to use "in" parameter properly?

1060

How to run create database statement again?

1150

How to run queries on external tables?

1038

What privilege is needed for a user to delete rows from tables in another schema?

1064

How to rename a column in an existing table?

1033

How to view existing locks on the database?

1047

How much memory your 10g xe server is using?

1097

How to recover a dropped index?

1 1563

How to assign values to data fields in record variables?

1029

How to create a new table by selecting rows from another table?

1076

Un-Answered Questions { Oracle }

How do I become an administrator?

579

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

What is redo log?

1057

List out the components of logical database structure of oracle database.

1029

Tell me step by step to enable Journalization?

633

Have you attend the client meetings?

609

What is the difference between restoring a database and recovering a database?

What is oracle in java?

961

What is the use of the drop option in the alter table command?

594

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

1006

Is there a function to split a string in plsql?

1050

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?

1940

What is the relation between database and instance?

640

What is CKM and when we will use this CKM?

566

What is an Oracle SYSTEM tablespace and when is it Created?

1104

For More Un-Answered { Oracle } Questions Click Here