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?

1090

How to view the dropped tables in your recycle bin?

1 1484

How to define an anonymous procedure without variables?

1111

How many data types are supported?

1085

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

1025

How to define default values for formal parameters?

1052

What are the restrictions on external table columns?

1055

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?

1080

How to create additional tablespaces for an new database?

1031

How many categories of data types?

999

Can you assign multiple query result rows to a variable?

993

How to use fetch statement in a loop?

1024

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

600

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

589

Un-Answered Questions { Oracle }

What is an oracle cursor variable?

1083

How many dba can you have?

546

How to create a table index in oracle?

1135

How many types of segments in Oracle?

1074

What happens if the update subquery returns multiple rows?

1120

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1900

Have you created sequence? When will you use?

566

What degree do database administrators need?

552

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1789

State any two functions of oracle?

1047

How to create a table index?

1156

How do we get field details of a table?

982

List the types of joins used in writing subqueries?

998

Explain the features of oracle?

1054

How to find the duplicate rows count from employees table in oracle?

1097

For More Un-Answered { Oracle } Questions Click Here