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 create a stored program unit?

1228

How to call a stored function with parameters?

1045

How to turn on or off recycle bin for the instance?

1083

How to assign a table row to a record variable?

1040

How to define an anonymous procedure with variables?

1159

How to declare a local variable?

1115

What is a table index?

1098

How a database is related to tablespaces?

1031

How to define a specific record type?

1084

How to estimate disk space needed for an export job?

1050

How to use "if" statements on multiple conditions?

1174

What is the data pump import utility?

1035

How to update a table row with a record?

1009

What is an index associated with a constraint?

1040

What are the numeric comparison operations?

1111

Un-Answered Questions { Oracle }

Write a trigger example in oracle?

1063

Explain the use of indexes option in exp command.

1149

What is a user function?

650

What is oracle update statement with inner join ?

1059

How to convert characters to times in oracle?

1023

What is the normalization?

594

What is difference between logical standby database and physical standby database?

673

What is the anchoring in reports?

interview questions with answer for cts

2583

Explain a data segment?

1068

Explain cascading triggers.

1073

Is truncate autocommit in oracle?

1087

What are the different responsibilities of a dba?

722

What is set operator oracle?

979

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2230

For More Un-Answered { Oracle } Questions Click Here