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?

1108

How to enter a new row into a table interactively?

1012

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?

1047

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 }

How to call a stored function with parameters?

1045

How to use regular expression in pattern match conditions in oracle?

1041

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2159

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

What is connection pooling in oracle?

973

How to create a new view in oracle?

1078

What do you mean by Oracle MEDIA RECOVERY?

1226

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2192

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Is postgres faster than oracle?

1040

What is the sequence of firing in report trigger?

Difference between bind parameter and lexical parameter.

Mention what is cluster?

How to load a large xml file?

1055

How to pass parameters to procedures?

1034

For More Un-Answered { Oracle } Questions Click Here