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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the quickest way to export a table to a flat file?

968

How to loop through a cursor variable?

1085

How to do clean up if create database failed?

1028

What happens if you lost a data file?

1034

How remove data files before opening a database?

1072

How to export data with a field delimiter?

1039

How to create an initialization parameter file?

1049

What to do if the startbd.bat failed to start the xe instance?

1081

How to view the tablespaces in the current database?

978

How to create a single index for multiple columns?

1037

How to assign query results to variables?

1050

What is a directory object?

1097

How to call a sub procedure?

1093

How to retrieve values from data fields in record variables?

1116

What are the general rules on data consistency?

1009

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is partitioned table in Oracle?

1189

Can we store images in oracle database?

1009

How do I connect to oracle?

1030

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

How to open a cursor variable?

1035

How do you find current date and time in oracle?

1047

How to create lov dynamically at runtime & attach to text field?

1197

What is the difference between sharding and partitioning?

986

Explain the different normalization forms?

1098

What are a cluster and non-cluster index?

1018

What are the attributes of the cursor?

1004

What types of joins are used in writing subqueries?

982

How do I spool in oracle?

1004

How to count duplicated values in a column in oracle?

1041

How to divide query output into groups in oracle?

992

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