Explain the difference between a FUNCTION, PROCEDURE and
Illustrate how to determine the amount of physical CPUs a
Unix Box possesses (LINUX and/or Solaris).
what is the role of dip user in our database?
What are statistics, under what circumstances they go out
of date, how do you update them?
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
How to craeate the New Database Schema in Oracle and mysql?
Please tell me with Example?
How can you tell how much space is left on a given file
system and how much space each of the file system's
What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
How to start SQL Server in minimal configuration mode?
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
which background process invoke at the time of upgradation tell me???
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB