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 4581

please explain.. DB architecture ...

2080

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 4765

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

1964

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

2 4277

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

BPO, Excel, Wipro,

9 17879

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

2082

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 4270

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

1 5032

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

2234

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

2385

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

2544

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 8049

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

1 3911

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?

2311

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create lov dynamically at runtime & attach to text field?

1238

Calculate difference between 2 date / times in oracle sql?

1097

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

2007

How to delete an existing row from a table in oracle?

1127

Is there a function to split a string in plsql?

1106

What is a connect identifier?

1084

How to load excel data sheet to oracle database

1072

What are the arithmetic operations?

1146

Is oracle an operator?

982

How to store only time; not date and time?

1066

How to create a table in a specific tablespace?

1020

How many types of cluster table in Oracle?

1079

How to write an inner join with the where clause in oracle?

1089

What is coalesce function?

1142

How to connect to a remote server?

1187

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