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 4449

please explain.. DB architecture ...

1978

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 4620

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

1888

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

2 4067

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

BPO, Excel, Wipro,

9 17347

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??

1989

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 4145

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

1 4885

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

2076

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

2298

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

2443

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 7852

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

1 3764

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?

2216

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to return top 5 rows in oracle?

1005

What is oracle instant client?

978

How to create a temporary table in oracle?

1210

How will you write a query to get a 5th rank student from a table student_report?

1821

What are the numeric comparison operations?

1065

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1024

What are the major difference between truncate and delete?

999

Is postgres faster than oracle?

980

How to name query output columns in oracle?

1144

Can you drop an index associated with a unique or primary key constraint?

979

What are internal user account in oracle?

953

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2010

Is oracle a programming language?

948

How can I introduce multiple conditions in like operator?

933

What is oracle open database communication (odbc)?

975

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