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?

1107

How to enter a new row into a table interactively?

1010

How to build data dictionary view an new database?

1009

How to get a create statement for an existing table?

969

How to pass parameters to procedures?

1034

How to use "in" parameter properly?

1071

How to run create database statement again?

1154

How to run queries on external tables?

1046

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

1067

How to rename a column in an existing table?

1035

How to view existing locks on the database?

1053

How much memory your 10g xe server is using?

1103

How to recover a dropped index?

1 1570

How to assign values to data fields in record variables?

1035

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

1102

Un-Answered Questions { Oracle }

What is the difference between formal parameters and actual parameters?

1088

What are property classes?

How to define a variable of a specific record type?

1078

What are active transformation / passive transformations?

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

628

what is profile in odi?

649

How to write text literals in oracle?

1068

How to drop an existing table in oracle?

1058

What is dump destination? What are bdump, cdump and udump?

562

What is max rowid in oracle?

1025

Is truncate autocommit in oracle?

1087

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

How to open a cursor variable?

1035

What is the difference between truncate & delete command?

1182

What exactly do quotation marks around the table name do?

963

For More Un-Answered { Oracle } Questions Click Here