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?

929

How to loop through a cursor variable?

1030

How to do clean up if create database failed?

988

What happens if you lost a data file?

992

How remove data files before opening a database?

1019

How to export data with a field delimiter?

986

How to create an initialization parameter file?

1000

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

1029

How to view the tablespaces in the current database?

933

How to create a single index for multiple columns?

990

How to assign query results to variables?

1018

What is a directory object?

1042

How to call a sub procedure?

1046

How to retrieve values from data fields in record variables?

1052

What are the general rules on data consistency?

965

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1977

How index is implemented in oracle database?

964

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1914

What is PL/SQL ?

1933

List the various oracle database objects?

1010

What is parameterized cursor in oracle?

1082

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1888

How to list all indexes in your schema?

1048

How to drop an index?

921

What are the different oracle database objects?

1041

What are the various types of snapshots ?

988

How to delete a column in an existing table?

1031

What is bulk copy or bcp in oracle?

1064

What are the predefined tablespaces in a database?

1022

Explain the use of full option in exp command.

1071

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