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

Oracle General Interview Questions

Questions Answers Views Company eMail

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 3220

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

Wipro,

1 5823

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

Cisco,

2323

Respected sir, Please send me technical questions related to oracle apps..

1813

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

How to retrieve first and last records from a table?

DELL, QSmart,

7 12025

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

College School Exams Tests, DELL,

5 10710

What is integrity and what is constraint??Explain with example

Google,

2284

difference between procedures and function?

IBM,

7 10402

wirte the syntax of update query?

IBM,

3 5500

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

what is difference between sql plus and sql*plus? (not sql and sql plus).

3902

where we have to use ON clause and where we have to use USING clause in JOINS

2 4201

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

Wipro,

1848

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

Wipro,

2116

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is the difference between restoring and recovering?

1011

What is recovery manager(rman) backup in Oracle?

1185

Give the various exception types.

993

How to create a temporary table in oracle?

1270

Explain the difference between sql and oracle?

1079

What to do if dba lost the system password?

1172

What is tns name?

981

Explain do view contain data?

1013

What is the usage of save points in oracle database?

964

How do I spool in oracle?

1004

What is an oracle database?

1035

What's dateware house and what's clustor with practicle example

2175

What happens to indexes if you drop a table?

1171

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

What is meant by raw datatype?

1060

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