Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

1157

How to view the dropped tables in your recycle bin?

1 1566

How to define an anonymous procedure without variables?

1196

How many data types are supported?

1140

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

1063

How to define default values for formal parameters?

1096

What are the restrictions on external table columns?

1115

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

1064

How to loop through data rows in the implicit cursor?

1120

How to create additional tablespaces for an new database?

1080

How many categories of data types?

1043

Can you assign multiple query result rows to a variable?

1040

How to use fetch statement in a loop?

1070

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

637

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

631

Un-Answered Questions { Oracle }

What is the page protect in reports?

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1484

Explain the use of table functions.

2588

How to use fetch statement in a loop?

1070

What command is used to type files to the screen?

635

How can you merge two tables in oracle?

1051

where the dff data will be stored

2543

What is forms_mdi_window?

How to convert csv to table in oracle?

1049

How to select some columns from a table in oracle?

1178

What is a nvl function?

1097

What is the difference between PFILE and SPFILE in Oracle?

1112

How do I manually create a database in oracle?

1073

Is oracle an open source?

1128

Who is a database user?

587

For More Un-Answered { Oracle } Questions Click Here