Provide names of classes that are used in database connection using Oracle,access database, and msde
Insert data tp blob data type column
If we create a table having a column of blob data type then how we have to insert and retrieve the data?
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...
What is "rollup" and "cube"? How does these different from "groupby"
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...
What is the name of the avilable view in Oracle used for monitoring hot backup.Deep
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...
What are the "drived attributes or drived values"?
is it drived ? Are you sure ..
I think is is Derived.
When we create a PFile from a spfile with: create PFile from spfile, where does the PFile go?
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).
Oracle dual table equivalant in SQL server
In Oracle we are using dual table name for the temporary purpose. Which table we are using in SQL server
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...
Oracle Backup and Recovery Interview Questions
Oracle Basics Interview Questions
Oracle Architecture Interview Questions
Data Access Interview Questions
Oracle DBA Interview Questions
Oracle security Interview Questions
Oracle Distributed Processing Interview Questions
Oracle Concepts Interview Questions
Oracle Memory Management Interview Questions
Oracle Forms Interview Questions
Programmatic Constructs Interview Questions
Real time Oracle Interview Questions
Oracle SQL Interview Questions
Oracle System Architecture 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.