Where do we use decode and case statements?

549

What is ADDM Advisor in Oracle?

653

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1498

What is rich query?

536

What is concurrency in oracle?

538

In what script is snap$ created? In what script is the scott/tiger schema created?

2235

How many types of auditing in Oracle?

559

What is the difference between online and offline backups?

558

WHAT IS ecc 6.0

1647

How to check the server version in oracle?

607

How can we view last record added to a table?

591

What are the different types of database objects?

520

What is a cursor variable?

564

How to create a table index?

556

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4247