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 is grid in Oracle 10g...

1 4528

please explain.. DB architecture ...

2029

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 4689

Hi Can any one tell me what are the API's used in requisition import.

1926

How do we switch from init.ora file to asp file?

2 4193

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

BPO, Excel, Wipro,

9 17620

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2034

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 4216

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 4969

what are steps for interface? where is exchange rate defined in which table?

2162

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 7956

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 3835

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2268

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

How to define a variable of a specific record type?

1080

What is oracle database 10g express edition?

1123

What is pragma autonomous transaction in oracle?

1074

Explain self joins in oracle?

1025

How do I start tns listener?

1051

Explain parameter file in oracle.

1035

What is rowid and rownum in oracle?

1011

How to get execution statistics reports on query statements?

1103

Please explain oracle left join with an example?

1052

How to calculate date and time differences in oracle?

1044

Explain the use of parfile option in exp command.

1071

Explain an extent?

1109

How to create tables for odbc connection testing?

1123

What are advantages of dateset in datastage?

2263

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