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

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

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

1 4849

please explain about oracle

1 3717

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

IBM,

2441

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

2 11042

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

definition of cluster and non-clustered index?

CSS,

3035

how to get the index id?

Cognizant, TCS,

1 5651

Difference between join and a subquery?

Base Automation, NMDC,

8 45094

What does TKPROF stand for?

5 14219

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

2 5701

How to create index-by table in oracle?

3 6583

Un-Answered Questions { Oracle }

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2322

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

How will you run ms_batch file in forms?

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1883

What are different types of transactions in ar? : oracle accounts receivable

1296

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1016

How can be determining the size of the log files?

583

What are the database administrators utilities available?

1031

How to create a table in a specific tablespace?

976

How to create id with auto_increment on oracle?

990

What operating systems are supported by oracle database 10g xe?

1034

How do I limit the number of rows returned by an oracle query after ordering?

1169

Difference between cartesian join and cross join?

1039

Explain the truncate in oracle?

967

For More Un-Answered { Oracle } Questions Click Here