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

Does oracle database need java?

1000

How do I uninstall oracle client from windows?

1007

What is oracle thin client?

1021

Does oracle charge for java?

1053

What is oracle database client?

1028

What is java oracle used for?

1017

What is a table in oracle?

974

What is oracle datasource?

980

What is the sid in oracle?

961

How do I connect to oracle?

1027

What is difference between sid and service name in oracle?

949

How do I manually create a database in oracle?

1013

How do I find my oracle client driver version?

1036

Is java required for oracle client?

991

What is oracle in java?

961

Un-Answered Questions { Oracle }

How to assign data of the deleted row to variables?

1070

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2619

What are the benefits of oracle rac?

What is execute immediate in oracle?

1013

Tell me step by step to enable Journalization?

633

Is oracle a relational database?

912

How would you go about verifying the network name that the local_listener is currently using?

2043

What do you understand by the term 'system change number (scn)'?

579

How to name query output columns in oracle?

1183

What is File steps?

614

What is oracle full backup?

566

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

530

Explain the use of decode function

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

584

where do u put the report file

2091

For More Un-Answered { Oracle } Questions Click Here