Oracle General Interview Questions
Questions Answers Views Company eMail

How to run create database statement again?

613

How to run queries on external tables?

557

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

557

How to rename a column in an existing table?

609

How to view existing locks on the database?

539

How much memory your 10g xe server is using?

573

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?

541

How to create tables for odbc connection testing?

485

What is a named program unit?

568

How to open a cursor variable?

598

What happens to indexes if you drop a table?

686

How to test null values?

664

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

519


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a oracle database?

594


How to execute the package in oracle?

561


What is the relation of a user account and a schema?

600


Explain oracle data types with examples?

566


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

981






hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1557


Explain do view contain data?

574


How to define an anonymous procedure without variables?

540


How to join two tables in a single query using oracle?

557


What language does oracle use?

587


How to display row numbers with the records?

574


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1430


How to find out what oracle odbc drivers are installed?

560


How to define an anonymous block?

610


Explain about achiever in sql?

576