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 to run create database statement again?

1154

How to run queries on external tables?

1046

What privilege is needed for a user to delete rows from tables in another schema?

1067

How to rename a column in an existing table?

1035

How to view existing locks on the database?

1053

How much memory your 10g xe server is using?

1103

How to recover a dropped index?

1 1570

How to assign values to data fields in record variables?

1035

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

1102

How to create tables for odbc connection testing?

1117

What is a named program unit?

1082

How to open a cursor variable?

1035

What happens to indexes if you drop a table?

1169

How to test null values?

1106

How to define a data source name (dsn) in odbc manager?

1030

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a cursor variable?

1128

Explain a data segment?

1068

What would you do with an in-doubt distributed transaction?

1978

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

988

How to export your own schema?

1007

How many types of synonyms in Oracle?

1124

How to use windows user to connect to the server?

988

What is the difference between a hot backup and a cold backup in oracle?

1015

What is background process in Oracle?

1101

what is the difference between functional dependecy and multilevel dependency?

2462

What to do if dba lost the system password?

1172

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2026

What is the use of file param in imp command?

1165

what is port in oracle? how is it related to database application.

1949

Point out the difference between user tables and data dictionary?

982

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