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

What is the difference between formal parameters and actual parameters?

1014

How to view the dropped tables in your recycle bin?

1 1406

How to define an anonymous procedure without variables?

1032

How many data types are supported?

1033

How to connect to the server with user account: sys?

979

How to define default values for formal parameters?

992

What are the restrictions on external table columns?

1001

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

963

How to loop through data rows in the implicit cursor?

1021

How to create additional tablespaces for an new database?

976

How many categories of data types?

942

Can you assign multiple query result rows to a variable?

935

How to use fetch statement in a loop?

980

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

557

How do you use automatic pga memory management with oracle 9i and above?

541

Un-Answered Questions { Oracle }

How to convert character types to numeric types?

1059

What is the easiest method to create a file on unix?

535

How to use subqueries with the exists operator in oracle?

976

How to connect ms access to oracle servers?

947

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2056

What is the difference between formal parameters and actual parameters?

1014

how to join query for one source type is oracle another source type is sql server ?

2388

What is an Integrity Constrains in Oracle?

1141

How to define an oracle cursor variable?

980

What is SQL Tuning Advisor in Oracle?

1116

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

971

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

515

How oracle flex asm works?

Why do we use materialized view instead of table or views?

What is current record attribute property?

For More Un-Answered { Oracle } Questions Click Here