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?

1048

How to execute a stored program unit?

1128

How to load data from external tables to regular tables?

1108

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

1063

How to drop a tablespace?

1088

How to retrieve the count of updated rows?

1198

What happens to the indexes if a table is recovered?

1049

How to get execution path reports on query statements?

1046

How to add another datafile to a tablespace?

1095

How to assign values to variables?

1168

How to retrieve data from an cursor to a record?

1162

How to save query output to a local file?

1089

How to export your own schema?

1051

How to convert character types to numeric types?

1195

What are the system predefined user roles?

1100

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new tablespace in oracle?

1037

Where are the settings stored for each instance in oracle?

1158

How to define an anonymous block?

1249

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2046

what is the use of system.effective.date variable in oracle?

1164

How translate command is different from replace?

1142

Can we write dml statement in function in oracle?

1127

What happens to the current transaction if the session is killed?

1043

What is tns name?

1029

List the parts of a database trigger.

1113

What are the system predefined user roles?

1100

How to convert character types to numeric types?

1195

How to convert characters to numbers in oracle?

1115

What is recovery manager(rman) backup in Oracle?

1233

How to increment dates by 1 in oracle?

1138

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