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?

1160

How to run queries on external tables?

1051

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

1071

How to rename a column in an existing table?

1037

How to view existing locks on the database?

1057

How much memory your 10g xe server is using?

1106

How to recover a dropped index?

1 1574

How to assign values to data fields in record variables?

1038

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

1103

How to create tables for odbc connection testing?

1124

What is a named program unit?

1092

How to open a cursor variable?

1041

What happens to indexes if you drop a table?

1171

How to test null values?

1112

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

1037

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2266

How do I manually uninstall oracle client?

1095

What are the various constraints used in oracle?

1048

What is Undo Management Advisor in Oracle?

1102

What is Reduced List of Values?

2173

What is translate in oracle?

1101

How to start an oracle instance?

1025

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2081

What is a subquery?

1127

How to filter out duplications in the returning rows using oracle?

1020

How to start your 10g xe server from command line?

1074

How to assign a table row to a record variable?

1046

What is materialized view in Oracle?

1076

What is connection pool in oracle?

992

Explain a data segment?

1073

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