Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 4968

LOV can best describe a) window b)modal c)list d) none of these d)

ESS,

5 7361

can u plz provide me oca sql dumps please i need them

1947

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

Sierra Atlantica,

2008

what is the difference between data migration and production migration.

2346

candidate key is subset of super key but not vice-verse explain

2068

can u give guidance abt packages of plsql

Mphasis,

2174

"primary key=unique+null" is equal,reson?not,reason?

5 7279

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2230

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2209

what is shared memory?

IBM,

1 4297

what is semphore explian it?

IBM,

2815

what is the link between suppliers and banks in ap module in oracle apps? And also query?

Polaris,

2472

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

BOB Technologies, Cap Gemini, IBM,

2 9191

Un-Answered Questions { Oracle }

What are record groups ? Explain the types of record group.

What do you mean by oracle dba?

570

How to select some rows from a table in oracle?

1077

What is a flashback query and when should it be used?

What is a dba programmer?

577

What is the load plans in odi?

633

How can be determining the size of the log files?

582

what are savepoint mode and cursor mode properties ?

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

What is a database table in oracle?

1021

Is rowid unique in oracle?

998

How do I manually uninstall oracle client?

1084

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2622

What are the uses of linked server and explain it in detail?

1059

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

For More Un-Answered { Oracle } Questions Click Here