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?

1045

How to execute a stored program unit?

1128

How to load data from external tables to regular tables?

1102

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

1059

How to drop a tablespace?

1084

How to retrieve the count of updated rows?

1192

What happens to the indexes if a table is recovered?

1045

How to get execution path reports on query statements?

1043

How to add another datafile to a tablespace?

1088

How to assign values to variables?

1163

How to retrieve data from an cursor to a record?

1156

How to save query output to a local file?

1084

How to export your own schema?

1051

How to convert character types to numeric types?

1193

What are the system predefined user roles?

1098

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to loop through data rows in the implicit cursor?

1120

What is an index associated with a constraint?

1089

Define oracle database

1098

How many types of table in Oracle?

1172

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2228

What are the uses of Database Trigger ?

1784

How to use "out" parameter properly?

1123

Does oracle partitioning improve performance?

1051

Explain database link?

1174

How to use an explicit cursor without open statements?

1101

What is blob datatype?

1196

What are the attributes of cursor?

1104

What is the exact use of Collections?

2190

Why packages are used in oracle?

1118

How do I uninstall oracle 11g?

1176

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