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?

948

How to execute a stored program unit?

1019

How to load data from external tables to regular tables?

1005

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

964

How to drop a tablespace?

1002

How to retrieve the count of updated rows?

1070

What happens to the indexes if a table is recovered?

952

How to get execution path reports on query statements?

943

How to add another datafile to a tablespace?

1002

How to assign values to variables?

1059

How to retrieve data from an cursor to a record?

1038

How to save query output to a local file?

982

How to export your own schema?

979

How to convert character types to numeric types?

1065

What are the system predefined user roles?

990

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Will you be able to store pictures in the database?

1075

What is an oracle recycle bin?

945

what are actual and formal parameters?

1060

What is backup in Oracle?

964

Why is oracle so popular?

945

Can we store images in oracle database?

954

List out the components of logical database structure of oracle database.

997

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2269

What are triggers in oracle?

982

What is literal?

960

What is the difference between a primary key & a unique key?

1049

What is merge in oracle?

1002

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2216

What is dual table oracle?

934

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?

2781

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