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 resolve name conflicts between variables and columns?

992

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

1050

How to rename an index?

1015

What is the scope of a local variable?

1013

What privilege is needed for a user to query tables in another schema?

935

How to initialize variables with default values?

1183

How to define a variable of a specific record type?

1028

What is an external table?

969

What are named parameters?

1047

How to connect to a remote server?

1070

What are the predefined tablespaces in a database?

1022

What happens if you use a wrong connect identifier?

998

How to login to the server without an instance?

1123

How to manage transaction isolation level?

960

How to export several tables together?

1003

Un-Answered Questions { Oracle }

How to list all indexes in your schema?

1048

What are the set operators union, union all, minus & intersect meant to do?

951

How does oracle handle read consistency?

1059

How to load a large xml file?

1011

What are the types of data contol?

573

How to add another datafile to a tablespace?

1004

What is the string concatenation operator in oracle?

1113

Where is the export dump file located?

1092

What are the file systems and volume management techniques used in oracle rac?

can we implement package in package?

542

What to do if the binary spfile is wrong for the default instance?

1015

What is object data modeling?

913

How to compare dates in oracle sql?

1063

Explain the use of file option in exp command.

1099

What are the uses of Oracle Rollback Segment?

1090

For More Un-Answered { Oracle } Questions Click Here