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 2496

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

Wipro,

1 4889

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,

1835

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

1362

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

1428

How to retrieve first and last records from a table?

DELL, QSmart,

7 9332

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

College School Exams Tests, DELL,

5 8621

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

Google,

1687

difference between procedures and function?

IBM,

7 8028

wirte the syntax of update query?

IBM,

3 4227

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

1430

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

3331

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

2 3203

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,

1345

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,

1635

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to export data to a csv file?

607

What is a named program unit?

565

Whats the benefit of dbms_stats over analyze?

1483

1835

How do I uninstall oracle 11g?

545

Oracle

1833

How to use like conditions in oracle?

559

How can we find out the current date and time in oracle?

632

Explain a private synonyms?

619

Explain joins in oracle?

553

What is not equal to in oracle?

513

How to create a new table in your schema?

594

What are data pump export and import modes?

596

How to bring a tablespace online?

505

How to drop a stored function?

665

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