What is a nvl function? How can it be used?

961

What is the data pump export utility?

1023

What is the difference between 10g OEM and 11g OEM?

922

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2205

How do I spool to a csv formatted file using sqlplus?

967

Explain the function of optimizer in oracle?

1061

Explain rename?

928

What is the meaning of recursive hints in oracle?

995

What are ddl statements in oracle?

1020

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

976

What are the different pseudo commands? Explain in general?

1022

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2022

What happens to the data files if a tablespace is dropped?

998

What is a initialization parameter file in oracle?

990

How is it different from a normal table?

970