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

Explain the different levels at which oracle form services interact.

1009

In what sequence do triggers get fired by oracle forms?

917

What do you understand by lov and how can it be used?

1026

What is a matrix report and how many minimum groups are required to prepare the same?

1072

Name the different triggers associated with oracle forms having a master-detail relationship.

937

List the different types of columns in oracle reports.

944

Explain master-detail relationship with some examples.

955

What is the difference between bind and lexical parameter?

1022

Can we invoke one form from another in a multi-forms application?

1089

How can we generate report output in excel format?

947

Why oracle forms required?

984

What is an oracle report?

999

Can we convert a date to char in oracle and if so, what would be the syntax?

969

What is oracle and what are its different editions?

1016

What is the difference between substr & instr functions?

1136

Un-Answered Questions { Oracle }

what is difference between group above and group left report

3765

What is key.next.item trigger?

Can we connect to ORACLE db using Windows Authentication?

1196

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

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4501

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1641

where do u put the report file

2048

What is an Oracle Data Dictionary?

1054

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

541

How many categories of data types in oracle?

974

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)

2269

What is the difference between cold backup and hot backup?

550

what is the use of system.effective.date variable in oracle?

1066

What is an oracle report? List its various types.

927

What is dba training?

502

For More Un-Answered { Oracle } Questions Click Here