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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to import one table back from a dump file?

1091

How to start your 10g xe server from command line?

1133

How to invoke the data pump export utility?

1260

How to define an anonymous block?

1250

How to list all tables in your schema?

1123

How to use "in out" parameter properly?

1108

How to use windows user to connect to the server?

1048

How to execute a stored program unit?

1128

How to load data from external tables to regular tables?

1108

What happens to the current transaction if a ddl statement is executed?

1065

How to drop a tablespace?

1089

How to retrieve the count of updated rows?

1198

What happens to the indexes if a table is recovered?

1050

How to get execution path reports on query statements?

1047

How to add another datafile to a tablespace?

1095

Un-Answered Questions { Oracle }

How to rename an index in oracle?

1175

how to handle exceptions?

657

When do you get a .pll extension in oracle? Explain its importance

1103

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2364

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?

2315

What is oracle server autotrace in oracle?

1229

What is the difference between truncate & delete command?

1238

What do you understand by anchoring in reports?

can you convert or reverse engineer a fmx back to a fmb file?

1228

How to name query output columns in oracle?

1246

What is ora-1555 snapshot too old error? Explain in detail?

739

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

How to do clean up if create database failed?

1073

What do database buffers contain?

1083

What is Reduced List of Values?

2248

For More Un-Answered { Oracle } Questions Click Here