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?

1077

How to view the dropped tables in your recycle bin?

1 1475

How to define an anonymous procedure without variables?

1093

How many data types are supported?

1077

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

1011

How to define default values for formal parameters?

1034

What are the restrictions on external table columns?

1051

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

1011

How to loop through data rows in the implicit cursor?

1066

How to create additional tablespaces for an new database?

1019

How many categories of data types?

985

Can you assign multiple query result rows to a variable?

982

How to use fetch statement in a loop?

1015

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

594

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

575

Un-Answered Questions { Oracle }

Mention what is oracle real application clusters?

What do you understand by the term 'normalization'?

666

How to move objects from DEV to QA and QA to PROD Environments?

707

If you see contention for library caches how you can fix it?

555

How to empty your oracle recycle bin?

1017

How do you analyze the tables

How to use subqueries with the exists operator in oracle?

1018

What are the different oracle database objects?

1084

How to create a single index for multiple columns?

1028

What are the goals of dba?

549

What do you mean by merge in oracle?

992

How to create an oracle database?

1031

What do you understand by the oracle?

546

How you find which the latest record in SCD type2 transformation is?

577

What is oracle latest version?

1092

For More Un-Answered { Oracle } Questions Click Here