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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a table index?

1098

How a database is related to tablespaces?

1031

How to define a specific record type?

1084

How to estimate disk space needed for an export job?

1050

How to use "if" statements on multiple conditions?

1174

What is the data pump import utility?

1035

How to update a table row with a record?

1009

What is an index associated with a constraint?

1040

What are the numeric comparison operations?

1111

How to delete a column in an existing table?

1076

How to use an explicit cursor without open statements?

1055

Can multiple cursors being opened at the same time?

1060

How to invoke the data pump import utility?

1162

How to pass a cursor variable to a procedure?

1109

How to view the data files in the current database?

1098

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2073

What is the implicit cursor in oracle?

1105

What is the difference between I and G in Oracle?

1099

What is a dynamic performance view in oracle?

991

What is the difference between truncate & delete command?

1182

How to select some columns from a table in oracle?

1093

Difference between hot backup vs. Cold backup?

991

What are the different types of synonyms?

1140

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

How to list all user accounts in oracle?

1027

What are the uses of Database Trigger ?

1720

How to use null as conditions in oracle?

1084

What is the maximum limit on the number of columns in a table?

1086

How to display row numbers with the records?

1079

What is ASM (Automatic Storage Management) in Oracle?

1196

For More Un-Answered { Oracle General } Questions Click Here