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

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

How to turn on or off recycle bin for the session?

1109

What are the logical operations?

1125

How to list all indexes in your schema?

1093

What is the data pump export utility?

1081

How to create a new table in your schema?

1081

What happens to the data files if a tablespace is dropped?

1059

How to see free space of each tablespace?

1035

How to use "out" parameter properly?

1082

Can you drop an index associated with a unique or primary key constraint?

1019

Un-Answered Questions { Oracle }

How to export data to a csv file?

1305

How to view the tablespaces in the current database?

978

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2623

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

550

How to get last row id?

992

How do I spool to a csv formatted file using sqlplus?

1033

What is variable and how many types of variable?

586

What is File steps?

619

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2185

What is snapshot is too old? Give and example for better understand.

1603

Mention what are the benefits of oracle rac?

Is there any function in oracle similar like group_concat of mysql?

1053

How to lock and unlock a user account in oracle?

1106

How to unlock the sample user account in oracle?

1016

List out the components of logical database structure of oracle database.

1036

For More Un-Answered { Oracle } Questions Click Here