how to write test cases for testing databases,especially
for testing and writing test cases for stored
procedures.any real time database testers.please answer me.
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
36
Explain sp_configure commands, set commands?
110
My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
Hello everybody, my self is Imtiyaz, i made a small
database programm for challan in MS Access, but i am facing
one problem in it...
if u have seen any challan, it has few boxes like, crore,
lacks, thousands, hundred, ten.....and when you put a
figure like 20536, at that time in that boxis TWENTY will
wrote in "thousand" box FIVE will be in "hundred" box and
THIREE will be in "ten" box......
so, in sort i need to know that how can i do module for
this that it appears automatically in perticular
boxs...thanks
23
What is Tab Query
Whats its advantage over Sql-Query
To Refer this Site to Your Friends 
Site Map