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?

1084

How to do clean up if create database failed?

1027

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?

1037

How to create an initialization parameter file?

1049

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

1079

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?

1112

What are the general rules on data consistency?

1009

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Reduced List of Values?

2164

Explain the use of grant option in imp command.

1026

What is the difference between a primary key & a unique key?

1089

How to commit the current transaction in oracle?

1120

Why do we need oracle client?

947

What's dateware house and what's clustor with practicle example

2175

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

What is the usage of analyze command in oracle?

1093

What are the different oracle database objects?

1091

interview questions with answer for cts

2581

What is PL/SQL ?

2057

How to create a stored procedure in oracle?

1102

How will you differentiate between varchar & varchar2?

1041

How to write an inner join with the where clause in oracle?

1044

What is Java Pool in Oracle?

1168

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