Explain the difference between a FUNCTION, PROCEDURE and
can u plz tell me what r the mandatory skills for getting
job as a sql dba......plz send me all details thank you
my id :email@example.com
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
Illustrate how to determine the amount of physical CPUs a
Unix Box possesses (LINUX and/or Solaris).
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
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?
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
In oracle 10g export, import if we declare rows=y/n what would
be the output?
what is logical system in sap basis
What is the recommended interval at which to run statspack
snapshots, and why?
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?