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

Oracle General Interview Questions

Questions Answers Views Company eMail

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1063

Can you create a synonym without having a table?

1090

What are the components of logical database structure in oracle database?

1131

What is the usage of save points in oracle database?

1011

What is the relationship among database, tablespace and data file?

1034

What is the difference between hot backup and cold backup in oracle?

1075

What is a system tablespace and when it is created?

1013

What are the different types of database objects?

1114

What is logical backup in oracle?

1081

What are the extensions used by oracle reports?

1085

What is the meaning of recursive hints in oracle?

1094

What is bulk copy or bcp in oracle?

1181

What is the usage of control file in oracle?

1141

What is the usage of synonyms?

1210

What types of joins are used in writing subqueries?

1030

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why is oracle used?

978

What are the differences between number and binary_float in oracle?

1147

What is a server parameter file in oracle?

1095

Please explain drop constraint oracle?

1155

State the difference between a primary key and foreign key?

994

List out the difference between commit, rollback, and savepoint?

1088

what is the scripts in data base?

2216

What is hot backup and logical backup?

1111

What is oracle and what are its different editions?

1118

What are named parameters?

1142

In what script is snap$ created? In what script is the scott/tiger schema created?

2757

Is there any function in oracle similar like group_concat of mysql?

1103

What are group functions in oracle?

1092

What are oracle functions?

1087

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

1059

For More Un-Answered { Oracle General } Questions Click Here