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 can we view last record added to a table?

1038

What is the maximum number of triggers that can be applied to a single table?

1023

What is the usage of merge statement?

1154

Explain the difference between a procedure and a function?

1169

What is the difference between $oracle_base and $oracle_home?

1089

State and explain the different types of data models?

944

What is key preserved table?

1021

What is a sub query and what are the different types of subqueries?

1125

What are the different pseudo commands? Explain in general?

1080

Explain the different normalization forms?

1097

State the various uses of dbcc command?

1060

What are a collation and state the different types of collation sensitivity?

1170

State the difference between a primary key and foreign key?

935

What are the different types of trigger and explain its various uses and functions?

1093

Explain about functional dependency and its relation with table design?

1010

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is clustered table in Oracle?

1196

What happens to the current transaction if the session is ended?

1098

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

How to convert characters to dates in oracle?

1100

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

What the is the diff between local index and global index. give some example.

1638

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

Why does oracle 9i treat an empty string as null?

1056

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

What are the major difference between truncate and delete?

1058

How to use like conditions in oracle?

1055

How to start a new transaction in oracle?

1088

Explain constraining triggers.

1094

What are the differences between interval year to month and interval day to second?

1026

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