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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to use windows user to connect to the server?

988

How to execute a stored program unit?

1074

How to load data from external tables to regular tables?

1062

What happens to the current transaction if a ddl statement is executed?

1013

How to drop a tablespace?

1043

How to retrieve the count of updated rows?

1127

What happens to the indexes if a table is recovered?

993

How to get execution path reports on query statements?

987

How to add another datafile to a tablespace?

1040

How to assign values to variables?

1102

How to retrieve data from an cursor to a record?

1102

How to save query output to a local file?

1026

How to export your own schema?

1007

How to convert character types to numeric types?

1132

What are the system predefined user roles?

1041

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How are extents allocated to a segment?

1125

Can select statements be used on views in oracle?

1027

What is meant by joins? List out the types of joins.

1031

How to bring a tablespace offline?

1064

How to create an initialization parameter file?

1049

What is an oracle user account?

990

What happens if you lost a data file?

1034

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

1067

What are the system predefined user roles?

1041

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

How to set up autotrace for a user account?

1059

What is materialized view in Oracle?

1074

What is an oracle cursor variable?

1075

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

1090

What are triggers in oracle?

1039

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