Oracle General Interview Questions
Questions Answers Views Company eMail

How to run create database statement again?

615

How to run queries on external tables?

560

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

562

How to rename a column in an existing table?

611

How to view existing locks on the database?

541

How much memory your 10g xe server is using?

578

How to recover a dropped index?

1 906

How to assign values to data fields in record variables?

574

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

547

How to create tables for odbc connection testing?

485

What is a named program unit?

576

How to open a cursor variable?

600

What happens to indexes if you drop a table?

689

How to test null values?

668

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

523


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use select statement to count the number of rows in oracle?

549


Will you be able to store pictures in the database?explain.

529


Differentiate between function and procedure in oracle.

557


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2171


How to use subqueries with the in operator using oracle?

602






How can you use check constraints for self referential integrity?

520


What is the difference between post-database commit and post-form commit?

511


Explain the use of indexes option in imp command.

561


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

519


How to write a query with a left outer join in oracle?

597


types of indexes and the rationale behind choosing a particular index for a situation.

1976


How to update values in a table in oracle?

567


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1480


How to define default values for formal parameters?

586


How to run the anonymous block again?

591