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?

1091

How to run queries on external tables?

998

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

1028

How to rename a column in an existing table?

985

How to view existing locks on the database?

1005

How much memory your 10g xe server is using?

1061

How to recover a dropped index?

1 1501

How to assign values to data fields in record variables?

982

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

1032

How to create tables for odbc connection testing?

1029

What is a named program unit?

1031

How to open a cursor variable?

985

What happens to indexes if you drop a table?

1121

How to test null values?

1053

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

980

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How many types of tables are there in oracle?

1017

How to use "for" statements in oracle?

1028

What happens if you set the sga too low in oracle?

1073

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4481

Explain about integrity constraint?

1088

How to call a sub procedure?

1045

How can Oracle users be audited?

1067

How to handle a single quote in oracle sql?

983

What is meant by an index?

1070

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2429

Can you assign multiple query result rows to a variable?

938

how the indexes are stored in the Oracle Database?

2222

What is the usage of analyze command in oracle?

1048

What are the oracle differences between nvl and coalesce

1084

How many types of tables supported by oracle?

1028

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