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

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

Oracle Interview Questions

Questions Answers Views Company eMail

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

2395

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

2554

how to create an user in oracle 10g.please give me an example..

1 4935

please explain about oracle

1 3795

what are the tools used for oracle 10g in real time.

IBM,

2503

what are the advantages of Oracle over other databases..? please give me reply...

2 11156

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 8067

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

1 3920

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?

2315

definition of cluster and non-clustered index?

CSS,

3115

how to get the index id?

Cognizant, TCS,

1 5719

Difference between join and a subquery?

Base Automation, NMDC,

8 45378

What does TKPROF stand for?

5 14393

How to find no of saturdays in a month using single sql ?

2 5787

How to create index-by table in oracle?

3 6706

Un-Answered Questions { Oracle }

What are the main components of an oracle rac system?

please explain.. DB architecture ...

2088

Give the different types of rollback segments.

1084

Is oracle a language?

994

What is the difference between formal parameters and actual parameters?

1160

What are the different tools that are provided by oracle to assist performance monitoring?

What is the sequence of firing in report trigger?

What is coalesce function?

1149

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2157

How to call a sub procedure?

1150

Explain the use of parfile option in exp command.

1149

How to use subqueries in the from clause in oracle?

1170

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

2035

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

645

How is clustered database important in oracle rac architecture?

For More Un-Answered { Oracle } Questions Click Here