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 3288

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

Wipro,

1 5890

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,

2379

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

1867

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

1921

How to retrieve first and last records from a table?

DELL, QSmart,

7 12250

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

College School Exams Tests, DELL,

5 10882

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

Google,

2336

difference between procedures and function?

IBM,

7 10628

wirte the syntax of update query?

IBM,

3 5617

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

1918

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

3941

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

2 4301

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,

1890

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,

2173

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

1148

What is meant by raw datatype?

1116

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1158

Explain view?

1085

How can I create database in oracle?

1066

What is a cognitive schema?

1031

How to drop a stored procedure in oracle?

1103

How to invoke the data pump import utility?

1224

How to update values in a table in oracle?

1076

What are the advantages of oracle?

1068

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1788

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2188

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2365

Explain what are the uses of rollback segment?

1065

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