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 single index for multiple columns?

990

How to assign query results to variables?

1018

What is a directory object?

1042

How to call a sub procedure?

1046

How to retrieve values from data fields in record variables?

1052

What are the general rules on data consistency?

965

How to define a procedure inside another procedure?

974

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

1015

How to create a server parameter file?

1094

How to rename an existing table?

1061

What are the execution control statements?

1024

How to run create database statement?

988

What happens if the update subquery returns multiple rows?

1063

How to use "startup" command to start default instance?

980

What happens if the imported table already exists?

981

Un-Answered Questions { Oracle }

What are internal user account in oracle?

955

Explain an integrity constrains?

1095

Can we create database in oracle using command line ?

1040

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

551

What happens if you use a wrong connect identifier?

998

Explain what are clusters?

1058

how to do daily transactions with out sql* loader control file regesterd in apps?

1649

Can we convert a date to char in oracle and if so, what would be the syntax?

974

How do I become an administrator?

539

What is the use of the drop option in the alter table command?

560

How to recover a dropped table in oracle?

991

What is pga_aggregate_target?

531

Can a formula column be obtained through a select statement ?

2278

what is the dual table in oracle?

941

What are record groups ? Explain the types of record group.

For More Un-Answered { Oracle } Questions Click Here