Oracle Interview Questions

Use DBMS_PROFILER to tell you exactly which lines in the PL/SQL code are taking time.

You can use DBMS_UTILITY.GET_TIME procedure.

We can Read and Write BLOB Data to a Database Table Through an Anonymous PL/SQL Block .The primary advantage of using anonymous PL/SQL blocks is improved performance -they can be used to batch a ser...

 The ROLLUP is an extension to the GROUP BY caluse. the rollup operator can be used by report writes to extract statistics and summary information from results sets. the rollup operator creates g...

If this term is ROLAP-Relational Online Analytial Processing. ROLAP is a flexible architecture that scales to meet the widest variety of DSS and OLAP needs. ROLAP architecture access da...

V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE'  shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also hel...

is it drived ? Are you sure ..

I think is is Derived.

when u create pfile from spfile then u can give ur perticular location according to u like

create pfile = 'ur specified location' from spfile ;

This command does not change the location and path of the pfile. It changes only contents of pfile. Contents of Pfile are replaced by the contents of Spfile(in readable format).

The SELECT command'S syntax in SQL Server is different than Oracle.In SQL Server you don't need (always) to select data from a source (using FROM).you can just select a variable.What SQL Server dose i...