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

Explain an extent?

1109

Explain what does a control file contain?

1105

Explain a synonym?

1034

What is data file?

1110

Explain do view contain data?

1016

Explain an index segment?

1124

What is redo log?

1071

What is the difference between recovery and restoring of the oracle database?

1223

What is the difference between oracle media recovery and crash recovery?

1177

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1170

What is an Oracle database Partial Backup?

1167

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1353

What is an Oracle database Full Backup?

1135

What is Restricted Mode of Instance Startup in Oracle?

1201

Why more redos are generated when the oracle database is in begin backup mode?

1129

Un-Answered Questions { Oracle }

Who is dba in dbms?

583

Does oracle partitioning improve performance?

1004

Compare and contrast between sql and sql server and explain its various functions?

970

Define oracle database

1049

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

635

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1789

Explain procedure to change characterset of a database.

641

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

What is an Oracle Rollback Segment?

1124

How many types of tables are there in oracle?

1062

What is oracle in java?

977

How long does it take to learn database administration?

562

When should you increase copy latches?

649

How to load data from external tables to regular tables?

1063

How does one coalesce free space?

554

For More Un-Answered { Oracle } Questions Click Here