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?

1089

How to view the dropped tables in your recycle bin?

1 1482

How to define an anonymous procedure without variables?

1108

How many data types are supported?

1083

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

1024

How to define default values for formal parameters?

1048

What are the restrictions on external table columns?

1054

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

1015

How to loop through data rows in the implicit cursor?

1078

How to create additional tablespaces for an new database?

1031

How many categories of data types?

997

Can you assign multiple query result rows to a variable?

991

How to use fetch statement in a loop?

1022

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

597

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

589

Un-Answered Questions { Oracle }

How do I start tns listener?

1048

What is an oracle tablespace?

1046

What is the page protect in reports?

What are the different types of partitions in oracle?

979

Can we write insert statement in function in oracle?

1095

explain what is odi?why is it different from the other etl tools.

620

How to define an anonymous block?

1160

What are database skills?

587

What is a static data dictionary in oracle?

1115

What is a database table in oracle?

1024

What are the main functions of dba?

581

Explain what are the characteristics of data files?

1086

Differentiate between post-database commit and post-form commit?

1049

How can we monitor the space allocations in a database?

Do you need a commit after ddl statements?

565

For More Un-Answered { Oracle } Questions Click Here