1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

Explain implicit cursor.

 560

Explain mutating triggers.

 577

Give the different types of rollback segments.

 583

How can you use check constraints for self referential integrity?

 526

How many types of database triggers exist?

 578

Give the various exception types.

 551

List the parts of a database trigger.

 584

Explain oracle’s server parameter file.

 571

Explain overloading. Can functions be overloaded?

 577

Give the advantages and disadvantages of clusters.

 579

Define oracle database

 597

Explain oracle instance.

 686

What is ceil and floor in oracle?

 579

Can a parameter be passed to a cursor?

 600

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

 595

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How can we force the database to use the user specified rollback segment?

562

How to write date and time literals in oracle?

558

How do I limit the number of rows returned by an oracle query after ordering?

641

What are the general rules on data consistency?

589

What are the different pseudo commands? Explain in general?

542




What are the various constraints used in oracle?

556

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

595

What is a snapshot log?

564

Explain the use of analyse option in exp command.

590

What are the different types of trigger and explain its various uses and functions?

554

How to call a stored function with parameters?

564

What is catalog in Oracle?

655

how the indexes are stored in the Oracle Database?

1742

How to get maxsal , minsal, ename department wise in single query

1027

How index is implemented in oracle database?

598

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