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 4521

please explain.. DB architecture ...

2020

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 4686

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

1923

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

2 4184

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

BPO, Excel, Wipro,

9 17601

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

2026

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 4212

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

1 4962

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

2158

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

2497

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 7945

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

1 3833

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?

2260

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

What are the tools for Oracle ?

1062

How to open a cursor variable?

1035

Give the various exception types.

993

How to define a sub function?

1129

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

Explain the use of full option in exp command.

1116

What is a sub query and what are the different types of subqueries?

1125

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

What are the common oracle dba tasks?

1147

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

How to find the duplicate rows count from employees table in oracle?

1091

How many types of synonyms in Oracle?

1124

What are the original export and import utilities?

1170

How do we display rows from the table without duplicates?

972

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