1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

Explain an extent?

 651

Explain what does a control file contain?

 601

Explain a synonym?

 590

What is data file?

 606

Explain do view contain data?

 574

Explain an index segment?

 631

What is redo log?

 615

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

 652

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

 663

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

 640

What is an Oracle database Partial Backup?

 687

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?

 693

What is an Oracle database Full Backup?

 624

What is Restricted Mode of Instance Startup in Oracle?

 667

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

 655

Un-Answered Questions { Oracle }

Difference between pre-select and pre-query

563

Explain each trigger related to mouse.

1

What are the uses of synonyms?

594

What is oracle used for?

527

Please explain compound trigger in oracle?

587




How to drop an existing view in oracle?

558

How to fetch the row which has the max value for a column?

530

How do we create privileges in oracle?

577

How to pass a cursor variable to a procedure?

548

What is the difference between sharding and partitioning?

493

What are dba privileges?

253

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1772

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

547

How does the on-delete-cascade statement work?

599

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

640

For More Un-Answered { Oracle } Questions Click Here