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?

1921

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

1951

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

1 4034

please explain about oracle

1 2999

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

IBM,

1929

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

2 9765

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 6966

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

1 3073

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?

1805

definition of cluster and non-clustered index?

CSS,

2479

how to get the index id?

Cognizant, TCS,

1 4894

Difference between join and a subquery?

Base Automation, NMDC,

8 42455

What does TKPROF stand for?

5 12482

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

2 4754

How to create index-by table in oracle?

3 5259


Un-Answered Questions { Oracle }

How to initialize variables with default values?

634


What is the difference between a hot backup and a cold backup in oracle?

573


How to connect to a local oracle 10g xe server?

534


HOW TO SPOT AHIERARCHY?

1851


How do you analyze table partition using oracle provided package?

266






What is private procedure oracle?

529


Explain the difference between repeating frame and frame.

1


How to create a new table in oracle?

591


What is meant by an index?

619


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

292


What is the difference between restoring a database and recovering a database?

1


What is Java Pool in Oracle?

604


did u received a single file or multiple files

1608


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1649


What is a trigger and what are its types in oracle?

534