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

How to assign values to variables?

1104

How to retrieve data from an cursor to a record?

1104

How to save query output to a local file?

1027

How to export your own schema?

1007

How to convert character types to numeric types?

1135

What are the system predefined user roles?

1043

How to create a table in a specific tablespace?

976

How to create a table interactively?

1093

How to drop a stored function?

1137

How to export data to a csv file?

1306

What are the differences between interval year to month and interval day to second?

1028

How to bring a tablespace offline?

1065

What is the order of defining local variables and sub procedures/functions?

1061

How to retrieve data from an explicit cursor?

1060

What are the arithmetic operations?

1084

Un-Answered Questions { Oracle }

Write a syntax for update query in oracle?

1034

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

How would you go about verifying the network name that the local_listener is currently using?

2049

How to check your oracle database 10g xe installation?

988

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

Explain an extent?

1106

How to use "in" parameter properly?

1072

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2234

What is a tns file?

997

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

Explain integrity constraints?

1107

What is odi studio?

587

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

how to pass a variable more than one values?

650

For More Un-Answered { Oracle } Questions Click Here