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 4437

please explain.. DB architecture ...

1966

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 4593

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

1879

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

2 4038

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

BPO, Excel, Wipro,

9 17282

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

1978

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 4125

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

1 4861

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

2054

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

2292

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

2432

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 7827

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

1 3742

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?

2197

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is ceil and floor in oracle?

1006

Explain enable novalidate constraint.

1030

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2209

what are the advantages of running a database in archive log mode?

2142

Briefly explain what is literal? Give an example where it can be used?

973

How to write a query with a left outer join in oracle?

1002

What is a lookup table in oracle?

929

Is there any function in oracle similar like group_concat of mysql?

986

What is flashback in Oracle?

963

What are the original export and import utilities?

1056

How do I find my oracle client driver version?

970

What are the oracle built-in data types?

1008

In what script is snap$ created? In what script is the scott/tiger schema created?

2654

Explain what are the type of synonyms?

1053

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2260

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