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 3215

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

Wipro,

1 5815

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,

2321

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

1811

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

1861

How to retrieve first and last records from a table?

DELL, QSmart,

7 12009

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

College School Exams Tests, DELL,

5 10699

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

Google,

2280

difference between procedures and function?

IBM,

7 10386

wirte the syntax of update query?

IBM,

3 5490

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

1863

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

3893

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

2 4198

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,

1843

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,

2110

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between "as" and "is" in an oracle stored procedure?

987

how to handle exceptions in post production

1418

How to estimate disk space needed for an export job?

1047

How to get maxsal , minsal, ename department wise in single query

1549

What is the data type of dual table?

991

In oracle there is column command, how will you explain that?

1049

How do I start tns listener?

1040

Explain drop constraint oracle?

1056

What do you mean by cdb and pdb in oracle 12c?

1059

What is a synonym? What are its various types?

1106

How to select some rows from a table in oracle?

1073

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2266

What are the oracle differences between nvl and coalesce

1145

Explain the difference between a procedure and a function?

1165

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1109

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