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?

2337

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

2493

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

1 4845

please explain about oracle

1 3714

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

IBM,

2437

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

2 11033

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 7934

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

1 3825

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?

2254

definition of cluster and non-clustered index?

CSS,

3027

how to get the index id?

Cognizant, TCS,

1 5642

Difference between join and a subquery?

Base Automation, NMDC,

8 45070

What does TKPROF stand for?

5 14197

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

2 5694

How to create index-by table in oracle?

3 6567

Un-Answered Questions { Oracle }

How do I find the database name in oracle?

1033

How to convert characters to numbers in oracle?

1063

How to avoid duplicate entries in the forms?

How to display row numbers with the records?

1073

What are the key components of oracle’s maximum availability architecture?

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

575

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3932

Mention what is oracle real application clusters?

How many types of canvases are there.

how to write the sub-queries in odi?

701

Does my odi infrastructure require an oracle database?

555

What is oracle dba role?

573

What is the sql query to find the employee who has Nth maximum salary?

5319

Do you know table based value sets?

Give the various exception types.

989

For More Un-Answered { Oracle } Questions Click Here