Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to define a data field as not null?

1069

How to enter a new row into a table interactively?

969

How to build data dictionary view an new database?

968

How to get a create statement for an existing table?

916

How to pass parameters to procedures?

982

How to use "in" parameter properly?

1010

How to run create database statement again?

1087

How to run queries on external tables?

995

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

1025

How to rename a column in an existing table?

982

How to view existing locks on the database?

1005

How much memory your 10g xe server is using?

1059

How to recover a dropped index?

1 1500

How to assign values to data fields in record variables?

979

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

1028

Un-Answered Questions { Oracle }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2080

Point out the difference between user tables and data dictionary?

940

What is dual table oracle?

932

What are the execution control statements in oracle?

1037

What are the uses of a database trigger?

938

What are transaction isolation levels supported by oracle?

1009

Is oracle a language?

903

What is the variable?

582

What is a lookup table in oracle?

941

How to do clean up if create database failed?

983

What is oracle full backup?

529

What are set operators?

1035

System tablespace cant be exported from one database and imported into another why?

521

How do you set up your tablespace on installation level: low?

523

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

572

For More Un-Answered { Oracle } Questions Click Here