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

What are the built-ins used for processing rows?

1 5879

What are the built-ins used for finding object ID functions?

2 4413

Use the add_group_column function to add a column to record group that was created at a design time?

2 5413

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

2 8743

What are parameters?

1 4114

What are the Built-ins used for sending Parameters to forms?

2 4727

What is the maximum no of chars the parameter can store?

1 3706

How do you call other Oracle Products from Oracle Forms?

1 5982

How do you reference a Parameter?

1 4068

How do you reference a parameter indirectly?

1 4074

What are the different Parameter types?

2 4706

When do you use data parameter type?

1 3509

Can you pass data parametrs to forms?

1 4028

What are different types of images?

1 3408

What is the difference between boiler plat images and image items?

1 4209

Un-Answered Questions { Oracle }

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

2497

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

What is the page protect in reports?

What is oracle full backup?

570

How to add a new column to an existing table with a default value?

1016

Explain what are the type of synonyms?

1111

What privilege is needed for a user to create tables in oracle?

953

Explain master-detail relationship with some examples.

1004

How would you begin to troubleshoot an ORA-3113 error?

2077

what systems can odi extract and load data into?

591

Which is the best option used to move database from one server to another serve on same network and why?

547

How to define an oracle sub procedure?

1144

What is an Oracle Data Block?

1058

What is the difference between count (*), count (expression), count (distinct expression)?

1004

What is raw datatype in oracle?

1133

For More Un-Answered { Oracle } Questions Click Here