What is the implicit cursor in oracle?

1044

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1866

State some uses of redo log files?

951

What are the built-in functions used for sending Parameters to forms ?

3318

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2776

master table and child table performances and comparisons in Oracle ?

2077

Give the various rollback segment states.

1005

What are advantages of dateset in datastage?

2208

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1961

how to join query for one source type is oracle another source type is sql server ?

2387

Difference between inner join vs where ?

983

What are the general rules on data consistency?

962

Can we protect our pl/sql source code?

994

How to delete a user account in oracle?

920

Explain the use of record option in exp command.

952